What size databases do you have on the server?

Do you have SQL Server set to dynamically manage it's memory?

What else is running on the server that needs the memory?

Are you specifying the query text in the report designer, or are you calling a stored procedure?

Iis the report running for the previous week, or just the past seven days?...

You shouldn't need to have any script to transform numbers and dates. The ints should be fine with implicit conversions and there is a DateTime transformation that specifically handles importing...

And don't forget our ever reliable friend Books Online

The "WITH NORECOVERY" clause means that the database will stay in a restoring state so you can restore multiple backups and maintain transaction consistency. Without NORECOVERY, SQL Server would rollback any...

DTS packages are stored as binary objects in the msdb database, as such you can't export all the details.

To get the whole package in a readable form, you could save...

I fail to see where the provided link has anything to do with field or row field terminators.

Surely any command with a syntax like,

bcp {[[database_name.][owner].]{table_name | view_name} | "query"}

    {in | out...

You're almost there with your second example. Just wrap the drop in an EXEC statement.

EG: EXEC('DROP DATABASE ' + @DBVARIABLE)

Also, you could simplify creating the database name to

SELECT @DBVARIABLE...

Sorry to come into this so late, I can only blame the timezones

How about a mini-MVP (Most Valued Poster) for the month?

Maybe...

The switches for BCP have always held some sort of mystical property. I mean there is such a thing as too many options.

Removing both would have caused BCP to use the defaults which are tab and newline.

So are these the same servers or as you stated in your initial post "when published on different servers on different computers" unless the hardware and display properties are set...

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

Please do not cross post.

Based on your response under the other post,

"yea,i am trying to do that thru the enterprise manager...any way around it? i dont want to...

You'd also have to take into account the display capabilities of the point where the reports are being viewed.

eg: If you develop a colorful report using 32-bit HiColor and the...

As per my earlier post "GO signals the end of a batch".

Did you run the statements both with and without the GO and see the results?