a person with db_owner on the database has the ability to backup / restore or drop the database they own.

if they drop it, they most likely would not have the...

if you have visual Studio 2012 , if you install the SSDT package from microsoft, you can create a new database project.

that has a wizard to point to a database,w...

i think you have to switch to dynamic sql for an all in one script right?

something like this?

Declare @serverID int,

@Memory int,

@Edition varchar (200),

@Version varchar (200),

@CoreCount int

select @serverID = server_id from...

DDL, sample data and expected results then?

based on some of your other posts, it looks like you are trying to script out a table definition.

take a look at my procedure i wrote in this article and...

since there's more than one row, and you only want to group on one column, you need an aggregate function;

any of these would be my first examples to see what...

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...