yes i can read G drive perfectly. it looks fine

2008-12-03 00:00:06.68 spid15s This instance of SQL Server has been using a process ID of 2160 since 11/24/2008 5:25:12 AM (local) 11/24/2008 10:25:12 AM (UTC). This...

the file is not names just.mdf, it has name.mdf file. i do have a back back. I am not sure all of a sudden y this error occured.

I can not...

I did restart my sql server, now that db is (In Recovery). what does that mean, what did it do?

The server principal "Statepausa\MLevan" is not able to access the database "PayEmp" under the current security context.

Actually MLevan is a member in a windows group, i gave acce to the...

I would like to compare all the columns in the DB from one server to another and populate the differences by using T-SQL just as we get from redgate comapre...

which is faster and best(performance) approach when compared with moving database files and attach or restoring backup file.

I was just trying to find out all the diffeerences between ddladmin and dbowner.

Here on both servers the User owns those jobs but still cant edit. any clue.

I am moving files to a different drive in the same instance at then attaching the DB. to replce the old database can i make the old one offline and...

That script is working for me if using the one altered by Ryan Austin

can give a try.

In his script what does he mean AD Login, windows login in my...

Guys..

I want ot try this but i get some syntax errors, does anyone used it?

http://www.sqlservercentral.com/scripts/Audit/61175/%5B/url%5D

I am not sure how this works nor am not supposed to install any 3rd party applications.

Let me know where i can do it through T-SQL. I was expecting there...

Isn't it better to us a different prefix than 'sp_' when creating your own stored procs ?? Then they won't get confused with system stored procs during upgrades or...

what do yo mean by alert through email, how is it possible. my developers whats to look at locks and who is doing what as that group will be kicking...