Jeff Moden (7/3/2010)

---

Steve Jones - Editor (7/2/2010)

---

I agree with you Jeff. We could only pick from what was submitted, but some of the feedback that I've given is that we...

Why so many filegroups?

There's no procedure that let's you restore without specifying things like files. I suggest that you write a script that generates the restore statement for each database...

The latest is always called ERRORLOG

And not all traceflags cause things to be written to the error log. 1222 was one specific example that I gave. There are traceflags that...

Your CASE statements need to be terminated with an END

SELECT CASE

WHEN @enddate BETWEEN DATEADD(YEAR, -3, @Startdate) AND @Startdate THEN '0'--'valid'

ELSE '1'--'not valid'

END AS ValidDates

I'm not sure...

As I said, server-side traces (just like Profiler) lets you see when various things happen in SQL (stored procedure begins, stored procedure ends, login succeeds, login fails, etc)

Traceflags change the...

I've never done anything longer than a half-day training session. I'd be very nervous submitting for a full-day precon.

Server-side traces (sp_create_trace) and traceflags (DBCC traceon) are completely different concepts.

Server-side traces are essentially profiler traces without the GUI, they log when events occur on the instance being traced, such...

Then I think you need to go back to your TL...

This is a SQL Server forum (as in Microsoft SQL Server, the database engine), not a general IT forum. You'll get far better answers and help if you find a...

ISA Server? As in MS's firewall and internet security tool? This is a SQL Server forum, does your question have anything to do with SQL Server?

In my opinion, replication is to be used for scale out, creating reporting databases and the like

Mirroring is to be used for high availability.

Bear in mind that, in mirroring, the...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic947146-291-1.aspx

It's highly unlikely this needs a cursor and I don't see what a trigger...

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Ok, so you need to identify why the log is growing and resolve that, not just blindly shrink something that's trying to grow. Have you checked how much (if any)...