Often it is useful to use xp_cmdshell and look at the results. In this example, can you ping the machine, try a traceroute see where it goes.

Why do you need to create an index in the first place?

The other option is to use dynamic SQL

declare @col1   varchar(100)

set @sql nvarchar(1000)

Set @col1  = ',Employee2,Internet_proxy,Ent Std Users - acct,Caravan2,ESP_GENERALUSERS,DL TGAKDST3,Developers_G,SMS_WORKSTATION_P,MSDN_Developers,IRLANSEC,APPS_INF...ATION1_CG,INFORES,DL MSDN Developers,'

set @sql= 'select * from...

The processor statement allows for the use of Virtual server where the OS that SQL is running in will only have access to x processors of the y processors available....

From MS website

If you have made a processor inaccessible to all operating system copies on which the SQL Server software is set up to run, you do not...

I think the only way is to create the index under another security context. This could be a SQL agent job but would you recoding some of your SP.

The other benefit of this is that it is the most performant way of calling an SP. The mechanism allows the SQL engine to very efficiently produce the parameterised query...

In the example the person is building a call to an SP in dynamic SQL whether it is in TSQL or VB it is still putting strings together thus the...

I would opt for the dynamic SQL route. however you will have to cope with differing data types. Add this as a parameter. You then don't have to worry about...

Try this

ALTER TABLE roysched

ADD CONSTRAINT CK_title_id

CHECK (CASE royalty WHEN 10 THEN 'BU2075' ELSE title_id  END = title_id  )

Are you creating your

"SELECT     COUNT(DISTINCT dbo.course_enrolments.student_fk) AS Expr1

 FROM         dbo.course_enrolments INNER JOIN

              dbo.Course ON dbo.course_enrolments.course_fk = dbo.Course.uid AND dbo.course_enrolments.courseversion = dbo.Course.version INNER JOIN

                      @StudentDerived ON dbo.course_enrolments.student_fk = @StudentDerived.student_fk

 WHERE     (dbo.course_enrolments.course_fk...

QUOTENAME return value is nvarchar(129) therfore will only return 129 characters. YOur best best is to use a storedprocedure and use a command object with parameters to pass your data...

SQL Injection is only an issue if you are using dynamic SQL. The only real place you should use this is to perform performant searching pbased on lots of optional...

That doesn't explain why it has replaced everything with nothing for the Latin1 collation. It must be a bug.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

MAXDOP well where to start.

The first encounter of this was with SQL 7. a very badly written statment resulted in an almost infite loop due to the parallel processes not...