Warning!

I was searching on the sqlagent error messages and a link brought me to this entry.

While reviewing the entry I performed a regedit and discovered that the location in the...

All my databases are SQL_Latin1_General_CP1_CI_AS which as far as I know was the SQL Server 2000 default.

I am pretty sure that when I installed SQL Server 2005 that I took...

I get errors when I try to run the code using Standard Edition with SP2 applied.

SELECT * FROM (Select 1 as DBID,

...

I think the problem is the first quote should really say "data pages". I do not think the internal format of the log uses "pages" but rather places...

But Booksonline also contains this quote "Log files do not contain pages; they contain a series of log records."

Blame MS not the author or question as I found the same...

Apparenty you missed the following >>

... and the SQL service was taken off line and then the LDF file was deleted all data should have been committed to the MDF....

I also think the statup with the -d option is correct since you can change the name of the master database in use this way. I have had to...

I really hate marking the wrong anwser selection letter after determing the right output. My hand eye coordination wasn't that good back in the days of PE either.

-- Mark...

Even though I did not let the wording fool me on this one I agree that it is a very poor question. As identified once the fun# table is...

You would have to run sp_resolve_logins for each and every database which would mean you would have to dump the sys.logins table for each and every database. That is...

Same issue on both SQL Server 2000 and 2005: syntax errors. The copy is jumbling the code and I was careful in separating it but no luck.

update -- I...

One problem I see with the question is that it does not specify the requried version or database to be used. The fact that the results are nonsense and...

According to my books online

System and Sample Databases

mdf Mastlog.ldf model Model.mdf Modellog.ldf msdb Msdbdata.mdf Msdblog.ldf tempdb Tempdb.mdf Templog.ldf The system databases are master, model, msdb, and tempdb. Note: The default...

I already had object bumped up so I tried column to 75 and still no luck, but when I bumped everything to 75 it worked. Looking at the results...

Grasshopper, your version worked fine on my SQL Server 2000 system when I tested it but still failed on my SQL Server 2005 version with truncation errors.

Any ideas of what...