Animal Magic (11/12/2008)

---

Thanks for the quick reply Gail, its the transaction log on the publicated database. I have just found out one of the developers has indeed run an...

Use Enterprise manager to generate a script that contains all of the procedures and then do a find and replace. Even if you have to check each location before doing...

You can backup at any time. The backup adds load to the system, but it doesn't lock any objects.

goodguy (11/12/2008)

---

I'm not a pro like all the others who have already ventilated this thread, but what I would do in this case is restore a backup on an independent...

Is the transaction log growing or is the error log growing?

Did that happen straight after an index rebuild, by any chance? Or an alter table statement?

Please post SQL 2000 related problems in the SQL 2000 forums. If you post...

Duplicate post.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic601216-149-1.aspx

Do not, do not, do not ever directly update the system tables. Doing so is asking for big problems in the future.

Generate the scripts of the procedures, search and...

Network latency

Can you please post the table structure, some sample data and what you want as a result?

By default the only max for connections is the maximum allowed by SQL which is 32767. If you're reaching that many concurrent connections on a dev system, I think you...

You can have a look at the sys.dm_exec_query_stats DMV. That contains execution counts and CPU, read, write and duration stats.

Unfortunately the info's only there while the plan for that...

That's security through obscurity and it doesn't work. It makes it harder to find the sensitive data, not impossible.

Plus that now requires file backups synced with DB backups, careful security...

Sorry, I don't understand.

Excellent.

Just be aware that doesn't mean that the data will be returned in...