Imke Cronje (11/29/2007)

---

Hi

I tried using this script below. But I'm getting the following error:

Incorrect syntax near the keyword 'BEGIN'.

create proc sp__Test

as

set rowcount 1000

while (select * from [Table] with (nolock)...

You can download it from Microsoft's Codeplex site http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

Do read the instructions (after the install you will need to attach the extracted database files, but this is detailed in the...

You can use the UPDATE() or COLUMNS_UPDATED in trigger bodies to find out if a particular column has been updated.

You can see a full example in Books Online http://msdn2.microsoft.com/en-us/library/ms187326.aspx

It would...

In this case "set rowcount" can work. Note that cascading operations are not adding to the affected...

Imke Cronje (11/29/2007)

---

Hi,

Does anyone have a script/stored proc that will delete data in small batches at a time so that the transaction logs in the database does not grow very...

ckmoied (11/28/2007)

---

When run through query analyzer the following query gives me the correct results:

Query:

select Task Task,coalesce(cast(Added as varchar(10)),'') Added,coalesce(cast(Updated as varchar(10)),'') Updated, [Time] [Time(ms)], Message Message from MyTable

Results:

Task ...

Maybe I do not understand you correctly (sorry...

GilaMonster (11/26/2007)

---

Sure. I was pointing out that the optimiser doesn't (and can't) always ignore the column specified. Your reply seemed to say that count(*) and count(column) are equivalent, which they...

GilaMonster (11/26/2007)

---

Not quite.

Count(*) or count(1) or similar will give you the number of rows in the table. Count(ColumnName) will give you the number of rows where that column is not...

Abhijit (11/26/2007)

---

hi !,

I have written 1 Query in 3 ways.

Select COUNT(1) FROM table1

Select COUNT(*) FROM table1

Select COUNT(Col1) FROM table1

My Question is I m getting the same execution plan for the...

zeeshan malik (11/26/2007)

---

ok Andras please give me some idea how to run a trace i don't know any thing about it? If you can give me some site URL for...

zeeshan malik (11/26/2007)

---

I want to know which stored procedures are executed in the last 24 hour in my database and i wish if i could also know about the program...

This problem has been discussed a few times, so you may want to look at the common solutions to these.

An example is http://www.sqlservercentral.com/Forums/Topic411513-338-2.aspx

The easiest to find these is if you...

The problems with the order may be because of messed up sysdepends or sys.sql_dependencies table. 2008 will help, but until then third party tools are the easy way. Red Gate's...

Check your indexed views and whether they were created with ansi nulls and quoted identifiers set to on.

You can get this information from sys.sql_modules (on 2005) or by using the...