Of excuse me I meant

DECLARE @makecomment VARCHAR(100)

SET @makecomment = 'SAYSOMETHING'

IF @makecomment IS NOT NULL

PRINT 'I would said SQL is your first language.'

ELSE

--Don't bother.

I thought it was

DATEADD(d,DATEDIFF(d,0,dtCol),0)

quote:

---

I'm afraid this question was my doing and English is hardly my 2nd language (although my ex-English teacher may say otherwise). I...

You could try but you really have to know your data to have a clue.

Do

SELECT db_name(dbidvalue)

to get the database name. Then do

DBCC TRACEON(3604)

GO

DBCC PAGE('dbnamehere',filegroup,pagenumber,3)

The output is the page data itself...

So Answer E fire the dumb@$$ who put 16GB on a machine with OS support for only 8GB.

I understand that. Just want to see if the behavior is the same or not. I am not able to dup so just want to see if the code is...

Do they all need to go and all need to fail together and have you tried them in seperate calls to see if the problem is retained then?

Ok here we go.

quote:

---

2:1:64247

---

2 is the database id (compare it with dbid)

1 is the filegroup...

The quickest dirtiest way I can think of is wrap your sporc with a check. Then create a control table with a bit value. If the value is 1 then...

What version and patch level are you running of SQL?

Or if your field ahs a maximum length use that value. For instance a varchar(100) filed use 100 as the 3rd parameter. It cannot get more data than is actually...

If you are saying you want to pass the string dynamically and return the value to @var then look at sp_executesql in BOL.

But be carefull here as that increases you...

The problem with this one and the others that are wrong is that they actually return the database username. For instance if an account is a dbo in the database...

From the dbforums site I saw a post that this was a common request and is under consideration. However, can you post a code example so people know what it...

I am hearing a lot of rave about the AppDev products http://www.appdev.com/rs_entry.asp. We are trying to get our hands on them now ourselves for SQL Server 2000 and .NET.

I...