Is it not posible from SQL Server side i.e., using any SQL tool or wizard?

I don't have access database tools installed on my box.

I know that shrinking data files hinder performance, but is the same applies to log files?

Because one of the log file is having 14GB of which only 70MB is being...

Check the available memory for SQL Server.

For SQL server to take more than 4GB of RAM AWE should be enabled using'

sp_configure 'show advanced options', 1RECONFIGUREGOsp_configure 'awe enabled', 1RECONFIGUREGO

Thanks for the reply.

Is it not possible to export output to spreadsheet using SQL query instead of VB script?

I know how to create dts package, but can anyone give the steps I need to do or procedure ?

SP_HELPROTECT NULL, 'user'  doesn't give the information like the whether the stored procedure has execute permissions or not.

I need the information like stored procedures not containing execute permissions for a particular...

Check the following link:

For SQL Server 2000

http://support.microsoft.com/kb/276043/en-us

For SQL Server 7.0

http://support.microsoft.com/kb/276041/en-us

What error did the Maintenance plan history show?

Thanks a lot to all of you.

I did learn how to use cursors and undocumented stored procedures seperately.

>>[wow - cursors and undocumented stored procedures in one batch

I saw the same error like login failed for same service account as in SQL Server error log.

I also observed in application log like resources changing from Cluster NOdeA to...

There is already db_datareader permissions for the database , but when I check the Permissions of that user in that database I don't see select permissions for any table.

Is db_datareader...

Can anybody help me with the above query?

I need to get the backup files from all drives in a server.

I went some where wrong and I am getting duplicates instead...

I am almost there at the solution..

Can anyone correct my following query.. I am getting so many duplicate files ?

********************************************************************

set nocount on

create table #DrivesOnServer

(

  Drive varchar(10) not null,

  FreeSpaceInMB dec(19,4)...

Karl, If some how I got the filename what I want but how can I get the full path of the filename to use the above xp_getfiledetails?

I am going somewhere...

Thanks Karl.

How to get the date of the file?