a login has only one default database, even when he has access to multiple db's thru different roles;

ig you go to SSMS>>Security>>Logins, you can find either his domain username or...

i just re-wrote it as well, but the math is quite not right; i'm basically using multiple CTE's to do the intermediate variables as columns, as soon as i have...

there is an article "zip code Radius search" that can help get you started:

http://www.sqlservercentral.com/scripts/Miscellaneous/30878/

it basically requires a table of postalcode/latitude/longitude, and finds all the records that match within the inputed...

I'll admit it, I'm weak on inline TVFs; had to look it up;

i've saved a lot of Paul's recent code that was converting other's scalars to inline tvf's but my...

you might be appending a null to the variable being used for the @body element;

ie SET @body = @firstname + ' ' + @lastname + ' a bunch of info'

if...

this is a common security issue.

Because "Local System" never logs into a domain, it can never access a share. The logging into the domain is when permissions on shares...

Seth yes i had actual plan on, but even with it off it's still ~36 seconds;

there's no space expansion or anything going on behind the scenes; i can run...

yeah i've used this code for a "schema checker" which compares a database to various xml docs;

based on an internal table, if your db is marked "version 4" or...

COLUMNS_UPDATED is very misleading; it returns true if the UPDATE statement happens to include the column in sql statement, not whether it's value changed;

I believe since you cannot manipulate text/image...

wow excellent catch David! I rarely work under multiple schemas, and certainly missed this!

I've updated my code and previous links to have the correction you mentioned, and you can downloaded...

i think i've seen this before, where version 539 is not a release-to-market version of SQL , but one of the preview versions.

I had that issue where i could not...

i've never scripted images out, mostly because they can't be represented in a string;

this link might help you, but everything i've ever seen shows that you have to treat images...

you'd have to show us the sql statement...it's a simple syntax error, but we'd need to see the statement to help.

a new, seperate instance would have a greater impact on a machine than simply making tempdb starting with more than enough room to handle expansion needed by your apps calculations....

something like this? you can use a case statement in the ORDER BY for custom results.

ORDER BY

CASE

WHEN YOURCOLUMN = 2 THEN 10

WHEN YOURCOLUMN =...