Code Review

Technical Article

RE: Tsql Debugger - help please

  • Reply

Another popular mistake is to remove the sqldebugger-user from the domain which will result inEXECUTE permission denied on object 'sp_sdidebug', database 'master'error message. To get around this you need to create a similar new account and configure DCOM according to "Troubleshooting the Transact-SQL Debugger" in BOLHere's an interesting KB article.http://support.microsoft.com/?kbid=328173  

2004-07-30

Technical Article

RE: Including Sl.No column with the record set

  • Reply

Does your S.No column correspond directly to the empno (1, 1001; 2, 1002...)?If not, you probably want an identity column which will automatically increment.  Otherwise, you could use substring to pull the last digit from empno.  By the way, I wouldn't name the new column "S.No", "S_No" would be better.  Stuff like spaces, periods, quote marks, etc can cause […]

You rated this post out of 5. Change rating

2004-07-28

Technical Article

RE: Yukon Delayed Again and Named

  • Reply

With so many new features, YUKON (Sql Sever 2005) needs to get them very stable and secure before releasing regardless of the other licensing programs Microsoft customers have purchased.  I would like to see these things sooner just like everyone else waiting for this release.  But I like the new not at the risk of […]

2004-03-11

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers