Ok, I went back to BOL and looked at the syntax. The IDENTITY option is only available if you are adding a column. ALTER COLUMN allows you to add or drop ROWGUIDCOL but not IDENTITY. EM does it by creating a new table with the IDENTITY property, copying the data to it, dropping the old […]
2003-06-17
As a final note, you may want to go into Enterprise Manager and change the table in the Design View, then click Save Script button and see what SQL internally thinks is the best method for handling this...Sometimes this technique is useful in figuring out some of the trickier DDL constructs... Good luck!
2003-06-17
The problem you have there is lack of a root node. Not to serious though. To get exactly what you want, have a look at EXPLICIT. You can do it with that. There is an example in BOL which does that useing Pubs DB. That is what I used and hacked it apart. Another solution […]
2003-06-17
Hi j.o.s, quote: Brian, think that you should implement a time delay on the question so that all the hacks like myself cannot nip into BOL and find the answer. Guess the real point is kind of Zen like, and that we all need to learn in which ever way we feel comfortable doing. Good […]
2003-06-15
quote: maybe you have followed my thread about profiler and privacy? At the moment I can't use profiler until I get an answer on this? Not, I don't but I will have a look. quote: But my question was a bit unclear. Do you know if the ADO control utilizes WRITETEXT or 'advises' SQL Server […]
2003-06-13
Thanks. I setup the stored procedure but I cannot find it when I try to setup link from Management Sever Agent Jobs
2003-06-11
Create a stored procedure that does the required data manipulation, then assign the Job to run the stored procedure: "EXEC my_stored_proc [args]"
2003-06-11
quote: Boabab tree, häh??? Do you actually say "häh" in Germany? That's cool, we have exactly the same word here in Finland. quote: I am pretty sure you will find an answer to 'What's the meaning of life' on Google Discussions... Hehe, you should never enter those kind of discussion boards they take up all […]
2003-06-11
quote: Is the SQL built dynamically? I miss spoke above. In addition to passing the procedure dynamic global temp table names, I am also passing it various parameters for WHERE clauses. I replaced the dynamic global temp tables with static temp tables. did not help.
2003-05-30
1 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers