fpereiras (5/27/2009)

---

homebrew01 (5/27/2009)

---

Not quite sure what you mean.

Windows authentication works if I remote onto...

Not quite sure what you mean.

Windows authentication works if I remote onto 1 server,...

No I didn't test it in dev. It was a bit of a rush. Took a chance and added the column and updated it later with data. Got lucky and...

Is your boss aware of the current problem doing the restore ? What does he say about it ?

Last I knew, you could not use Veritas to restore to...

And if you want a quick view of all your database sizes alphabetically:

IF OBJECT_ID('tempdb..#t') IS NOT NULL

DROP TABLE #dbsize

CREATE TABLE #dbsize

(DB_Name sysname

,size int)

--now load the temp table

INSERT INTO #dbsize

exec...

Jeffrey Williams (4/27/2009)

---

Okay, there are a couple of issues with your plan - but I'll get to that later. The Maintenance Plan cleanup task has several options that need...

Use the GUI but don't save the changes. then generate the script to a new query window and it will build your T-SQL script for you.

I found this in my old SQL 2000 scripts and it will work in 2005. You could put the 2 sets of results to work tables and then compare them.

select...

Would a transaction log backup be advisable now ? Then you can apply it (them) to your old full backup.

I missed it too ... Thanks !

Thanks .... That looks like it should work, but I get "Argument data type int is invalid for argument 1 of substring function."

Maybe it doesn't like the columns being varchar...

On the first day. You need disaster recovery in place for your developement area.

Since the OP didn't give us much info, we're left to speculate wildly to cover all possible scenarios.

Ratheesh.K.Nair (5/5/2009)

---

U mean the issue is due to SQL server?

Shrink the db having high log file size.

Check the temp DB, if its huge and ur server is not production then...

DTSRun /S ServerName /E /N"PackageName"

see: http://msdn.microsoft.com/en-us/library/aa224467(SQL.80).aspx