UNDROP is not ISO compliant. PICKUP TABLE is what you want to lobby for.

I wrote a documentation tool called SqlSpec that supports SQL Server as well as 13 other platforms. It allows you to add an xml comment header to each proc/view/function...

should also add bcp.exe to the list.

yes I tried that, didn't work for me.

well i got this working. here's what I had to do in case anyone else has this problem:

1. enable the administrator account on the local machine

2. logout and log in...

does anyone have a solution for this? I have the same problem and have found nothing that works so far...

🙁

I explained it above. The problem is that the client tools (SSMS) you are using are out of sync with the server build. Most likely the client is...

could try posting here: http://sql-server-performance.com/Community/forums/30.aspx

try msdb.dbo.sp_help_job

have a look at the classes in the System.Xml.Xsl namespace.

In particular this one: XslCompiledTransform. It has a Transform() method that will do what you want.

here's what the server guarantees regarding ordering:

http://blogs.msdn.com/sqltips/archive/2005/07/20/441053.aspx%5B/url%5D

well, ok, but I hope you don't think this will protect you from sql injection!

🙂

duplicate post. http://www.sqlservercentral.com/Forums/Topic563534-146-1.aspx

if SQL Server hosts it, it's OLTP. if Analysis Server hosts it, it's OLAP.

well, it looks like you got the answer you were looking for here:

http://www.sqlservercentral.com/Forums/Topic560115-324-1.aspx

you may also benefit from having a look at the triggers here:

http://www.nigelrivett.net/index.html#Triggers

fyi, sqlmail is deprecated in 2005 in favor of Database Mail. Database Mail does not use mapi profiles. It uses smtp.