I was just going through figuring that out today also ! ...

getdate()

When you use the Import/Export wizard, you have the option to append or replace the data ("edit mappings"). You have to go into each table to set it which...

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.