Sweet, an easy 5 points! Does anyone believe M$ is going to do this anytime soon? It would be nice to have but with the cash register constantly chiming for...

DON'T shrink unless you have a very good reason to do so. This topic has been beaten to death on this site. Do a search and you'll find very compelling...

Are you backing up across the LAN (not really recommened) or locally (faster)? Is anything else that is resource intensive running on the SQL server? Backup times are usually fairly...

Paul, anything comparable to 'Instant File Initialization' in SQL2K? We're a ways away from SQL2K5 (probably going to SQL2K8) so I'm hoping there is something in our version that I...

I personally don't care when it happened, I just want to know it happened. On a weekly basis I run the following. It stores the data for me in a...

I'd drop the indexes before truncating and recreating them AFTER loading the data. It will allow the reload to occur that much quicker because it won't be hitting your indexes.

Sorry, missed that part. We are running SQL2K Enterprise Edition, sp4+. I've seen this article and we actually used it on our Win2K server. But now that were moving to...

It may be quicker to do something like the following:

1) SELECT * INTO T1BackupNew FROM T1 - this'll create a total copy of your table

2) truncate table T1 - faster...

That was the part I was stumped on. If I tried this:

SELECT c.DBName,

c.Table_Name,

c.Row_Count ...

Or maybe this??

http://kbalertz.com/237604/Server-Agent-start-displays-error-18456.aspx

Does this work for you?

1. open enterprise manager.

2. go under management, right click the sqlserver agent, select properties

3. click on the connection tab (at the top).

4. change the sa password...

Check out the last post here and see if it applies. I don't have replication setup here but hopefully this helps.

http://www.dbforums.com/archive/index.php/t-360259.html

But, if you search this site, UNC paths for backups are not recommended because a glitch in your network during the backup could corrupt the file. Having said that, at...

Not quite spot-on for the topic line but I'd like some opinions on what I should be looked at within profiler. My scenario: I have a server, SQL2K, Win2K and...

Would be a great feature but I haven't found one. It's usually an all or nothing process. One common error here occurs when our source file contains more characters than...