you'll need to get a copy of sp_help_revlogin from microsoft; there are different versions, depending on 2000/2005, maybe even for 2008 and above, i don't quite remember.

assuming you are going...

new users are at least a three step process:

create the user in Active directory (you said that was done)

create a login for the user in SQL Server(you said that was...

--deleted duplicate post.

the index scan is normal, from what i read, since the constraint for the foreign key needs to be validated; to do that, it has to check the existing values...

YSLGuru (11/13/2012)

---

Lowel

Thank you for the reply but I'm not following how this can be used to get the answers I'm looking for. Could you perhaps provide an example using...

it's just something i saved in my notes...i think it has more to do...

edit; for reference for others , he mentioned he already knows this one, as opposed to when the OS restarted:

select

sqlserver_start_time

from sys.dm_os_sys_info

side by side migration, or an in place upgrade?

there's not a lot of difference in the preperation, as compared to a full on disaster recovery plan....if the new server doesn't...

ok, i *think * this works fine.

i'm testing it for shorter 4-number-in-a-row patters for simplicity.

it doesn't quote work when the patter exists multiple times...it does fix one offending string each...

YSL I have a pair of TableValued functions for this, that i use to join against existing data so i can group by the rounding up or rounding down to...

doh! thanks, how did i miss that?!

create a temp table,and change the query to insert something into the table instead of a simple select...maybe the table name and the column name or something...or a PK...

you can...

the next part, the find and replace gets ugly very quickly.

is it possible that more than one number appears int eh memo field? ie two or three 1/17 digit numbers?

is...

if you know it's a single table, it's going to look something like this:

you can use the pattern matching , regular expression style of the LIKE statement:

SELECT *

FROM YOURTABLE

WHERE...

instead of dropping and recreating, it would be a lot easier to simply rename the existing constraints instead. sp_rename takes any object name that exists in sys.objects , not just...