To answer your original question, yes Standard Edition does include SSIS, SSRS, SSNS. Check out this link for a more comprehensive comparison:

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

You can use the Developer Edition...

have the developers check SQL Server Configuration Manager on their machines, and see if they have an Alias setup under the SQL Native Client Configuration section. With an Alias,...

Do you know what your data cache hit ratio is? If it's in the mid to upper 90s, I wouldn't worry about SQL Server only using 300 Meg. ...

if you're limmited to using only 6 disks, I'd personally organize them in 3 pairs of RAID 1. We have a couple smaller production servers setup this way:

C:\ ...

OK, sorry for the confusion with VARCHAR(MAX). Since this question was in the SQL Server 2005 forum, I went with that. In 2000 you can have VARCHAR be...

One way to handle this type of situation is in a stored procedure, have a parameter for each column that could have a filter on it, with a default value...

I noticed in your COL_NAME function call that you specified 50. does the table actually have 50 columns in it?

Try this:

[font="Courier New"]SELECT *

FROM sys.columns

WHERE object_id...

Actually, you should be trying to avoid using the OS paging file on a database server. Database engines use a number of algorithms to determine if and when they...

CTE will be your best option. A sample CTE for starting at a specific ID type situation is below:

[font="Courier New"];WITH OrgHierarchy (OrgID, OrgName) AS (

SELECT...

Is there a reason that you need the datatype TEXT for this column? I believe that Microsoft is depreciating that in favor of the newwer VARCHAR(MAX) datatype. TEXT...

Whenever you restore a database to a different instance than it was originally backed up from, you will need to reassociate the logins to the database users. I use...

The difference may be in licenses. If the difference is really large, then the OEM version may just be the disc, and you'd have to purchase a license and/or...

I really believe that creating separate tables for individual products will cause you more headaches than it will solve. The options you could take are:

1.) The most flexible...

The first thing to consider is if the INSERT is just inserting one row by INSERT INTO... VALUES... or is it doing a query INSERT INTO... SELECT...

Also, does the table...

No offense Jeff, but I think you're taking the discussion a bit off topic. The original question had nothing to do with cursors as you know them in SQL...