I've seen and tried solutions like this, and they are nothing but problems.

You will be better off parsing the value for your where clause.

Where Batch_Date >= '20050404'

  and Batch_nbr >=...

Sorry, I wasn't paying attention to the fact you needed this for reporting services.

The problem with RS is it binds a report to a datasource. That is why...

You have to move them object by object.

If there is a clustered index you do this by modifying the index.

-- Drop existing primary key constraint.

ALTER...

The EXEC statement basically creates a child connection so once it executes the connection closes and what happened in the exec was in essentially a different connection.

So you must execute...

try.

DBCC INPUTBUFFER(spid)

Shows you most of it, but now always all of it.

Please do not double post.

Refere to this.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=399771

Common question.

The question is why would want to do this.

This article basically talks about it

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=245273

Look up Case in books online.

Case col1 when 1 then 1 end +

Case col2 when 1 then 1 end +

Case col3 when 1 then 1 end +

Case col4 when...

sp_executesql With Example

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=395213#bm395219

Ref this post.

has a couple links

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=342272

Do a search on scripts, or discussions with concatenate strings and tons of stuff comes up.

Check out Books online, YOur friendly resource.

Schema Changes on Publication Databases

Microsoft® SQL Server™ 2000 supports common schema changes to an existing publication database. You can add columns...

reporting services 2000 does not have Dynamic sorting built in.

you would have to make it a parameter into the report.

If you upgrade to 2005, it is very easy.

Currently your trigger doesn't do anything except assing values to a parameter.

a couple things. You should always construct triggers to work whether 1 row is inserted, or more than 1...

Well Deleting old backup, then running new backup could be a problem if the new backup fails, and the old one was deleted, that leaves you without a backup.

If you...

Hey zippy,

There are literally hundreds of posts just like this.

the skinny is, should their log be 29GB? Probably not.

Is there something that can be done? Well yes, but the answer...