I once spent a full day of vacation with my wife and 5 year old daughter at Sea World while on the phone with work walking them through how to...

While paving parking lots with asphalt for my college tuition, I received a BS in Art. Then, 6 years later I went back and received and Associates in CIS.

It...

I tried what you suggested but still no luck.  I suspect what I am getting is ''65177','85709'' as the string since the parameter is declared as varchar(1000).

I also tried declaring...

I am not sure what you are asking me...  Can you elaborate?

I got around it by creating an embedded code function within the report.  I have tried it the way you are suggesting and still get the error. 

Thanks for your help.

I believe that a system of checks and balances is a necessary evil to keep quality and integrity at high levels but because of ENRON and SOX compliance I also...

Thanks Lowell.  I am not sure what that means when the first time through it took 41 seconds and the second time through was instantaneous.  What I had planned on...

Unfortunately, I can't count on the last line starting with TAGOUT.  The only thing for sure is that the first six lines are what I need however a user types...

I have recently created a solution for this for all servers (not just SQL).  All that it requires is that you have WMI running on the servers that you wish...

The dress code (or lack of one).  Where else could shorts, a t-shirt and sandles be acceptable for a highly skilled profession?  I live in the upper midwest and this is still...

Nevermind.  I did not include the .value portion of the field to summarize.  Once this was added, it worked fine.

What is going to happen when you explain to your 7 year old the changing of daylight savings where we will be changing the clocks one month earlier and one...

Excellent article!  I often wonder how/if Microsoft employees go through the certification process (MCSE, MSDBA etc..) being that they are working on the tools themselves.  This guy definately has a...

I started as a programmer/analyst and evolved into the DBA role.  My official titile is now Senior Systems Analyst but it could very easily be Sr. Systems Analyst/DBA/Sr. Programmer Analyst/Networking...

Greg,

This procedure sp_reassign_dtspackageowner is expecting three parameters @name, @ID, @newloginname

I can guess that @Name means the name of the dts package and the @newloginname is self-explainitory, but what/where is the...