Much appreciated John, this is indeed a non-production database I'd pieced together on the quick-quick for urgent reporting purposes, I can alter the column names after checking a list of...

Sure, schema and sample posted above.

Schema, sample data....

1 [User] nvarchar 255 1

0 [User Name] nvarchar 255 1

0 [Telephone NO & Extension] nvarchar 255 1

0 Location nvarchar 255 1

0 [Floor Location] nvarchar 255 1

0 [Asset Tag] nvarchar 255 1

0 [PC Make] nvarchar 255 1

0 [Model No] nvarchar 255 1

0 [Serial No#] nvarchar 255 1

0 [Applications 1] nvarchar 255 1

0 [Application 2] nvarchar 255 1

0 [Application 3] nvarchar 255 1

0 [Application 4] nvarchar 255 1

0 [Application 5] nvarchar 255 1

0 F15 nvarchar 255 1

0 F16 nvarchar 255 1

0 F17 nvarchar 255 1

0 F18 nvarchar 255 1

0 [Application 6] nvarchar 255 1

0 [Application 7] nvarchar 255 1

0 [Application 8] nvarchar 255 1

0 [Source Code] nvarchar 255 1

0 [Installation Documentation] nvarchar 255 1

0 [Hardware Peripherals] nvarchar 255 1

0 [Installation Discs] nvarchar 255 1

0 Comments nvarchar 255 1

0 [Availability - Good (Y/N)] nvarchar 255 1

0 [Holidays booked] nvarchar 255 1

0 Symbols nvarchar 255 1

0 F30 nvarchar 255 1

0 F31 nvarchar 255 1

0 F32 nvarchar 255 1

0 F33 nvarchar 255 1

0 F34 nvarchar 255 1

0 F35 nvarchar 255 1

0 F36 nvarchar 255 1

0 F37 nvarchar 255 1

0 F38 nvarchar 255 1

0 F39 nvarchar 255 1

0 F40 nvarchar 255 1

0 F41 nvarchar 255 1

0 F42 nvarchar 255 1

Sarah...

Hi chaps, got some problems with the code...

Those scripts keep erroring out on syntax , I'm not even sure from how they're worded how they're supposed to accomplish what I...

Well - the good news is that it turned out to be an AD issue (although the boys seem to feel I'm a SQL whizz - who am I to...

Hi Ninj, happy new year!

What's this "dTSRUN" string and where do I find it?  Never heard of it, but sounds like a promising lead!

Cheers,

Jaybee.

Cheers guys!

Appreciated - got another one for you on the forum if you want!!

How's this?  (the values have been changed to protect my contract!)

insert into 'staffdetails'

(loginID, displayname,  department, position, phone, fax, email)

values (PlumbD01, 'Plum,Deborah (ELSD)', 'Energy and Legal Services', 'Lease-Lend Officer', '020...

Cheers mate, I've decided to:

1) determine whether I can dispense with the programmatic login/user creation and do it by hand in EM;

2) dispense with the whole temp table idea...just not...

master 0.4921875 46.825397 0

tempdb 999.99219 5.7368126 0

model 0.4921875 71.031746 0

msdb 2.2421875 50.631535 0

isalog 14198.805 0.2937431 0

Chock full!!

Not my/our fault...we took over a company who's adherance to best practice was questionable, at best.

But it IS our problem - or rather, MY problem.

So the end of the...

Webproxy log - 276Gb

dbo.blogreport - 39Gb

Tranny Log - 1gb.

I've scheduled a job to run tonight at 2am, failing that I'm escalating the matter, the challenge has been fun but I've...

The DBCC SHRINKDATABASE one!

Guys,

Got this error message 36 minutes into the run (I wasn't around to retry)

--The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are...