I think I can just use CURRENT_USER for what I need. Thanks!

Sorry about the wink face, replace  with a end parenthesis and a semi-colon. 

If you're asking how to split a single table into multiple data files, here is how I did it.  I first created a temp table that mirrors the old table. ...

Did you try running profiler to see what was attempting to logon?  You could also see if adding the BUILTIN\Admin back in fixes it. Just to elimate that as a...

OK, I got it working.  The BUILTIN\Administrator account was deleted (by me).  The account that the job was running under was using that group for access. What I don't understand...

I did another full backup last night but it still isn't working.  I think maybe our network admin was cleaning up some disk space and deleted some of the tlog...

Try DBCC CHECKIDENT using the RESEED option.

Darren

I guess I'm looking for a remote way to monitor when DBCC CHECKDB was last run.  This would be a part of a tool so I wouldn't know how the...

I've had similar issues with linked servers.  Are you using SQL accounts or windows accounts?  If you're using SQL accounts, make sure that B has Mixed Mode turned on (Windows...

Did you create it with 'dbo' as the owner?  Do an sp_help and see who the Owner is.  If it's not DBO then maybe its a security issue and your...

Any chance you have a backup you can use instead of the .mdf and .ldf files? 

So if we do use the /PAE and only have 4GB, is that ignored or should we remove it?

Darren

So if we do use the /PAE and only have 4GB, is that ignored or should we remove it?

Darren

So if we turn that off and reboot, it should access more than 2GB, correct?

Darren

Prior to DBA work, I was a Software Developer and supervisor. But more interestingly was my pre-college jobs.

Installed/removed Major Appliances

Installed cupboards

Grocery store Produce Stocker

Wendy's fry guy (1st job)

But the...