Hi Jan,

it is possible, you will...

Sorry, I misunderstood you. You could either give them CONTROL, or use the grant EXECUTE statement with "WITH GRANT OPTION".

Andras

GRANT EXECUTE ON SCHEMA::dbo TO someuser

use SCHEMA to disambiguate

Andras

You can create dynamic SQL that is over 8000 characters on 2005. Example:

DECLARE @query AS nvarchar(MAX), @i AS int

SELECT @query = N'', @i = 0

WHILE @i < 500

BEGIN

SELECT...

Hi Doug,

While it may not solve your problem, as you say you have tried ExecuteXmlReader, one thing that is worth noting is that SqlDataReader generally chops up large XML...

Your solution looks fine to me :).

Andras

Sandy (10/10/2007)

---

Hey Andras,

Still I have the doubt on this,

My question was:

Can I Add a Column in a specific position of a Table By

using SQL Script, Is it possible...

@ECHO OFF

NET STOP SQLSERVERAGENT

NET STOP MSSQLSERVER

NET START MSSQLSERVER

NET START SQLSERVERAGENT

Regards,

Andras

Hi Sandy,

you need to rebuild the table, i.e. create a temporary table with the right column order, copy the date, delete to old table, rename the temporary table.

What you can...

It may actually be a problem with SQL Server. Have a look at http://support.microsoft.com/kb/930284

Regards,

Andras

g.sarvesh (10/8/2007)

---

Hi there,

i have a stored procedure and many parameters. i want to use "exec sp_name" and give some parameters of them then how can i give values for specific...

Steve Jones - Editor (10/8/2007)

---

There are definitely some strange behaviors in 8.0 mode. Andy Warren reported a few issues with some 9.0 features "bleeding" through into the dbs when...

Steve, you have started now a very very long thread 🙂

So to add to your style improvement (which is nicely indented), here is somehting that has qualified object names, and...

It looks fine 🙂 (well, of course when it comes to looks, it is interesting to see mixed casing, END and end :P)

It will be called once assuming that you...

There are many reasons for the tlog to grow, during maintenance one frequent reason is dbreindex. Switching to bulk recovery mode before the reindex and then switching back reduces the...