I have to agree with Fred.  Sore-Box (Sarbanes-Oxley) has done more to kill creativity and morale than anything I've seen in my 8 years in the field.  The reactive interpretations...

You can still use the BACKUP LOG database_name WITH TRUNCATE_ONLY.  The server log will tell you this command is deprecated, but it still works to checkpoint the log file. ...

Hi, Amit.  Nice clean solution.  The only issue you might run into is making the [precentage] a decimal.

(count(*) * 100 / cast((select count(*) from table_a) as decimal(5,2))

Hi, Lisa.

Here is a way to do this using the Adventure works database.  First, use a common table expression to summarize by age group.  This creates a new field, AgeGroup,...

Hi, Brian.

I'm not sure if xp_delete_file existed in SQL 2K, but I used it in SQL 2005 as a workaround to a similar bug in the newer version.  Just add a...

Hi, Jonathan.

Those quotes are probably ensuring the proper division of your fields.  Without them, your data won't go to the correct columns in your target because you have commas within the...

So, now can someone explain to me why as a sysadmin in the SQL server I don't have the authority to affect the SQL services unless I am also a...

I just added my account to the Local Admin group on the box and it seems to be OK.

I was an admin there a couple of weeks ago - maybe...

Thanks for the reply.

Yes, I am a member of the sysadmin role.  This is a development server that I have been working remotely on for a few weeks.

E

Thanks, Guys!  This thread led me down the right path.  BOL had some useful info as well:

http://msdn2.microsoft.com/en-us/library/ms140355.aspx

http://msdn2.microsoft.com/en-us/library/ms141003.aspx

Pay close attention to the advice mentioned here as well as whether...

Michael,

Try using the literal value of the single-quote special character, CHAR(39), and concatenate this to the rest of your code.

Eddie