Topics
Started by
Posts
Last post
Anyone know why is not working? declare @sql varchar(4000), @db sysname set @db = 'master' set @…
5 replies
Hi, I have a doubt regarding DTS can we run the DTS created in SQL 2000 server in SQL server 2005? …
1 replies
Hello, In SQL 2000, I was able to issue a SQL statement like this to update the Create Date: update…
4 replies
I have a sql server which has some Biztalk databases which can grow like wildfire on a daily basis,…
4 replies
Hi, I have the code to add a file to the primary file group of a database and it worked. How do I …
5 replies
How to use this store procedure to list all sql job schedule
3 replies
Hello all. I need to find a way to monitor ddl changes in stored procedures in SQL 2000. We've had …
8 replies
How would I find out of 400 DTS packages ones referening a particular table? Thank you.
1 replies
Return null value from scope_identiy from differnt box declare @sequenceId int insert into box1.db.…
1 replies
Hi, I understand that using a data pump via DTS will not fire triggers on the destination tables al…
1 replies
Checking to see if a Trigger is enabled on a table or not. I'm running the objectproperty function …
2 replies
hi How to handle long running queires? Koteswarrao
2 replies
Hi, while working the query is taking long time to execute(longrun query)? what are the immediate s…
1 replies
Hi Transaction log file has been deleted from the database., how recover it or how to add? Thank yo…
3 replies
Yesterday we had a hardware failure (Disk Controller) on our SQL Server 2000 ENT edition (sp4) with…
1 replies
Viewing 15 topics - 2,836 through 2,850 (of 16,167 total)
You must be logged in to create new topics.