ROWSMSDBData39739763880D:\MSSQL10.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf

LOGMSDBLog5840D:\MSSQL10.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf

When I see the Disk Usage Report for msdb database, the below is what I get,

Total Space Usage 31,051 MB

Data Files Space Usage 31046 MB

Transaction Log Space Usage 4.56 MB

I...

I get this info,

dbo. sysssispackages # of records = 20 Data 9544 KB

dbo.sysmail_attachments # of records = 18 Data 4064 KB

dbo.sysjobhistory # of records = 1000 Data = 2184

These are...

Hello,

I need a statement which I could run once and it would genertate the information for all the users existing in SQL with the type of permissions,

Much Appreciated,

Thanks,

Dev

OK Thanks

The imported ones please

Sorry I got it Thanks Again

Thanks a Lot for your advice, I wil follow that, but I do nort see a link with your signature

Can we do the automation for the disk backup of SQL 2008, please Advice

thanks, the problem is we do not have the compress option,

Dave

ok i am sorry

dev

No the Server is up and running, even I have a backup Domain Controller

Hello,

Could you please let me know How I can get the developer to have read permission to the package and read permission to the job I created,

Thanks,

Dev

Thanks Greg

Hello Chris,

The job associated is failing, the DTS package is under user name with read privelages, I wanted to change that,

Please Advice,

Thanks,

Dev