See if this works. You need to execute the query and set the variable before passing it to the stored procedure. Since the query only returns a single value,...

I think this is the issue you are having...

Select 3/2

Select 3/2.0

Int/Int = Int. You just need to convert one of the columns to a decimal.

Here is a thread where HP Openview was executing the process. Are you using any monitoring software like this?

http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server/15481/DBCC-TRACEON-3604

You should put the statement before the backup command. Then the backup command will have full control of the database. In your case you may want to use RESTRICTED_USER...

You can run

ALTER DATABASE [DatabaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

before the backup and then run

ALTER DATABASE [DatabaseName] SET MULTI_USER

after the backup completes

Microsoft has a pretty cool (free) tool called MAP that will find all of the instances on the network.

http://technet.microsoft.com/en-us/solutionaccelerators/dd537566.aspx

XML does pretty good with this kind of thing...

Declare @Table Table (id int, Nme varchar(10), Course varchar(10))

Insert Into @Table

Select 123, 'BOB', 'ABC' UNION ALL

Select 123, 'BOB', 'BBB' UNION ALL

Select...

The Job was created in a different place.

Expand SQL Server Agent. Look in the Jobs folder. Right Click the Job and select Delete.

I think you need another set of parenthesis around the bottom of the WHERE caluse because the last two condtitions are seperate from the AND.

(

DDCDMC in(

'1004', '1092', '1078', '1090', '1152',...

I was thinking the same thing as Florian.

Something like...

MainTable

MainTableID

OtherFieilds

MainTableDscr

MainTableID

DscrID

DscrTable

DscrID

DscrSequence

Dscr

Take this code for example. It uses the Varchar datatype, and if you concatenate another character to the end, you can see that it actually did perserve the trailing...

I am not sure CHAR will do what you are looking for either. Take the following example.

Declare @test-2 char(50)

Set @test-2 = 'a '

Select LEN(@test +...

I've been wondering about this. I tried to delete a post the other day where I posted the same answer a few milliseconds later and I did't want it...

It looks like if a single row is changed, sp_updatestats will update the statistics. I even had an Insert statement fail that caused the statistics to be updated. This...

Here is what I found in BOL...

"sp_updatestats updates only those statistics that require updating based on the rowmodctr information in the sys.sysindexes compatibility view; therefore, preventing unnecessary updates of unchanged...