How do you run the Perl script?

Did you try to create a job in the Task Scheduler on the database server that executes this script in the security context of...

Hi kid,

why don't you get your own login?

We will gladly help you as an individual person. It is difficult to help when we don't know who exactly is behind a...

You can not move local Windows users and Local Windows groups. Local users and groups have SIDs that have part of the number come from the server. That is why...

If I would not know the answer I would think the name of the question is to trick us.

Hi H,

In these cases I create the Client Alias where I explicitly specify the protocol, port, the server name etc. To create the new alias use SQL Server Configuration Manager.

If...

Hi,

now I have 2 confirmed cases when passwords changed the case when moved from 2000 to 2005. All other passwords moved correctly.

What is interesting, if I assign the same password...

1 .Did you checked if this job was managed from another server?

check out the article in BOL "Creating a Multiserver Environment"

2. Could it be somehow related that one of the...

The solution that is used sometimes is to create a job step of the type ActiveX Script and paste this with replacing FolderName variable value with your folder and subfolder...

I think that UPDATE() is incorrect answer.

The question was:

"Within a trigger, how can you tell if a value has altered on a specific column? "

The explanations for the UPDATE() in...

check the error messages in the Event Log or SQL Server log for the startup.

I had cases when the virus scan or backup process grabbed the file upon SQL Server...

I just read this article. This is wrong. I support SQL Server starting from version 6.5 and I have at least 30 SQL Server 2000s that I connect. All of...

they are case sensitive in 2000 and 2005

I just tried moving 2 test logins,both with the mixed case passwords, one moved in the mixed case and one moved in the...

I thought it was me who was going nuts. Obviously, I was not.

I am moving the installation from 2000 and 2005. Last week the superuser and myself tested the application...

Hi,

We can not give you a legal advice, because every company's requirements and licensing are different, but we can give you some examples:

1 If in your company only 30...

Hi,

I could not find the QOD discussion for today, so I am replying on QOD of April 26 2006 when we had a very similar question. Both times the question...