NO_LOG and TRUNCATE_ONLY are the same, and you do not want to use either of these (unless you do not care about recovery).

These options will truncate your log, and...

richard wilkinson (3/3/2008)

---

Is it possible to find out the block size for a database in sql 2000, either via the GUI of a select statement. Would be grateful if you...

I'm curious about some of the conditions, like

RecordedCalls.CallDate BETWEEN cast('01 Jan 1910 00:00:00:000' as datetime)

...

One of my installations was...

Steve Jones - Editor (2/29/2008)

---

Confirmed and I have a final note from MS:

===

We have recently discovered an issue with SQL Server 2008 CTPs that result

in SQL Server 2008 not...

Michal Mokros (2/27/2008)

---

Hi,

Is it possible to do some action (or to be informed somehow) when new reference to specific table is added? For example I have database with 500 tables...

Grant is right. One thing that helps is if you visualize your indexes a bit.

The leaf pages of clustered indexes will contain the full row data, the leaf pages of...

deepa (2/28/2008)

---

Hi andras

On SQL Server 2000 and 2005 you can play with the file permissions only.

If you can change the user, then you could control the permissions via the "BACKUP...

deepa (2/28/2008)

---

how can i restrict dbo user from runing backup commands( and creating backups in c:\ or any other partition)

where database server is different from web server and

per database/security...

Unfortunately John is right, rebuilding your table is the only alternative. However, I...

Sugesh Kumar (2/27/2008)

---

Browser services needs to run when the SQL servers run on the default port and when you have specified a port number for the server you can use...

count returns a single result per group. If you do not use group by then there is only one rowgroup. So in your query there is one count and one...

Sandy (2/27/2008)

---

hey Andras,

I have a quick question for you,

If you are using more than one Stored procedure, then how can you handle the transaction process,

Ex: -

SP -1

(

Begin Tran...

You could use a table variable and then get the result out of it like

CREATE PROC uspGetEmpDetail

AS...

Alternatively, if you cannot rewrite it as a function, you can insert the result into a temporary table, like (without any error handling, ...)

CREATE PROC uspGetEmpDetail

AS

...