here's one way to do it:

since i want to find the second slash, i know i can use charindex to start at char 4 in your path.

/*

X:\folder\anotherfolder\X:\folderX:\folder\yet another folder\X:\folderX:\foldername\another folder\X:\foldernameX:\foldername\yet...

in that case, the assumptions really incorrect.

an entire SQL Service listens to a specific port; on a default instance, the default port is 1433, but, yes, it can be...

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