quote:

---

Microsoft told me not to use the /3GB switch in an 6GB or even a 8GB box. When AWE is enabled also.

-...

I'm in! 🙂

Personally, what I want is a CREATE SEQUENCE statement, as in Oracle and especially DB2, and of course, in the upcoming SQL:200n standard.

CREATE SEQUENCE seq

AS INTEGER

START WITH...

Easiest way to set the needed rights is to create a minimum privileged account, then in Enterprise Manager (this is one of those rare times where you actually 'need' to...

For a different way to insert images, check out the Bulk Image Insert (BII) tool in the SQL2k Resource Kit. Like bcp, but for image columns.

--

Chris Hedgate @ Apptus Technologies...

First of all, this is Oracle syntax with the outer join syntax (+), and the decode function also, so that query won't even work in SQL Server. I would rewrite...

Almost all of the sp_MS-procs are undocumented (all but one actually, of almost 500!). Many of them are not really a part of SQL Server per se, but rather apart...

I'd have to agree with Andy and Antares, never seen this either. I just tested it on a table with several columns, returning most of them, and with the where-clauses...

Don, that's a pretty cool solution. Another one, similar in the general idea, is to insert a row into a table and then do an immediate rollback, like this:

create table...

One important point (imho), that Antares did mention but I just want to emphasize it, is that SET @Foo = (SELECT ...) will produce an error if multiple...

SQL for Smarties is great (as well as Celko's other books), one of the most important books for your shelf. I'd have a look at the nested sets model he...

Not that I would recommend it, but I guess it could be done by creating a proc that accepts the word to check as a parameter, and tries running something...

SQL Server does not have anything like that, it is a database management system and a database management system only. So, yes, you will have to build your forms in...

Well, there are a couple of prerequisites:

* All object names should be fully qualified.

* Use paramater substitution so that the actual statement text remains the same.

--

Chris Hedgate @...

Hard to give any advice without knowing more about what you need to accomplish, but one advice I can give you is that if you really need to use dynamic...

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu