Check if there are any indexes containing this varchar column.

If you change the data type of the column, indexes that contain that column also have to change.

Therefore, save creation script...

If that are MB, than message size would be 56 GB, which is very unlikely.

So, the size is either KB or bytes.

You can find a message in your outlook and...

XDetails plugin uses MS_Description, as it is standard in SSMS.

I heard (from a person closest to the author) that in one of the next releases of XDetails plugin for Sql Management Studio it will be possible to easily edit...

You can easily view column comments with free plugin called XDetails.

Here is screenshot (Description is field with column comments):

You can download it here: www.sqlxdetails.com

Dear sqlgreg, Sorry, I didn't mean to be rude. Just wanted to point out that asktom.com has profound answers on even the most complicated questions. Maybe I expressed that in...

No packages in SQL Server, unfortunately. Packages are one of Oracle advantages over SQL Server (do not start a war, please 🙂 ).

But, you have several other options to make...

Looks like a connection problem. Check provider and connection string parameters. Try changing provider version or try Microsoft OLEDB provider for Oracle. Try with another link-test expression instead of delete:...

Oracle has a very good documentation and excellent site that answers your even the toughest questions in detail by a true Oracle master: Thomas Kyte http://asktom.oracle.com

Top N question was piece-of-cake,...

Select LastName from MyTable

Where LastName like '[A-C]%'

Select LastName from MyTable

Where LastName like '[D-F]%'

or

Select LastName from MyTable

Where LastName like '[ABC]%'

Select LastName from MyTable

Where LastName like '[DEF]%'

...

It would be good to have...

SP:Starting gives you all stored procedure calls. E.g. your .net appliaction calls SP (event RPC:Start), and this procedure calls other stored procedure (event SP:Start). It is possible that your app...

Go to youtube.com and put this into search box "Using SQL Profiler"

If you want the fastest possible searches, at the cost of slightly slower inserts/updates/deletes,

do this:

Create an index on productcode.

Create a fulltext index on description. If you do not want to...

UPDATE() and COLUMNS_UPDATED() will give you a column if it is mentioned in UPDATE (or insert) statement.

That is, they will give you the column even if UPDATE updates it to...

That "slim chance" is here:

"$BODY$" - what is that ? Compiler probably asks the same 🙂 Get rid of that.

Functions cannot change database data (UPDATE/DELETE/INSERT are not allowed).

Using loops is...