Alex,

scm.exe works with SQL server services, Sc.exe works with any Windows service but both start SQL Server in a normal service mode. That is why you can use both to...

BOL says: "When you pause an instance of Microsoft® SQL Server™, users who are connected to the server can finish tasks, but new connections are not allowed. " so it...

You would like to read an article of Andy Warren here on sqlservercentral.com:

http://www.sqlservercentral.com/columnists/awarren/worstpracticebadconnectionstringsandbadinfoinsyspr.asp

"Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses"

it shows actually a good practice too including...

I understand that Machinename$ is used in the Event Log (Security Log for example) to represent a user if the service is started on the LocalSystem account and the service...

Hi,

I tested it and it worked!

I created a File Data Source to SQL Server database on my workstation connecting to other server. I used a wizard in ODBC Data Sources...

Hi,

did you try a FILE DSN for SQL Server forODBC source? Trying it now.

Hello Mike,

this is a very good article, everything correctly describes issues I have to deal with almost every day when working with reports.

It would be a good idea if you...

Hello Tobias,

did you think about instantiating your MS ACCESS object when your Pivot is refreshed?I am not sure what I mean, but if you create an Excel macro for refresh...

sp_droplogin is to drop SQL Server Standard Logins

sp_revokelogin is to revoke access to SQL Server from Windows users and group.

Use the appropriate one for your login type.

SQLBill,

Garrick has several filgroups and files, I am not sure sp_attach_single_file_db will work in this case. He probably has to copy all files?

Please, take a look at the examples at

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-lz_115x.asp

LIKE article in Transact-SQL Reference

Better read all article, but if you don't have time then scroll to the middle of the article...

Another solution will be to bring a box of chocolates to another DBA, ask him/her to let you to use his/her server for an hour, restore on this third-party server,...

It is difficult to write scripts for the environment that you are not familiar with. But the very first advise will be to use traces.

Please read my reply at this...

It depends on the application. If the application has functionality to add users and it is using Standard authentication  then a person who adds users / logins have to have...

Does he/she/it owns objects? Were there any error messages? Did you revoke access in the same database on the same server as you are watching it?

And just noticed: you revoked...