interesting;and i think i see the issue...my script might not be case sensitive.

is this database case sensitive?

can you run this command?

SELECT

DATABASEPROPERTYEX(db_name(),'Collation') ...

ok, what does "does not work on SQL2008 R2" mean to you?

what, specific error or behavior do you get? did you try a differetn table as a proof of concept?...

i downloaded both code sets as a dbl check so i am not using an unpublished improved version., and it's working perfectly.

changes to settings in Options only affect newly opened...

anujkgarg (10/22/2015)

---

I downloaded the script from http://www.stormrage.com/SQLStuff/sp_GetDDL_Latest.txt, it does not work on SQL2008 R2. It does not print all the columns of the below table.

CREATE TABLE dbo.Test1 (...

i have that problem in my shop, related to occasional deadlocks.

as...

i have all my servers available in Registered servers/Central Management Servers, so i'll paste this and copy paste to excel to get a list off all my servers in a...

i always think of the quoted reply as an easy copy/ paste shortcut.

In the past, when i've wanted to add the quoted to a previous item i already posted,...

actually, MS provides a stored procedure that will give you all objects(procs, views, tables, etc) in dependency order:

this works great as long as you don't have any circular references.

try this...

what's the datatype for MessageText? if it's TEXT and not varchar(max) or a varchar(8000) or less, i'd think you might get an error under the covers for "The data types...

a foreign key constraint between the tables could block other spids from updating or inserting data due to locks,

hmm; and the database? [AdventureWorks2012] definitely exists on your local machine, right? if you obfuscated it,...

sa02000 (10/15/2015)

---

I would like to connect to real estate transaction data service (RETS), download data and do some calculations, set up alerts etc.

Is there a free version of SQL server...

i would think it has something to do with the object Microsoft.SqlServer.Management.SMO.Server that got created; is this a new local machine? maybe you didn't install SMO when you installed ...

well obviously, the backup has to be available between both machines.

you can simply start a backup job and script it.

you get results something like this:

BACKUP DATABASE [ProductionDb]

TO...

i have this saved in my snippets; does ~7 miles sound correct for what you posted?

DECLARE

@Latitude NUMERIC(9, 6),

@Longitude NUMERIC(9, 6),

@MyLatitude NUMERIC(9, 6),

@MyLongitude NUMERIC(9, 6)

Set @Latitude =...