Looks like authentication issue. Please verify that you have access to the FTP path. Try it from the browser.

I think it is not possible as the DB Owner has full access on the database.

The best way would be to put the database in Single User Mode using sp_dboptions (which would not allow further connections) and kill the existing ones.

Please go to Start --> Run

Type cmd

Click Go

Then go to the directory in which the batch file exists (e.g. CD C:\WINDOWS)

Then type batch file namd and press enter.

Please go to command prompt (cmd) and run the batch file You should be getting some error there.

According to me sp_who2, DBCC INPUTBUFFER, querying the SYSPROCESSES table, Running a trace using SQL Profiler are only options to get the last executed query details.

Regards,

Pradeep

No special steps involved in this. Same as attaching a DB with a Single file group.

Regards,

Pradeep

Even I believe that you find this information is available only in the Registry.

Regards,

Pradeep

Please give some more details about the problem that you are facing.

I think this link will give you the details.

http://support.microsoft.com/kb/263556

sp_who2 will give you the details of the currently running processes. If you know the SPID of the process then you can run DBCC INPUTBUFFER(SPID) to know that command that...

Please try re-installing the .Net framework again. This should help.

I am trying to build the .vbs file (which you provided in this article) in SQL itself. I mean I would like to build SAY, C:\Pradeep.vbs file by running a...

Hi Mark,

Thanks a ton for this wonderful article. This is exactly what I was looking for since a very long time !

I am trying to build the .vbs file (which...

But make sure you take the Full backup before trying the above and have one more after the above step.