J i poked around, and did nto find a way to get the output of the columns/structure of a stored procedure (if it returns result set) so far;

if we can...

i took the question about "ports" and "monitor" to be:

how do i tell SQL Server which specific port to listen to...

so if i wanted to make SQL server listen to...

j take a look at this thread from a week or so ago; there is a script contribution that I enhanced and fixed slightly;

http://www.sqlservercentral.com/Forums/Topic981671-149-1.aspx#bm981831

it produces well formatted, informative html document.

I've...

good point Reobert...getting back on topic....

your procedure...does it have defaults on any of the parameters? I would bet that is why it eats cpu cycles...

parameter sniffing.

an execution plan gets ...

drew.allen (9/16/2010)

That's because you have your TOP clause in the middle...

you'll need to change the definition of the column from varchar to nvarchar.

the issue can be seen in this example...special charcters get converted to question marks if a varchar field...

pretty much the same:

DECLARE @sql NVARCHAR(100),

@Params NVARCHAR(100),

@data VARCHAR(100),

@TopCount varchar(3)

SET @sql = N'SELECT @data = TOP ' + @TopCount + ' CAST([Salary] AS VARCHAR(100)) FROM [dbo.JobDescriptions] WHERE [JobName] = ''CEO'''

SET @Params...

you'll have to create something in code or in CLR;

the ability to READ emails ( the read receipt IS an email)

was removed when sp_send_dbmail was introduced;

so there is no...

sure, you can do it two ways;

the BEGIN...END block can contain more than one command, and the ALTER TABLe command can take a comma delimited lit of columsn tadd:

IF EXISTS(SELECT...

CB the UPDATE function is really misleading; it doesn't tell you if something changed or not(which is what you intuitively assume based on the name)

it returns true or false if...

ok Craig, YOU get an internet cookie:

for varunkum:

No cookie for you!

we do not do homework.

if you have a specific question, let us know, but the literal copy and paste, without any input on what you tried, what you think,...

ok, any operation which changes the definition of the audit table should be rolled back anyway, should it not? changing THAT specific table is NOT a legitimate change, as it...

to use the alias of your calculation, you have to wrap it up as a sub query; otherwise you would have to use the full calculation inline

this is what you...

you error is really minor; a case can only have ONE "ELSE" statement:

CASE

WHEN Code Between 1 and 24

THEN Hours

WHEN Code Between 26...