RE: Missing column errors managing SQL2000

I think that will work. Need to script out your jobs and script back in to get it all working again (before/after changing out msdb). Andy http://qa.sqlservercentral.com/columnists/awarren/

RE: tempdb log ig growing

I am sure, that no one did this today. This is my authority. But for this problem I found a very unusual cure: I limited the grouth rate of tempdb log by 50Mb at a time. Once it reached 99%, it was grown by 50% and then freed up about 97% of space. So now […]

RE: Workaround needed to run sp_addlogin

I added the following procedure to a job running every minute. This seems to work OK but I am quite new to this so I would welcome any suggestions for improvement. CREATE PROCEDURE procAddLogin AS DECLARE @UserId VARCHAR (7) DECLARE @Password VARCHAR (15) DECLARE NewUserCursor CURSOR FOR SELECT UserId, tmpPassword FROM SALES WHERE (tmpAdded = […]

RE: Missing column errors managing SQL2000

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

RE: Database changes

You can definitely get it by running a trace. Why can't you kick them out of db_owners? Developers have no business making changes on a production box, definitely shouldn't be doing it without you being involved. Andy http://qa.sqlservercentral.com/columnists/awarren/

You have SQL Server 2000 service pack 3a...

RE: Scripting databases

Belov thanks for the example. Mdamera look in C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade

RE: Scripting databases

Can any one let us know where can we get scptxfr.exe ??

RE: Scripting databases

Have you taken a look at mssqlXpress. It is available from www.xpressapps.com

RE: Check SQL Server Uptime

Thanks Shas3. But what I'm looking for is something that will let me generate a report for the length of the uptime, downtime, and the start of the downtime and end of the downtime/uptime. Thanks.