Do not, do not, do not run repair as the first thing tried when dealing with corruption. It should be...

sp_readerrorlog will show you the current error log for the server as a resultset.

The error log's not stored in a table so there's no direct query. It's a file (called...

What's the recovery requirements for that database? If the DB crashes at 1pm, is it acceptable to restore to the last full backup?

If not, then you need to run transaction...

Pleasure.

shishirbabel (9/21/2008)

---

Thanks for the quick response.

What my main point is that i am not sure that which indexing to use to make sure that database responds in a very fast...

Pleasure.

You can use SQL profiler to capture all the commands that are run against a server. That won't tell you what rows were affected, it will just give you the...

Yeah, if the DB is using features that were deprecated in SQL 2000 and removed in SQL 2005. They'll still work in compat mode 80

Old style joins come to mind...

That's...

YSLGuru (9/21/2008)

---

When a database with a compatability level of 8 is running on SQL Server 2005 is it truely a database thathas beeen upgraded to SQL Server 2005 or is...

Versions of SQL 2005 prior to SP2 don't run properly on Vista and you have RTM there.

Can you download the SP2 version of express and install that over the version...

Please connect to the edition that you're trying to create the diagrams on and run the following:

select @@version

Update all statistics after you move to 2005, run a DBCC updateusage and I would recommend a CheckDB as well.

If you're running 2005 on Vista, being the machine's admin does not guarantee that you are sysadmin in SQL server. You'll have to explicitly add yourself as admin to SQL.

If...

Nope.

That's true of most things in SQL. Once they're deleted, they're gone.