Forum Replies Created
Viewing 15 posts - 36,481 through 36,495 (of 39,950 total)
-
RE: SS 2000 - sp3 Caused a problem
Not sure what you mean, but I haven't seen any issues like this and we've deployed SP3 to a couple dozen servers.
Steve Jones
-
RE: SQL Server Security Training
Mostly you'd have to learn more about what security breaches there are as well the the models for SQL Server. Some articles on this site, some on http://www.sqlsecruity.com, could also...
-
RE: DB diagram
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 -...
-
RE: how to create alert to find Agent running or not?
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...
-
RE: SQL 6.5 Can't Open Dump Device
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...
-
RE: Is Steve Jones Really Steve Jones?
Or not as funny to others as to you and my wife.
Steve Jones
-
RE: Transact-SQL Debugger
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...
-
RE: Congratulations...
Thanks, we appreciate the thanks and will keep working hard.
Steve Jones
-
RE: performance with GUID col and large tables
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...
-
RE: Code Review Tools
None I'm aware of. Are you looking for something to review T-SQL code?
Steve Jones
-
RE: Restoring backup from one server to other
Likely a problem with the backup file. Can you take another?
Steve Jones
-
RE: Auction and table locking
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...
-
RE: HELP - I'VE TRASHED MY SERVER
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...
-
RE: How to pronounce SQL
Pronounce it however the person your're talking to does. Makes life simpler.
Steve Jones
-
RE: Length of Time for a 45 GB Database Restore
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
Viewing 15 posts - 36,481 through 36,495 (of 39,950 total)