Your choices AFAIK

1. Erwin - Expensive, but the standard tool. Works well, not as ergonomic as I would have liked. http://www3.ca.com/Solutions/Product.asp?ID=260 (interesting that it's an ASP page, huh?)

2. ER/Studio -...

Since the agent does the alerting, it cannot alert you if it goes down. Did you start the agent and then check EM? Sometimes takes a minute or two to...

Be sure you have disk space. Also, I've seen this issue with v6.5 and if you delete the old file, it should then start working.

BTW, v6.5 is no longer supported...

Or not as funny to others as to you and my wife.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

I use it on occassion.

I have seen issues where the security accounts that run SQL server change or the rights for those accounts change.

I just checked one of my...

Thanks, we appreciate the thanks and will keep working hard.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

At PASS some of the MS guys mentioned that at around 400/sec, identities become a bottleneck. GUIDs do not as there are routines optimized for their creation. Not sure...

None I'm aware of. Are you looking for something to review T-SQL code?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Likely a problem with the backup file. Can you take another?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Huge issue. DO NOT LOCK the table/row/record/whatever. The thing to do if you want it to work like this is add a flag to the table. When someone needs to...

run backups of the dbs. Detach the dbs, you can detach msdb, but might be just as easy to restore.

Uninstall SQL. If you get errors, delete the files under program...

Pronounce it however the person your're talking to does. Makes life simpler.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

From what I understand, once the mdf is created, it is Zeroed out to ensure the state of the file. This is what takes the time.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Have to test on your system and see. How many items? If it's not a large enough table, it will be scanned anyway.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

create procedure MySP

@var varchar(20) = null

as

if @var = null

Select * from news_items

else

Select * from news_items

where division = @var

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net