with what you've shown so far, you can certainly do them all at once; so you've left some important details out of the question at hand.

it's probably more a question...

from my notes, which i swear i use daily when fiddling with dates:

--another midnight

CAST(DATEDIFF(dd,0,somedatetime) AS DATETIME).

this is one of the coolest things to use once you get your head...

ok, i see starting from right to left, when it gets to the right merge join, it's dealing with 14 trillion rows of data... a couple of those operations...

i've had that happen to me before;

you can change the database compatibility level (to 80?), and that will suppress the error.

alternatively, the error says what the issue is.

if you have...

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?!