You can use the free SQLPing 3.0 utility available on the link below to find SQL Server instances on one or more servers.

http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx

Not to mention that people will be able to wrongly post their SQL 2000 questions of both the 2005 and 2008 SQL forums.

They didn't really announce that they are releasing SQL Server 2008. They announced that they are adding it to the price list.

If you want to build a date table, the function on this link will give you what you need.

Date Table Function F_TABLE_DATE

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

You should avoid the other solutions posted on this thread, because they depend on the setting of DATEFIRST or LANGUAGE.

This code shows a simple way to do it.

select

DATE,

Mon = dateadd(dd,(datediff(dd,-53690,a.DATE)/7)*7,-53690)

from

--...

It's not that bad if you do it when they're real young and weigh maybe 100 pounds.

If you wait till they're a year old...

I have a hard time thinking of a terrible IT job compared to horrible non-IT jobs.

I got a temporary job once where we went to a site for some “digging”....

I don’t pay any attention to certifications on resumes.

What I look for on a resume is relevant experience, and the ability to clearly explain exactly what they have been doing....

You have to manually supply the name, instead of letting SQL Server pick one.

You can look up the format of the alter table statement in SQL Server Books Online.

You are converting the dates to string before comparing them, instead of comparing dates. Do it like this:

where EffDt >= '20080601' and EffDt < '20070101'

They do not produce the same results; see below:

create table #t ( Message varchar(20), seq int not null identity(1,1))

insert #t

select null union all

select '' union all

select 'xxx'

select * from #t...

You must really be getting old, because Joey Ramone died April 15, 2001. 🙁

http://en.wikipedia.org/wiki/Joey_Ramone

Open file defragmentation is only supported with Windows Server 2003 or higher. It is not possible with Windows Server 2000 or earlier.

You can use the built-in windows defragmentation utility...

jsheldon (7/2/2008)

---

Neither could I, I know it is within the ALTER TABLE command and that's what I put as my answer

I didn't give very detailed variable specifics when naming...

lherrerag20 (7/2/2008)

---

Why don't you create a SP to autopurge the log, i have a function, and belibeme it's so good not to worring abut the logs after made that.

I put...