Hi, see the article: -

http://www.sqlservercentral.com/columnists/sjones/codingstandardspart1.asp

Regards,

Andy Jones

I think this is to do with the privileges for the account you started the SQL Server Agent service under.

Regards,

Andy Jones

For the authentication mode: -

xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', 'LoginMode'

This will return a number, see 'Creating a Setup File Manually' in BOL for a definition of the number.

Regards,

Andy Jones

As stated, if you drop and re-create the SP then you can run the following to find the date it was created: -

select crdate from sysobjects where name = 'SPNAME'

(This...

User defined functions are typically used in select queries to manipulate some data i.e.

select a,b,dbo.fnUDF(c) from table

A stored procedure could not be used in this case.

Not sure about the...

One option is to use the dtsrun command line utility along with the extended stored prcedure xp_cmdshell. Another option is oulined in the article: -

http://www.sqlservercentral.com/columnists/jwiner/dts.asp

Regards,

Andy Jones

sorry...

Regards,

Andy Jones

select col from table order by newid()

Regards,

Andy Jones

I had something similar. When attempting to populate full text catalogs everything would appear to work - no errors reported. But when I looked in the properties of the catalog...

Hi, I get this error when performing a backup not a restore.

Regards,

Andy Jones

Sorry for the error in translation!!

Same thing with the statement: -

drop index

.[#indexname] - this works.

This is on SQL2K what version are you using?

P.S. I'll buy the double cheeseburgers to...

I couldn't re-produce this. The statement

drop index

.[£indexname] executed successfully.

Regards,

Andy Jones

It is also of benefit if you are using full text indexing. Having a timestamp field in your table allows you to perform incremental instead of full updates of the...

No, there is no built in function. An alternative to a cursor is to insert the result-set into a temp table which has an identity field (1,1). Then select from...

quote:

---

Truncate could possibly tie up all resources for hours

---

Unlike the tsql command delete, truncate...