Viewing 15 posts - 436 through 450 (of 1,166 total)
I use this all the time to move logins from 2000 to 2000/2005...
Note: You may need to set the default dbs sometimes...
January 27, 2007 at 11:32 am
Use DTS or BCP to do this...
You can use OPENROWSET also...see the following link...
http://aspalliance.com/904_Generating_Excel_File_Using_SQL_Server_2000
January 27, 2007 at 11:29 am
Use the link in my previous reply to move the logins from 2000 to 2005...
January 26, 2007 at 11:25 pm
Looks like is not there any more....
Check the shortcut keys...
http://msdn2.microsoft.com/en-us/library/ms174205.aspx
January 26, 2007 at 11:04 pm
Are you using right email address?
http://msdn2.microsoft.com/en-us/library/ms190630.aspx
January 26, 2007 at 1:48 pm
May be they are running out space or they don't need any help at all from BOL
January 26, 2007 at 1:44 pm
What edition of windows you are using??? Read the following articles to get the info...
AWE Memory SQL Server Performance Tuning Tips
http://www.sql-server-performance.com/awe_memory.asp
How to configure SQL Server to use...
January 26, 2007 at 1:40 pm
May be you are looking for this...
How to transfer logins and passwords between instances of SQL Server
http://support.microsoft.com/kb/246133
January 26, 2007 at 1:35 pm
In profiler all columns will not work with all events...
Some columns works with some events and some of them are...
In 2005 MS improved it ... In 2005 when you click...
January 26, 2007 at 1:33 pm
After your etl process you can reinitialize subscription using tsql..
Check BOL top "How to: Reinitialize a Subscription"
January 26, 2007 at 1:11 pm
Check the database mail log for any errors..
Right click Database Mail/View database Mail log...
January 26, 2007 at 12:56 pm
Sorry! my bad... I didn't check the correctly that command...
Looks like you are out of luck.... you can use free third party command utilities..
http://www.picozip.com/command-line.html
January 26, 2007 at 12:54 pm
It is working fine for my test.. see the following sample...
CREATE
TABLE BigStrings
(
BigString
VARCHAR(MAX
January 26, 2007 at 12:30 pm
Before installation read the following article...
http://msdn2.microsoft.com/en-us/library/ms143516.aspx
January 26, 2007 at 12:01 pm
Viewing 15 posts - 436 through 450 (of 1,166 total)