This code works if I execute it separately. Sql converts it to varchar. Yes I agree the variable should be int, but I can't change it being a prod environment.

Sequence...

I don't agree at thinking that when a time value is inserted and the default is 1900-01-01 would be "wrong". You inserted a time into a type that is for...

I use OUPTPUT all the time.

Why it never occurred to use it when archiving our production tables is beyond me.

Guess who is able to save himself more code. This guy.

Thanks...

This made my day! 😀

How do you get assign a default schema to an AD group then?

In 08R2, if a user logs in, it will create a schema, a user and assign schema to...

I have SSMS 2012 installed. Does my server box have to have SQL Server 2012 installed too or will 08 R2 work?

A lot of good info here.

Can't use the remove band-aid approach. I already got shut down on that idea.

Can't shut down the dev server. Programmers still need to test there...

I'm moving a db on dev to a prod server. All our applications (3rd party tools, access dbs, ssrs/ssis pkgs, etc) all point to dev. I guess I'm looking for...

Trial and error....and success. How else do we evolve without trying new things? Cloud storage and computing is an excellent idea that is completely debatable. I say weight out your...

Got a response from IT and they said that the firewall won't allow a connection from any development box to any production box.

Thanks everyone for the help

Sorry, thought you meant log into actual windows server. I can connect to Prod Server via SSMS.

Pinged Prod Server from Dev Server and no lost in packets.

Tryed adding domain and...

SQL is listening on port 1433.

Can't log into the actual server.

What scripts are you referring too? I was using the GUI to create the linked server. Service Account is the...

I should have mentioned that as well. Yes value = 1