How do you spell

mercenary?  But it is not easy to find work with good companies without them because they don't get paid if you are not...

(In the Microsoft SQL SERVER 2005 book (pp 151) it say you can but it's not happening?)

If the book is new return it because skilled SQL Server users knows what...

That is correct I met one of the writers of the above book he did not know the difference between UNION and UNION ALL and biggest was they did not...

Triggers are obsolete for most development needs because the RDBMS vendors created triggers to enforce business rules before pure object modeling. Now you just grab a conference room and model...

I have used Oracle 8i, 9i, & 10g and you cannot compare Oracle documentation to SQL Server, ask me for a SQL Server book and I tell you the BOL. ...

That is correct but the time I answered this post it was not the advice I will give based on duration in recovery.  Delete starts a clean restore with recovery...

You run into this pesky problem when you restore a database with no recovery option per Microsoft that is not valid so SQL Server keeps your database in recovery until...

In Management Studio right click on the database and go to files click on Primary and increase the size and you may want to adjust the percent of auto file...

Actually Vista Ultimate is the only Home edition you can run all features of SQL Server 2005 because Reporting Services require Windows Authentication in IIS and Home Premium does not...

What I am trying to tell you is there is very limited developer control of how report pages are rendered.

Removing blank page is not easy if you have hidden images and export to PDF, I find if you increase the page size above 8.5 this problem goes away if...

SQL Server Express comes with 1gig ram restriction for everything you run, check the link below for details.

http://msdn2.microsoft.com/en-US/library/ms143685.aspx

I declare all my report parameters as NVarchar and I have also seen it as Nvarchar(max) with all the needed conversions in my stored procedure and in the Report configuration I...

I think you have standard Express it is limited so go the link below and download the Express Advanced and uninstall the standard Express and install the new one.  Then...

Hi Lynn,

You can use a regular stored procedure to run SSIS packages with a Job since SQL Server 7.0 Microsoft have changed a few things and have documented somethings.  A...