Or let us know what ytou are trying to achieve. Are you looking to admin? develop software? What areas are you thinking you need to learn.

If it's true/false, then don't allow NULLs. confuses things.

I'd still recommend going with tinyint, gives you more options down the road. I've often seen someone define something a boolean, only...

I was thinking that the only way to do this was to query for known user and then strip out the domain name.

There are some AD stored procedures, but they...

Thanks for the update and glad it appears to be working.

And kudos again for using SQL Server at UCF!

You don't need the ELSE clause. If the parameter is not null, it's value will be already assigned.

Do you care which 4000?

You could insert 4000 PKs from the patient table into some new table, then set up a replication that filters based on those PKs. Or copy...

You might run PRofiler and filter based on the db, table, or some other object that you think is involved. Or just run it and then stop it when you...

Try this: http://www.sqlservercentral.com/articles/Integration+Services/61619/

I think this is a distributed transaction problem. Is there any reason you have it wrapped in a transaction there? Any error should throw a rollback anyway.

Does it complete? Could...

Almost went to Earl for an old car, but couldn't bring myself to do it.

We're POTS here (With DSL riding along). Still find uses for the line, especially as so...

clustered keys and primary keys have nothing to do with each other. the PK can be clustered or non-clustered and if someone thinks it's always clustered, either he doesn't understand...

I think you mean W2K3 Enterprise and SQL2K5 standard

http://msdn2.microsoft.com/en-us/library/ms171001.aspx

You'd need self joins to join each table based on the date.

so

select a.model

, b.modeldate '3 weeks'

, c.modeldate ' 2 weeks'

...

from modelhistory a

...

backup the database, restore it, then for each table you need to decide what "first" is. There's no order by default in SQL Server.

ms_foreachtable is a stored procedure that...

Please give us a clue here.

Worst case, set up a Windows Scheduled Task if you can't get SQLAgent to work.

Run isql -E -Q"backup database xxx to disk='c:\mybackup.bak' with init"

Feel...