Column names are a fixed item in sql, so

to do that you would have to generate dynamic sql:crazy:

or use a form of pivot function.

Declare @sqlstmt as varchar(500)

Set @sqlstmt = 'select...

has the clr proc been granted external access ?

Personally, I wouldn't put that kind of stuff in a trigger.

A trigger is in process context, so if the trigger fails, the...

SSMS / database / backup GUI presents the last known filename that has been used to create a backup.

As you've stated, what's in an extention. It can be anything.

If you...

Sqlserver raises events when a queue get disabled.

Check out "CREATE EVENT NOTIFICATION" in books online !

- tempdb is re-created every time sqlserver gets started !

- there is no need to grant on tempdb !

everyone is allowed to create #-tables !

Check out create database or Alter database in books online !

e.g from BOL

ALTER DATABASE AdventureWorks

MODIFY FILE

(NAME = test1dat3,

SIZE = 20MB);

Here's another forum thread stating some sequences and actions:

http://www.sqlservercentral.com/Forums/Topic655130-146-1.aspx

Keep in mind you also need to backup master and msdb !

just put the script in a file e.g. fullsystembackup.sql

Then create a SQLExpress_fullsystembackup.cmd file containing :

cd /d yourdrive:\thescriptpath

sqlcmd -S...

As stated above, you can use management studio to perform the action.

However, more interesting is to let SSMS generate the SQL to complete the action.

Doing so, you'll see SQLserver encapsulates...

Check out the execution plan of both queries and execute them both a couple of times (so data will be in memory).

(SSMS Querypanel Ctrl+M or Menu Query topy "Include actual...

😉

What always tends to bring the confusing with charindex/patindex is that is has its arguments in another order then the replace function.

Whenever I need to use anyone of those, F1...

declare @charpos int

declare @searchterm nvarchar(max)

SET @searchterm = 'blood and sweat'

set @charpos = charindex('and', @SearchTerm)

IF (@charpos = 0) --Check to make sure string position was found

BEGIN

...

I've seen users being granted sqlagentoperator role, also appear in SQLAgentUserRole and SQLAgentReaderRole.

Did you try (re-) adding that user to these roles ?

I think it is CU2 http://support.microsoft.com/kb/961930

Yes, you can go directly to sp3.

Download it from MS.

This forum thread has more info:

http://www.sqlservercentral.com/Forums/Topic455158-146-1.aspx

Be sure to move the quorum of the cluster to the node that hosts the instance...