But if you remove all the commas you end up with a single long string.

That user has not been removed from the PUBLIC role?

You would first create the filegroup and then add a new datafile to the filegroup. You can do this through EM or through QA thus...

USE master

GO

ALTER DATABASE DB1

ADD FILEGROUP DB1FG1

GO

ALTER...

If you are looking for a more cost effective solution I would check SQLSafe from Idera software. Litespeed is obviously the defacto standard but can be cost prohibitive in larger...

You can get a list of the jobs on the system by querying the msdb..sysjobs table, however you would have to join against the sysjobsteps table to get the steps...

master, model, msdb, tempdb are the system database. These are the databases that are critical to SQL Server and that will prevent it from running should they be missing.

Master handles...

Have you run a dbcc checktable to check for possible errors?

I don't have anything, and without using an identifier on the data, I'm not sure that you can do anything to resolve it (short of getting them to stop using...

If you use GO within the statement then it's going to clean out the variable.

You could just execute the statements without the go and keep the variable.

I would check that PUBLIC has select access on spt_values in the master database.

I would create the relevant tables on SQL, create a dts package which loads the requisite data into each table from the oracle server. Should it be your wish, you...

Can you not get them to use a quoted identifier for the data?

Otherwise you are going to have to create some external script to rework the data using vb or...

I so feel anyones pain in having to interview. I don't know what it is, but I have seen so many candidates, with docs out the wazoo, and supposed experience....

Add the following proc to the master db, execute it using the information in the proc and then remove it. See if it resolves the problem.

CREATE PROCEDURE SP_AUTOFIX_USERS

AS

/* USAGE FOR...

unless you specify differently XACT_ABORT will be however the default is set (if you are connecting through QA look under tools/options/conncection properties), you can check this value by using sp_configure...