Brandie Tarvin (1/10/2008)

---

This is annoying.

BOL doesn't have any topics that I can find on granting statement level permissions with T-SQL. In fact, I had to go to the SQL...

bleighton (1/10/2008)

---

thanks for that... should have mentioned that I'm connecting to 2000... (crucial info missing)...

I have found the following though which seems to work

select (select SUM(1) from view1 where...

You can use the row_number() function (available on 2005). An example is:

select row_number() over (order by columnname) AS rownumber, * from somerandomtable

just replace the columnname and somerandomtable with some...

Yes, you can. The edition does not matter, so you can even restore a 2000 Enterprise backup to a 2000 Standard edition server.

Regards,

Andras

nofear_1k (1/9/2008)

---

Hi im reletively new to SQL and would like to know if I can do this.

I have a main table Table1 which has name and address and a Field...

These files can stay on the same...

Alexandru Petre Ionescu (1/7/2008)

---

Is it the only way ? I actually have to change the authentication mode for an SQLExpress instance and there is posibility to exist more than one...

To change it to Windows only you could use:

USE [master]

GO

EXEC...

hb21l6 (1/2/2008)

---

thanks for the reply Andras.

I need to delete data that is 3 days old from the database. I'm just using a select to show the data to start with...

Are these databases detached/attached? Or are they dropped and then created using T-SQL?

Management Studio will not follow these changes, but you could just refresh the object explorer (Rightclick on the...

hb21l6 (1/2/2008)

---

well, it doesnt give an error as such, it just stick a few spaces in the SQL.

e.g. = "getdate()-3" changes to "Getdate() - 3"

this is the query...

SELECT...

You cannot use raiserror in a user defined function written in T-SQL. You could rewrite your function as a stored procedure with an output parameter for the return value, but...

h.schlais (12/28/2007)

---

Steve,

We tried Log Rescue and have a question. If a procedure opens a cursor and brings in a result set of 100,000 records then enters a while loop which...

Chris Gierlack (12/14/2007)

---

Dynamic tsql is difficult because in my situation, I have a rather long procedure with other local table variables that I need to access. When you use...

Adam Haines (12/14/2007)

---

Andras,

Cool solution, I did not even know about this feature. It seems like managing objects with synonyms can become confusing and messy, if you do not know...