thanks. yes, i knew it created a snapshot, and needs extra space to do that. My concern is why it didn't stop, after the first alert went out. The dbcc...

is this what you are looking for:

msdb.dbo.agent_datetime($(ESCAPE_SQUOTE(STRTDT)), $(ESCAPE_SQUOTE(STRTTM)))

You are in a loop because you don't have a fetch next in your loop. Also, move the DECLARE @return_value int outside the loop. And you don't need the select,...

it also appears like you are missing a primary key, thus allowing multiple rows with the same empid to be inserted.

As suggested, ddl, data, and expected results would be helpful.

Leonard

You really only need to reorganize or rebuild, depending on how much fragmentation you have on your indexes, although you can do it as often as you like, if you...

Setting aside why you may or may not need a cursor, what you need to do is:

Either:

select @sum =

CASE

WHEN (@cslPricingFactorRef = @90000119) THEN @Avamel

else

0 end...

I finally got it to do what I wanted.

When I populate the string, I had to do this:

SET @Command = N'--My Comment

SELECT GETDATE()'

Not this:

SET @Command = N'--My Comment ' +...

Just as an aside, if you are looking to defragment your indexes, try this: http://ola.hallengren.com/

Leonard

This looks like you don't have a default profile in your Database Mail.

Right click Database Mail, in SSMS.

Click Next.

Select the Manage profile security option.

Click Next.

On the Public Profiles tab, select...

not sure if this will help, but check this out.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

has a great function for splitting comma delimited rows.

Big thanks to Jeff Moden.

Leonard

I actually prefer my model database to be in Simple mode. If I need full recovery, I change it, when I create a new database, then I change my...

thanks for that. I considered it, but thought there might be a way to do it through policy. I haven't used them before, so thought this might be...

That myth should have died in sql 7. Sql 11 is coming out and it's not anywhere as near as dead as I'd like to see it!

yep, like I said,...

I was always taught to use the create table, insert method. not because it is faster, but because it blocks the sysobjects while the table is being created and...

There are a couple of things you can do. As stated, Link Servers can be really bad performers. We have them, I am slowly removing them.

Replication...