Did you try to download from Microsoft and install SQLXML 3.0 and its service packs?

Kory,

I added to my prev. post, see above.

Windows admins will be able to start your data server anyway. Ask to add you to Administrators.

Kory,

Builtin/Administrators exist when SQL Server is already started. It is a part of SQL Server. To start a service in Windows you have to be in Administrators Windows group or in...

Hi,

Did you try to see if there are locks on the primary or linked  server?

Is it once or on a regular basis?

Also, what is a record format now? Do you need to add commas?

I would say it is a VBscript task, but again you...

Object that are owned by DBO should be visible to other users.

Sometimes invalid object name error comes up when users connect to the wrong database. It happens when the database...

I don't think this will increase the query time 60 times but who Table 2 belongs to? SQL Server first search for a table with the current user ownership, then DBO....

The problem could be that this file can not be accesses either because the permissions on the file changed or because this file is already opened by some other job...

I don't understand  the answer C: "The table is created as test1.MySecond, as it is substituted for dbo by the server" what should that mean?

Did you reproduce failed logins? Maybe no one failed yet? And Kory is right, you need to restart SQL Server for many of the server properties changes.

Hi,

It does make sense.

-L Lists the locally configured servers and the names of the servers broadcasting on the network.

The keyword here is Broadcasting. To hide the server: Open Server Network...

I had similar experience with jobs, when ActiveX script job would not run with a simple VBscript, but when the same code is put in vbs file and Operating System...

SQL 2005 has PIVOT and UNPIVOT statements

In SQL 2000 use Case or IF

I would separate internal and external processes.

FTP is dependent on another server being running and accessible, network configuration the same etc.  I would ( and I do) run FTP download...

Hi Lucky,

In regards to your #2:

It means that SQL Server itself is using a process ID on the server since it was probaly was restarted the last time. It does...