it kind of sounds like the client has your application already in place, and when they upgrade, they need to run scripts too?

I know in our case, we've done it...

i get this a lot when i use an explicit transaction, which i then role back; afterwards, in that situation i get the same error you reported when i then...

AndrewSQLDBA (4/1/2013)

---

Because that you can have more than one filegroup. And that tells SQL Server to create the object in a certain file group. Yes, it is required. That is,...

it's trivially ewasy, but the most important thing is to make sure noone has sysadmin rights; you cannot hide or deny access to a sysadmin.

sql is deny by default, so...

an example of what Gail was referring to:

USE [SandBox] --my db for users to do stuff.

CREATE ROLE [ReallyReadOnly]

--give my new role READ permission to ALL tables

EXEC sp_addrolemember N'db_datareader', N'ReallyReadOnly'

--explicitly DENY...

Sp_help returns multiple data sets with different numbers of columnz. It also returns different results depending on the parameters and the object you are testint... a table returns diilfferent results...

something like this? also, max_length only makes sense for char types, so you mean like varchar/nvarchars right?

SELECT

OBJECT_NAME(OBJECT_ID) AS tablename,

name AS colName,

TYPE_NAME(system_type_id),

CASE...

again, no, it is not possible...

the only sure fire way to keep the keep that global temp table around is by having the process which created the temp table keep it's connection open. that...

create a temp table, and instead of SELECTING, do INSERT INTO...SELECT:

CREATE TABLE [dbo].[#TMP] (

[DBNAME] NVARCHAR(256) ...

even global temp tables get dropped if all the sessions that referenced it disconnect, i believe.

you'd need to start adding logic to create if not exists to your process, if...

Laura i think it would be easier to delete dashes, and maybe also spaces from the string, and then look for 16 [0-9] digits in a row in the...

yes, you can make a check constraint that uses a user defined function.

something like this is untested, but kind of gives you an idea of how it would work

create function...

note: two year old thread.

the answer is right here, so re-read the whole thread, and use the GUI instead;

your error is mentioned in my post above:

--fails: not allowed to alter...

no rules for what it is you want to do?

my wild guess is you want to split Task by word, but no explanation ont he numbering scheme.

With MySampleData ([Proc],Seq,Type,Task)

AS

(

SELECT...