Either way, it's still a very good product. I've used Sybase and now forced to learn Oracle, when you see/use them you will appropriate the SQL server even more. Just...

I like your question " Have I even got close to exploiting the full potential of SQL Server 2000?" This could also be asked of SQL 2005. With SQL Server...

I agree. But in the mean time. I would recommend going to http://www.quest.com and download Spotlight for SQL Server (Red Gate has a tool but I can't remember the name)....

Can you give more information on your problem like what versions of SQL server are being used, are the servers located on the same network and same location, what service...

Glad to help when I can. Books On Line (BOL) is a good place to start looking for information on Link connections and it also gives example.

Not good with XML,...

Hello New DBA!

I would first recommend getting a book from Microsoft Press called SQL 2005 Administrator's Pocket Guide. I'm assuming that you are working with SQL 2005. If not get...

Hello,

Just looking around and saw your question. I would use linked connection and then execute your stored procedure.

sp_addlinkedserver and sp_addlinkedsrvlogin are the 2 stored procedure you use or you...

Hello,

Looks like this script will only shrink the database log file and not the database (.mdf file). Can I replace the database_log with the database file to shrink that too?

Thanks,

Rudy

PS....

Hello. Please let me know what you think about this code, changes, etc.

Thanks,

Rudy

Thanks for the information. Playing with the RSScripter now. Thx!

Hello,

I pasted your code (from this site). Looks like maybe your complete code was not uploaded to this site properly. Could you try to download your code from here and...

Hello,

Great idea for the stored procedure. For some reason the code does not execute. Below are the errors I'm getting. Is there an updated version??

Msg 102, Level 15, State...

Thanks for the info. But I seem to have problems with the results. To test this stored proc, I have created a user and given it specific rights to several...

Nice script. Is there plans to cover it to SQL 2005?

No problem. Just removed the question marks and it's good.

Thx