Please don't cross post. It just wastes people's time. Many of the regulars here read all the forums.

No replies to this thread please, direct replies to-

http://www.sqlservercentral.com/Forums/Topic485382-357-1.aspx

At this point in time, I would suggest you not consider the MCDBA, unless you have a good reason. The SQL 2000 exams are due to be retired soon.

Consider the...

On that server at that time, no, because the server was clustered and the DAC was set as local only. That has since been changed.

I have tested, and you can...

Why do you have a job that shrinks the log file? If you're doing regular log backups, it shouldn't be necessary.

If the database is in simple recovery, the log...

I'm assuming you downloaded SQL Express. Profiler's not included in that, it's only in the non-free editions.

If you want to learn and play, download the evaluation version of SQL. That...

Ctrl-C, Ctrl-V. I'm starting to keep a text file of common...

.sqldb is not the extension of a SQL server database or script. SQLite is not in any way related to SQL Server

Perhaps the SQLDB viewer on this page will help...

There are utilities available to decrypt stored procs. You should be able to find one with google easily.

Other option, run profiler and trace the sp_statement starting event. Then run...

The error message means exactly what it says. BACKUP LOG WITH TRUNCATE_ONLY is deprecated and will not work in a future version of SQL Server (in SQL 2008 specifically). It...

Take the tuning adviser's advice with a large pinch of salt. It was a tendency to massively over-recommend.

What I would suggest is that you try the indexes that it's suggested...

Well, yes. All that's currently doing, is looping over the records. You'll need to add in logic to do whatever inside the while loop.

while (@@fetch_status = 0)

Begin

...

Jeff Moden (4/15/2008)

---

More correctly stated, I'm "Planning on Planning"... Although my plane ticket certainly wouldn't cost as much as your's, I have to plan the time (time off is $Lost),...

Dunno. Post the code please?

Make sure you've changed both of the Fetch Next ... to use the variables, otherwie you will only get the first row, 4 times.

Maybe. It depends on the queries run, the data distribution, the indexes you have. It's not a question that can be answered in general.

Pretty close. You'll need to fetch the email into a variable (ie FETCH NEXT ... INTO @SomeVariable), then the sending logic goes inside the while loop just before the FETCH.

Just...