Sure it will, appreciate it if you would. Have been looking into exec plans with CROSS APPLY from a physical table to a UDF returing a table today as well....

GilaMonster (3/5/2009)

---

Scalar functions never do. It's one...

I'm not 100 percent sure, but I vaguely remember reading that Visual Studio Team Edition for Database Professionals allows you to extract an entire schema and store it in TFS.

I agree with Warren. I read the same BOL article and that's why I answered YES.

By the way, the MSDN article quoted to justify NO being the correct answer doesn't...

Add /S to the command line as well. Just be careful to run it in the intended directory! I once wiped almost my entire harddrive because I inadvertently ran it...

Hi Daniel,

Just an idea, but why don't you first fix those dates/datetimes in MySql BEFORE you try to transfer the data to SQL? That's of course assuming that you can...

Good Luck, Gail! I wish there was a User Group in Cape Town as well.

In BOL under ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/ee6b9116-a7ff-463a-a9f0-b360804d8678.htm

it is worded slightly differently in that it says

That also leads be to...

Try this version using a Tally table. No loops, no cursors.

IF OBJECT_ID ( 'tempdb..#Tally' ) IS NOT NULL

BEGIN

DROP TABLE #Tally

END

GO

DECLARE @AlphaNumber varchar ( 20 )

DEcLARE @numtoadd ...

Brilliant article! Reminds me somehow of one of my colleagues who wrote the following in C:

int x = 1;

int y = 2;

x ^= y ^= x ^= y;

just to swap...

The answer doesn't seem to be 100 percent accurate. If you look up BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/016fb05e-a702-484b-bd2a-a6eabd0d76fd.htm under SNAPSHOT ISOLATION it reads:

Except when a database is being recovered, SNAPSHOT transactions do not...

Jacob,

Have a look at http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/. Keep in mind though that the article was written in 2003, so it pertains to application roles as they were implemented in SQL2K. Things may...

jim.powers (7/3/2008)

---

This really isn't that hard to understand. The link posted with the question's answer is plainly obvious.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

In the Workgroup column on the row for RAM, the limit is clearly...

You are right about the URL Kev. Don't ask me how I managed to drop that "b" when copying and pasting.

And yes, you are right when you say that the...

But if you look at

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/09bcf20b-0a40-4131-907f-61479d5e4d8.htm

in BOL it reads "Operating system maximum".

To me 3GB looks more like a limit imposed by Windows 32 bit architecture on an x86 machine. Has anyone...