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.

SQL Profiler would be ideal to monitor any activities on SQL Server.

Is this what you are looking for?

SELECT DISTINCT parent_product, sub product, descrip

FROM TABLENAME

WHERE CONVERT(VARCHAR(10),DATE,111)=(SELECT MAX(DATE)FROM TABLENAME)

I might have misread your query. You can grant access to a user to a specific database and he will not be able to access other databases available in that...

If you are validating the CD column with the help of Eff Date and End Date, then in the INSERT trigger a query with "Where" clause can help you out.