http://jimbojw.com/wiki/index.php?title=SQL_2005_-_Why_You_Can't_EXEC()_Inside_a_UDF

http://support.microsoft.com/kb/934396

select

a.*

from openrowset('SQLNCLI',

'Server=servername;Uid=sa;Pwd=password;Database = database',

...

Cryptic message could be caused by two separate issues:

1. When DVD contents was copied, the folder attributes are still set to "Read only" rights.

2. Network rights of an end user.

It...

That is because the PageSize is not set in SSIS.

Here is a scary solution: http://support.microsoft.com/default.aspx?scid=kb;en-us;315071&sd=tech

Personally, I prefer this one: http://codebetter.com/blogs/brendan.tompkins/archive/2003/12/19/4746.aspx

Try SqlRun_Tools.msi in Tools\Setup folder.

An application pool provides you with a way of isolating Web sites from each other.

If you are running Windows XP, you have IIS 5.1 (no support for application pools)

If...

Can you please verify what data type is used for ModifiedDateTime,CreatedDateTime columns?

I adore sarcasm, but I was hoping that the example I provided was clear?

Of course I might be wrong, but what I meant was:

I understood that you are using this...

Your ELSE condition should be executed only in very special conditions which are not related with the information in your "inserted" table.

Omitting critics on trigger design...

At the very beginning you...

CurrentLevelXID is of the varchar type. You have to use single quotes in WHERE condition. Otherwise, something like (CurrentLevelXID = 70 AND 1=0) will return TRUE.

Try to debug the SQL...

You have two options:

1. Follow your initial intension and spend a lot of time on rebuilding indexes just to find out that your intension would lead to a moderate if...

I guess the initial questions should be:

- And why is it so bad having clustered and nonclustered indexes on the same column?

- Is it possible that they...

The better approach would be to employ a normalized database design.

Based on your query, I can see that Product exists in table Products multiple times.

Split your table on three tables:...

Besides a valuable information about number of page splits comparing INT and uniqueidentifiers, this article contains some suggestions on "giving blanket advices" 🙂

http://www.eggheadcafe.com/software/aspnet/31678698/what-is-a-page-split-fro.aspx