If you want a datetime then:

select DATEADD(Day, 0, DATEDIFF(Day, 0, getdate()))

if you want a varchar...

Interesting, the above statement should work, and it does work when I try it on a 2000, 2005, 2005 compatibility modes 65,70,80.

What version and edition of SQL Server do you...

One solution is to add the stored procedures to the master database, and add sp_ prefix to their names

(bad practise)

Another solution is to use a tool to sync the...

latingntlman (8/5/2008)

---

I need to remove all rows from a table based on the date value being at lease sixty days old from the update date (i.e. today). The syntax...

Change the last line to:

AND i.ADDRESS_SEQ < i2.ADDRESS_SEQ

Explanation: If you have two addresses A and B, then as teh two are not the same you will get back both A,B...

shyam (8/4/2008)

---

Hi,

I would like to know the major differences that a DBA should know bt the versions 2000 & 2005, 2005 & 2008. I tried looking up for this in...

This has been posted to http://www.sqlservercentral.com/Forums/Topic546548-146-1.aspx

- Andras

also run sp_who2 to see who/what application is using your db.

- Andras

Because you are using SQL Server 2005, do not use sysobjects. Use the SQL Server 2005 system views, like Markus did in his response. For sysobjects the new system view...

khushbu.kumar (8/5/2008)

---

Hi

I'm getting below error when my application tries to run a func.

The application is coded in .NET.

the web.config file has no connection timeout string

Is it related to sql...

maruf24 (8/5/2008)

---

declare @errorcode varchar(500)

select @errorcode = reason_code from blr1 where p_id = 236

select p_id,ID,User_ID,cd,cid,k_id,NAM,S_DT,DT,

time,amt,stat,msg,ino,info from...

this information is present...

Could you describe what you would like to do in more details? SQL is...

You can get the permissions from the sysprotects system table. You can...

mathewspsimon (8/4/2008)

---

HI Andras

I get the following error

Msg 325, Level 15, State 1, Line 30

Incorrect syntax near 'PIVOT'. You may need to set the compatibility level of the current database...