There really isn't much of a difference. A cursor basically builds a temp table to loop through and you would need to do the same with a while loop....

I don't know about flushing dns, but you should never need to flush the procedure cache on a SQL SERver. If you do that every query will need to...

todd_dawson (8/6/2008)

---

Where you dont have anything listed under 'Website' I have 'Default Web Site', maybe the directories for these websites should be under the 'Adminstration Web Site' directory in...

TheSQLGuru (8/6/2008)

---

Yep. And then we have this situation:

Clustered index: order_id (assume int - 4 bytes), order_date (assume datetime - 8 bytes),...

Todd,

Here are some screen shots of the Report Server Configuration manager on my PC where RS is running fine. Is this what you are seeing in your setup:

That was just an idea I threw out there without having the opportunity to test it. Are you putting the select directly in a job step?

If so you CAN...

Unless you are managing an extremely busy system and are noticing a negative impact I recommend using autoupdate statistics. SQL Server will update the stats when a certain percentage of...

Jeff Moden (8/5/2008)

---

Heck......

You could do an @@ROWCOUNT at the end of the first step.

If @@ROWCOUNT = 0

BEGIN

Return...

I didn't know that the column was ntext. You could convert that to nvarchar(4000) (sql 2000) or nvarchar(max) (Sql 2005) and the the trim functions will work.

You have to go out and get xp_smtp_sendmail and install it on the sql server, it is not part of sql server. The link I provided earlier includes the...

In 2005 you would not have to put a DML trigger on sysobjects just a DDL trigger in master.

C2 auditing is basically a server-side trace that starts when SQL Server...

I suppose you could save that little $ if needed. I just would install XP_SMTP_SENDMAIL and use it for new email needs.

How are you deleting the database? The DROP Database command? When it is offline you can just delete the .mdf file and that won't be logged anywhere.

As...

You can do this through SSMS, if you are running 2005. You can also do this on the web by going to http://reportserrvername/reports. By default, just like in...