If you have a global variable set up (ours is called InputFile) for the input file name, then the code could be something like....

'**********************************************************************

'  Visual Basic ActiveX Script

'************************************************************************

Function Main()

Dim Dy

Dim...

Well unfortunately, with SQL2000 you only have the option of a trace as mentioned.

Not that it's relevent, but SQL2005 captures this kind of information!  Roll on our upgrade to SQL2k5!

If you get transaction log is full, you should manually run the scheduled job or just write some code on QA to back the log up and allow space for...

Quite likely its the good old refresh in enterprise manager.

I have found with several areas that when a change is made from query analyser, you need to refresh enterprise manager...

What exactly do you want your DEV team to be allowed to do?

Just run scheduled jobs?  Add, alter, delete them?

I have done something similar.  You can use DTS and append to the table.

The way I achieved this was to create a global variable.  Use some VBscript to grab and...

Hi Mayraj,

Not a problem!  If all he wants is an exact copy, we can use the code suggested by Farrell above.

You will, however, need a linked server so you can...

Hi John,

Yes, this is possible!  I have done it myself in a previous company.  There are quick ways.

1)  On logging in, you could query sysprocesses and see if the user...

Hi there,

If I understand your question, you want to mask the login and password that the developers use to connect to the application?

I would suggest looking at application roles.  It's...

Hey,

OK.  So your user now wants to update server 2 automatically when server 1 is updated?  I'm assuming he no longer wants to have an icon on his desktop?

If it...

Could you post the syntax you are using?

I can do it no problem (just tested to ensure im not going insane)!

You can use sp_addlogin to add a login to the master database.  However, if you specify the user database then you will get an error saying the user exists.

You should...

Personally, I would restore master and msdb as well as attaching your user databases.

Have you always had this error or has the query previously worked fine?

I've had issues where the MSDTC appears to be running but transactions are failing still.

In the end, the...

I work the usuall 40 hours a week.  9-5 Monday thru Friday.

However, as we run Oracle & SQL Server, we have 2 SQL Server DBA's and 2 Oracle, so I'm one...