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

i believe the mutating issue is when you try to update from anything other than the old; or new:

you want to avoid that.

it's not clear what you are trying to...

Joe you'll most likely use a procedure like this, this is just a model, but you can see how the proc might use CROSS APPLY (or a left join? it's...

look at the ER diagram i think you posted. the Meters table doesn't have that column, so you cannot try to join it in your query like that;

the error here...

you are very, very sparse on the details.

is there more than one instance of SQL on the machine, and that is why you changed the port number?

why did you change...

if SQL browser is not running, are you explicitly adding the port to your connection? how are you connecting locally?