Jason Shadonix (1/24/2008)

---

E-mailing a distribution list is definatly a solution if you can convince your mail administrators to set it up for you.

Can you have an operator with...

If it is possible that you will not always have 5 colors (maybe they can pick 0, 1, or more colors?), then the following code may be a better solution.

if...

zahranym (1/24/2008)

---

Any domain user with datareader and datawriter permissions can register the sql server using sql managment studio and see all database , is there a way to stop that...

I would hope that someone qualified to be "IT Director" would have a good idea what a DBA does and be aware of the reasons to hire or not hire...

Use the CREATE TABLE statement to put the table on the desired filegroup.

Try using these functions. They're already debugged. 😎

Start of Week Function:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47307

End of Week Function:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64760

Does this job have a work location?

Make sure your resume is well written with no misspellings, nonexistent words, obscure acronyms, or chat-speak.

I consider English communication skills a must have for a DBA or developer, and I...

I would be helpful if you explained what you are trying to do.

Depends on how you use NULL. It could mean does not exist, does not apply,...

Select

*

from

MyTable

where

@MyDate > StartDate and @MyDate < EndDate

Just to flog this topic a little more.

When you are using text stings for dates, you should use the format 'YYYYMMDD HH:MM:SS.MIL'

Example: '20080116 18:01:25.997' (or '20080116' for date only)

This is...

Rajan (1/16/2008)

---

I would say backup/restore if there is a huge amount of free space in the database. If the datafiles dont have much free space, go for detach/attach.You need to...

It would be helpful if you showed us the code you are using to insert into the tables, and the DDL statements for the tables.

This is the simplest way.

use master

alter database MyDatabase set offline with rollback immediate

drop database MyDatabase