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...
MohammedU
Microsoft SQL Server MVP
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
MohammedU
Microsoft SQL Server MVP
January 27, 2007 at 11:29 am
Use the link in my previous reply to move the logins from 2000 to 2005...
MohammedU
Microsoft SQL Server MVP
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
MohammedU
Microsoft SQL Server MVP
January 26, 2007 at 11:04 pm
Are you using right email address?
http://msdn2.microsoft.com/en-us/library/ms190630.aspx
MohammedU
Microsoft SQL Server MVP
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![]()
![]()

MohammedU
Microsoft SQL Server MVP
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...
MohammedU
Microsoft SQL Server MVP
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
MohammedU
Microsoft SQL Server MVP
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...
MohammedU
Microsoft SQL Server MVP
January 26, 2007 at 1:33 pm
Reduce Upgrading Risks with the SQL Server 2005 Upgrade Handbook
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx
SQL Server 2005 Upgrade Technical Reference Guide
MohammedU
Microsoft SQL Server MVP
January 26, 2007 at 1:29 pm
After your etl process you can reinitialize subscription using tsql..
Check BOL top "How to: Reinitialize a Subscription"
MohammedU
Microsoft SQL Server MVP
January 26, 2007 at 1:11 pm
Check the database mail log for any errors..
Right click Database Mail/View database Mail log...
MohammedU
Microsoft SQL Server MVP
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
MohammedU
Microsoft SQL Server MVP
January 26, 2007 at 12:54 pm
It is working fine for my test.. see the following sample...
CREATE
TABLE BigStrings
(
BigString
VARCHAR(MAX MohammedU
Microsoft SQL Server MVP
January 26, 2007 at 12:30 pm
Before installation read the following article...
http://msdn2.microsoft.com/en-us/library/ms143516.aspx
MohammedU
Microsoft SQL Server MVP
January 26, 2007 at 12:01 pm
Viewing 15 posts - 436 through 450 (of 1,166 total)