Note the above is only needed if you want to truncate the log and reclaim space. If not use

DBCC SHRINKFILE (N'LogFileLogicalName', 0) instead, to just shrink the log...

I am not sure. If you can connect to the server via your local instance you should be able to run the DBCC commands. Have you tried to...

You can also do this via SSMS by right-clicking the database and going to tasks --> shrink --> files

You have to shrink the log file

DBCC SHRINKFILE (N'LogFileLogicalName', 0, TRUNCATEONLY)

GO

Oh, forgot to thank you for the feed back :D. It is nice to hear that everything worked out. Some posters just take the code and we never...

I took no offense to any of your comments, I was simply explaining. Sorry if I came off the...

Good tip Ray Mond. 😉 I did not know this information was available in MSDB.

Thanks.

Yeah you can easily restore from SQL 7.0 To SQL 7.0 but you have to wave your magic wand if you want to restore from SQL 2000 to SQL 7.0....

I agree with Gail on this one. I answered your post in the SQL 2005 forums. You can view my reponse from there. I have a pretty...

You cant restore or attach a SQL Server 2000 database to a SQL Server 7 database and you can only DTS from 7.0 to 2000. I think you are...

Access it the same way you would a website on the local server. Use the name in IIS to find out the exact path but you should open Internet...

Markus is right the log is the only way. You can query the log for what you need by using the following code:

SET NOCOUNT ON

GO

Declare @ErrorLog Table (LogID int...

Reporting services is available for any version of SQL Server 2005, but the advanced features come with Standard and above.

When you installed SQL Server 2005 Did you choose...

You could setup a report via reporting services using your query. From there you can have the report automatically emailed in the pdf format. I believe you can...

I Found this workaround on this site. With this you can return a postive number of zero from a function.

DECLARE @NBR INT

SET @NBR = -123456789

SELECT round(@NBR,-1-floor(log10(abs(@NBR))))

more info:

http://www.sqlservercentral.com/articles/Advanced+Querying/afixfunctionintsql/2487/