Hi, I am using a DTS Package to call another DTS Package using the 'Execute Package' Task. I need to pass a value to one of the Child Package's Global Variables. I managed to do all of this. Now I want to automate this process by calling the Child Package multiple times assigning it a […]
2002-02-15
5 reads
Do I have to run the Database Copy Wizard, or can I use a backup copy to restore a database to SQL 2000?
2002-02-14
Hello. I have a problem with the scheduling of DTS packages in a SQL 2000 Cluster (active / active). The problem goes like this: (Everything I will talk from now on is from the console of the Cluster Machine) - I have a DTS package (it does not mind the type of Task). The package […]
2002-02-14
22 reads
Please help! I have been asked to write DTS Standards. I am definately a newbie (< 2 years experience) and am unsure what to include. Any advice, or recommended readings, on: DTS Security (password protect pkgs or not\deny access to sp_add_dtspackage to prevent saving on prod servers?) Running DTS on a app server VS running […]
2002-02-11
3 reads
[Microsoft][ODBC SQL Server Driver]insert Error: Column name or number of supplied values does not match table definition I encountered the above message in my financial application after configuring the replication, my application is working before replication. thanks Peter 20394
2002-02-04
In this article by Neil Weicher, he talks about encryption of data and files for SQL Server.
2002-01-30
6,769 reads
SQL Server does not come with a median or mode (for that matter) function outside of Analysis Services. Does anyone know of a good T-SQL method of implementing a true median. I'd prefer not having to use temporary tables but I'm not ruling them out. A median is defined as the middle value of a […]
2002-01-29
Sometimes it is necessary to run the DBCC Checkdb command with various repair options. I put the database I wish to correct in single user mode and run the repair procedure. However, even in single user mode, if a user attempts to connect to the database, the repair fails. We run SQL 7.0 on a […]
2002-01-25
1 reads
I have a stored procedure that creates a clustered index on a temp table which works great. Now I want to change the index to be able to use it in another stored procedure but I need for one of the columns to be DESC. Here is the clustered index: create clustered index pn_loc_recvdate on […]
2002-01-24
2 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/bkelley/normalization.asp
2002-01-20
39 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers