Viewing 15 posts - 226 through 240 (of 597 total)
For a strat see http://www.sqlservercentral.com/columnists/wbrown/fourofakindbackupsoftwareshootoutpart2.asp as well as part 1 for a detailed description of 4 different software to help with backups
September 27, 2005 at 9:32 am
See http://support.microsoft.com/default.aspx?scid=kb;en-us;828339
You may want to check what you were doing when this error occured. If you were writing backups the verify the backup drive exists and is ok. Can...
September 23, 2005 at 8:49 am
I just use Microsoft CDOSys. No 3rd party tool. It's part of Windows and works great. See any of the sample TSQL scripts or articles on this site.
September 22, 2005 at 7:54 am
1. See http://www.sqlservercentral.com/columnists/glarsen/migratingloginstoanotherserver.asp
2. If you set up the original server as a linked server on your new machine you could also execute the following code: (remember to change the...
September 12, 2005 at 7:46 am
How about
Warning: Dates in Calendar are closer than they appear.
or
Give me ambiguity or give me something else.
I also have a friend who uses:
Lottery: A tax on people who are...
September 9, 2005 at 3:25 pm
My process is similar except I never restore Master. I prefer to copy the users over via a script or DTS and then run a resync of the logins for...
September 9, 2005 at 1:10 pm
DDL triggers are new in SQL 2005. The only triggers available for SQL 200 are DML (INSERT/UPDATE/DELETE). You can however use sp_trace_setevent see BOL. Eventid 46 is Object created and...
September 8, 2005 at 12:54 pm
This sqlexpert product is now a part of the Quest Central for SQL Server tool marketed by Quest now. see http://www.quest.com/Quest_Central_for_SQL_Server/sql_tuning/sql--tuning.asp
I looked at the product demo. Very interesting, in...
September 8, 2005 at 10:43 am
Just because you need a password to read or use the backup does not mean it is encrypted. Encryption is very different from password protection and althought the two concepts are related...
September 1, 2005 at 7:49 am
Check out Mike's article on Perf Monitoring and SMTP Mail. Its related to what you want and very timely to your question.
http://www.sqlservercentral.com/columnists/mmetcalf/smtpsqlserverperformancealerts.asp
August 31, 2005 at 9:08 am
Since the current SQL 2005 has not been released as a production system any license under which you are currently using the product is NOT a production license so you...
August 25, 2005 at 8:14 am
Actually its a repeat of Monday's question (3 days ago) and it wasn't worth 21 points then. Whoops! Oh well I've made much bigger mistakes than this. Maybe this will...
August 25, 2005 at 7:36 am
If you still need help, please post your entire create statement. Also run EXEC master..xp_fixeddrives and post the results.
August 23, 2005 at 8:10 am
for example to shrink tempdev to 7 M use:
dbcc shrinkfile (tempdev, 7)
August 22, 2005 at 2:19 pm
Viewing 15 posts - 226 through 240 (of 597 total)