Writing CapturedSql to a file
I am trying to write my captured DDL to a file but all I get in the file are funny characters like 单??癤湥畴敲潗歲嵳. What am I doing wrong. Here is the code:private void ScriptComputedColumns(){Server svr = new Server("localhost");Database db = ...
0 answers | 3742 bytes |
Windows Installer Service
Hi i downloaded the Backward Compatibility Components MSI file from the microsoft link as i need to continue working with SQL DMO objects on SQL2005. but when i tried to install that in my client machines which is installed with W2k Proffessional SP4 its asking for windows installer latest ...
1 answers | 670 bytes |
Will SMO support vbscript soon?
I have several sql-dmo vbscripts that I use to script out db objects to files. Now I am impleemnting horizontal partitioning using the partition function/scheme - this requires the creation of a staging table on a specific filegroup (associated with a partition) to switch the partitioned data ...
2 answers | 1261 bytes |
Why doesn't SMO script out the CASCADE option on GRANT and DENY statements
I am using SMO to script out the stored procs and funtions in our SQL Server 2005 database for comparisions against SourceSafe to ensure the Source repository is up to date. However I have run into a problem. It seesm SMO doesn't include the CASCADE option on the GRANT AND DENY statements at ...
0 answers | 1354 bytes |
Why are BatchParser & Replication assemblies copied to app folder?
I've got a C# application thats using some basic SMO stuff (creating logins/users/granting rights). I've got the following references in my project:Microsoft.SqlServer.ConnectionInfo.dllMicrosoft.SqlServer.Smo.dllMicrosoft.SqlServer.SmoEnum.dllMicrosoft.SqlServer.SqlEnum.dllYet, when I ...
1 answers | 670 bytes |
Where to file product feedback (bugs, suggestions, feature requests, etc.)
See this article for details how to file product feedback:http://msdn2.microsoft.com/en-us/library/ms166362.aspxIt's highly recommended to send feedback if you have it. Every item is read and ...
0 answers | 360 bytes |
Where can I find information to execute a SQL 2K DTS pkg from VB.net prg ?
Hi; Could anyone in this forum tell me where I can find a good resource for learning what libraries I need to sucessfully run a vb.net program that executes a DTS package ? I can run the program on my machine which has SQL Server 2000 enterprise management installed. On a client machine I ...
2 answers | 972 bytes |
Where are triggers?
I have the following code: foreach (Trigger trigger in server.Databases[_database].Triggers) { But the list always shows up as empty. Am I missing something? I know there are triggers defined. Thank you. Kevin ...
2 answers | 540 bytes |
When using ListAvailableSQLServers, I only retrieve the server names not the instances
I have included the command ListAvailableSQLServers in our VB application (together with SQL Server 2000) and it successfully provided all the instance names (e.g. ROB\DEMO, ROB\AVALON, MIKEY\ABC). Recently, it only returns the server names and not their respective instances (e.g. ROB, MIKEY) ...
1 answers | 603 bytes |
When restoring - Cannot find the specified file
I am attempting to restore a backup into a database using SMO. It works great except in once scenario. The database and backup device is on my local drive (C) but when i copy the backup device to our dev server and try to restore using SMO, I get the following ...
1 answers | 1778 bytes |
What kind of things can I do with SMO?
Can I create tables, primary keys, foreign keys, database, backups, Something else? ...
1 answers | 89 bytes |
What interface does Management Studio use?
Hi,Does anyone know what interfaces Management Studio use? It does seem to retrieve information about Server/Database objects without the performance issues that SMO suffers from? How does it do it?Regards,Joginder ...
14 answers | 367 bytes |
What are the supported types that can be passed to the Database.PrefetchObjects method
When passing in some types I get the; "Prefetch objects failed for Database 'AdventureWorks'" message. I have noticed this on UserDefinedDataTypes, Triggers, and Synonyms so far, I have yet to work through them all. Where can one find a list of the supported types? Sample Code: ...
0 answers | 2456 bytes |
VS 2005 and Microsoft SQL 2000 DMO on Intel x64 server
We have written extensive sql 2000 dmo code and we can't get it to run in vs 2005. What's the trick?...
1 answers | 109 bytes |
Very urgent-Help would be greatly appreciated
My requirement is that I need to write a job in sql server 2000 in order to find the current date and time from a table. If I find the current date and current time which matches the server date and time then I need to notify the user through email. This taks is realted to Events. ...
0 answers | 297 bytes |
- Version of SQL back up file
- VBScript Runtime error '800a001c'
- VarCharMax Stored proc parameters
- Validity Checking (CheckCatalog, CheckTables, etc...)
- using WriteNotifyEventHandler with tracefiles
- Using SQL-DMO to Create new Partitions for a Horizontal Partition Strategy
- using sqlcmd to create sql script
- Using SQL DMO to connect to SQL Server 2005
- Using SMO to backup / restore a SqlExpress database
- Using SMO and ClickOnce deployment
- TransferData-Methode failed if there are more then 50 tables to transfer
- TransferData-Methode failed if there are more then 50 tables to transfer
- TransferData-Methode failed if there are more then 50 tables to transfer
- To connect to this server you must use SQL Server Management Studio or SQL Server Management Obj
- To connect to this server you must use SQL Server Management Studio or SQL Server Management Obj
- To connect to this server you must use SQL Server Management Studio or SQL Server Management
- Home - About Us - Contact - Privacy Statement - Link Exchange - Bookmark - Map.XML - Rss.Xml
- Copyright 2001-2009 by MSDN DEVELOPMENT Information Technology Co.,Ltd All rights reserved
- 18.797