Viewing 15 posts - 1,651 through 1,665 (of 1,790 total)
Andy - Not supported by MS when you have multiple log files. Don't have a clue as to why but, not supported.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 9, 2002 at 1:46 pm
It should look something like this. I changed your column names so that I could use them myself when writing this. Ultimately this is called Correlated SubQueries and is based...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 9, 2002 at 12:22 pm
Sorry, didn't read the full description this is 6.5. I believe the sp_detach_db solution should still work.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 9, 2002 at 11:45 am
You can detach the database and then reattach with the new locations. See BOL for reference in T-SQL or EM if SQL 2000 (look up sp_detach_db and sp_attach_db)
Hope this...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 9, 2002 at 11:40 am
Ultimately, you have the answer. It's either the backup or nothing. Everything that I have seen from MS verifies what you have stated and even trying to fool it by...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 9, 2002 at 9:39 am
Here is a recent oops for all to enjoy. My expense.. have fun.
Upgrading a server to Windows 2000 and SQL Server 2000 and additionally expanding the drive sets for the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 8, 2002 at 12:04 pm
Yes. Glad to help.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 8, 2002 at 12:04 pm
Anytime that you are working with Send Mail from a DTS package there are four points to check as follows;
1. The job that is running the DTS package owner.
2. The...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 8, 2002 at 10:27 am
Check out article Q303411.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q303411
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 8, 2002 at 7:22 am
I'm afraid I will have to call in the likes of Andy Warren for this one. More his style. I am in the process of learning how to use ADO...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 4, 2002 at 3:25 pm
My pleasure and I too have been there. Glad to help.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 4, 2002 at 2:42 pm
Try changing the default options (deselect "use default options" click on options) and removing the check in "copy database users and database roles" option. Also deselect any of the other...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 4, 2002 at 2:32 pm
That's where the job comes in. Even though you only want to execute this from a stored procedure, it is not possible to call the DTS package from T-SQL directly....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 2, 2002 at 12:31 pm
Sorry, should have been more explicit. It sounds like you will need to creat a DTS package that will manage the table, index, etc moves and then schedule that package...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 2, 2002 at 10:27 am
I personally use Steve's second suggestion, sp_start_job, and it works great. Works great across linked servers as well.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 2, 2002 at 8:35 am
Viewing 15 posts - 1,651 through 1,665 (of 1,790 total)