Hi,

You have to place a BEGIN...END statement around the WHILE loop otherwise only the first statement after the WHILE statement will be processed, and you were effectively stuck in an...

What do you mean via TCP/IP connection?

If you're connected to a SQL Server (doesn't matter how) and you've got sufficient permissions and you're able to issue commands then you can...

Assuming you're using the ALTER INDEX command, which you should be you'll see ALTER INDEX in the cmd column. I assume that was the column you were interested in....

What do you mean by "request"?

You can use performance...

ifx (4/10/2008)

---

On of the central tables in our system has a unique constraint defined on a column that should have been the primary key. Although I can add the primary...

I can't help but see the funny side of this:D

There we all were scratching our...

bill.humphrey (4/7/2008)

---

Hi

in a stored procedure i want to check for a null date and assign a default value if it is null:

alter procedure sp_list_orcon_cat_b_v2

@start_date nvarchar(19),

@end_date nvarchar(19),

@priority nvarchar(1),

@response integer

if isnull(end_date) then...

How much of the database size is actually taken up with data? The database size could be 100 GB but maybe only 50 GB of that is used, in...

That's strange. Can't explain it. What version of SQL are you on? I've tested this on SQL Server 2000 and 2005, with various...

I might be missing something here but I'm not sure you need those sub-queries there as you're alread joining on the table fo. See if this works:

select CREND...

karthikeyan (4/7/2008)

---

The following rows are displaying.

select * from Dating

Output:

-------------------------------------------

Date ...

There's no difference whatsoever between a database that sits on a 32 bit system and a 64 bit system. The only thing that's different is the hardware they sit...

Unfortunately not.

karthikeyan (4/4/2008)

---

Code:

-------------------------------------------------------------------------------

Declare @strSQL VarChar(255)

declare @count int

select @count = 0

Select @count = @count + 1, @strSQL = (Case When @strSQL Is Null Then Date

...

Errr, did you have a question?