steve smith (2/24/2009)

---

Well, let's see... I take a backup. I zip the file before copying it across from one server box to another server box. Then I unzip...

What you are stating is not possible - if the database is restored. If there are views that don't exist in the other instances, they must exist in a...

Your co-worker is correct - column order has no bearing on how SQL Server places the columns in the b-tree.

Lowell (2/21/2009)

---

Jeff it does still work; it depends on the commands you use; I've got an article coming out on a procedure i wrote that returns the DDL of any...

Dirk Hondong (2/21/2009)

---

I am still confused, but on a much higher level right now....

It is not possible for me to just set a use @dbname inside the proc. The use...

Lowell (2/21/2009)

---

to get a procedure to run under the context of the database it is called from, doesn't it HAVE to be in the MASTER database and also at least...

Nah - that's too much work. You'd have to...

Yes - there are probably several scripts already available on this site that do what you want.

When you run this as a script - it will run in the context of the database you are using. When you create it as a stored procedure, it...

Seggerman (2/19/2009)

---

I had this problem at an earlier job and it was a dog - arf! Making the WHERE select into a temp file helped a bit. If...

I would recommend using Redgate's SQL Data Compare instead of writing your own. But, if you don't want to go that route:

1) Create a linked server from one system...

DECLARE @seconds int;

SET @seconds = 14400;

SELECT DATEADD(second, @seconds, '20090101')

,CONVERT(char(5), DATEADD(second, @seconds, '20090101'), 108);

Ahhh, yes - should have been clearer and stated that it shows up under logins. If you script the login, you will see the difference.

For windows users it will...

Yes - that is correct, if you count the private addresses needed for the cluster heartbeat connection. Forgot about those 🙂

If you look at the properties of each one of those users, you will see that the user with the instance\username is a windows user and those users without the...