Here are the highlights of my commuting career (not in chronological order):

Best commute - now in OK - 3.3 miles to work in 8 minutes, home in 12 minutes (due...

I just had to find out ...

create table tempdb..test ( col1 bigint identity(1,1))

go

set identity_insert tempdb..test on

go

insert into tempdb..test (col1) values (9223372036854775807)

...

Curte question ... a fairly obvious solution ...

However, why would one do such a thing ?

I would first upgrade to SP4 since SP3 support lapsed in July of 2007. Also, I would also check my OS patch levels as well. MS PSS will then be...

Excellent article James.

It should be required reading as entry criteria to join SSC !

Congratulations to you both for the justly earned and deserved recognition.

I dunno ... odbcconf /? does not appear to give an option in the pop-up dialog box. Maybe google can be your friend on this issue ...

You are executing SQL Server 2000 w/SP4. What OS is it on ? Are there any anolalies in the System Security Event logs ?

no user exists

execute plan to delete

database server

Most Excellent :w00t:

kill current user

and begin to shutdown key

user database

yet another way 'to skin' the SQL cat:

select replace(convert(char(11),getdate(),113),' ','-')

😉

master full user

values unique union

with distinct order

Granted there are lots of reasons to justify how one became a DBA. However you cut it, it is both scary to the under educated and under experienced but on...

I vote for Systems Engineer/Database Administrator ...

Your duties resemble those I had at a healthcare provider and that was my title. But be wary, it sounds cool but it is...