jeff.mason (8/3/2010)

---

The only foolproof way I know of (and you probably need a domain admin account for each domain to do this) is to do an LDAP query against AD...

I'd try SQLPing

I'm not sure that I see a difference either, but, this:

RIGHT(RTRIM(InvoiceNumber),12)

Is going to absolutely kill performance. You can only ever get scans because of that. Functions on columns is a...

Why are you trying to create an alias of the geography data type with the same name? Just use it as is.

Also, if you try running that script, as defined,...

How about using SMO. Something like this works:

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SQLServer.SMO") | Out-Null

$Server = New-Object ('Microsoft.SQLServer.Management.Smo.Server') 'Servername'

$db = $Server.Databases["Test"]

$script = Get-Content c:\scripts\input.sql

$extype = [Microsoft.SQLServer.Management.Common.ExecutionTypes]::ContinueOnError

$db.ExecuteNonQuery($script,$extype)

Lynn Pettis (8/2/2010)

---

Gianluca Sartori (8/2/2010)

---

Jeff Moden (8/2/2010)

---

Wow! If that's actually true, that's WAY too low for someone of...

Lynn Pettis (7/23/2010)

---

Okay everyone, the hardest thing I have had to do since I started here (work) a little over 5 years ago is done, now the countdown to a...

Roy Ernest (7/23/2010)

---

Grant Fritchey (7/23/2010)

---

Nah, the guy's taking a beating for something he didn't create. I know...

A couple of questions. How do you go about not using locks? Aren't they pretty much required by the system when it updates...

Take a look at a function called sp_help. I think that might move you in the direction you wish to go.

prakskarry (7/22/2010)

---

If the developer asks you to restore just one database then you can go ahead restore one datbase for him and later on you can restore the changes made...

WayneS (7/22/2010)

---

Grant Fritchey (7/22/2010)

---

It's not hard. Go to connect.microsoft.com and...

Nah, the guy's taking a beating for something he didn't create. I know the feeling all too...

MegaDBA (7/22/2010)

---

Thanks Grant, and I did take your comment with humor, I mean believe me, I know that code is a mess, lol

I think what Joe points out is just...

Things certainly got a little harsher than they should have and I guess I started it with my comment. Apologies. I meant it as a joke.