I don't believe so. one of the parameters you use in an OPENXML call is the document handle returned by that proc, so you pretty much need to call...

that proc basically creates an instance of the DOM on the server. this is a COM object that implements an xml document parser. It's used when you use...

in software, pretty much anything is possible. The point is that this is not a good idea.

why are you trying to do this? what's the backstory?

a well designed system does not create database objects on the fly like this.

You can't do what you are trying to do. If someone comes along and...

forget about using a trigger for this. use a proc.

don't use GOTO, rather use COMEFROM.

sure. some call it /dev/null

or simply a black hole.

🙂

redgate database tools work for SQL Server only.

I wrote a doc tool that may be of use to you though. It finds dependencies for databases on all major platforms:...

of course if you have a large column you should use varchar(max)/nvarchar(max)/varbinary(max) as opposed to text/ntext/image. that wasn't the poster's question though.

they asked whether you should prefer varchar(int) compared...

http://www.sqlservercentral.com/Forums/Topic551587-360-1.aspx

one drawback is that varchar(max) can't form part of a index key.

also it's simply wasteful and inefficient.

when you write a program in C, you don't allocate 2gb of...

are you using the -b flag? if not you should be. otherwise, the entire insert gets committed as a single transaction, which will blow the log file.

use something...

Atif Sheikh (8/9/2008)

---

my idea is to create at table with AttributeCategories, Attributes, AttributeValues and AttributeForm.

Attribute Category my have the information like 'Demographics', 'School Information', 'Contact Information', etc with its...

length of object names does not matter as far as perf is concerned.

also, about stuff at home being stolen - if you work from home occasionally (as I do) it's much better to remote in using RDC or similar and do work...