I dont think it will be possible to do this directly from the backups, as you made changes this morning that you don't want restored you will not be...

In the screenshot it says <servername>/reportserver

Howevr you mentioned that this error happens when you deploy the report, you should be deploying to <servername>/reports

Check the deployment destinations in the...

I would still look at the execution plans to see if there is a difference, and then at least you can eliminate this from your investigation.

There is a possbility...

you really need to look at writing the procedure in a set based manner , you seem to have a very procedural approach to the code which is fine...

you will not be able to use a msgbox popup as this is server-side code and will not run at the client, you 'could' try something with Javascript -...

you could do it batches using a where clause limiting the PrimaryKey to groups in the delete statement.

I have to ask though, why can you not use Truncate it would...

deepak.a (3/15/2011)

---

Hi GSquared,

thanks for your reply it is DNS problem i resolved it and also ima facing one more problem in safari ,UI disturbance.Like

calender control is not working in...

if the table is on it's own filegroup then yes , otherwise no

Were the statistics updated when transferring to the new server? as this could cause performance differnces

I would start by looking at the execution plans of the Ten Queries between...

That's true, I guess i would consider that to be a custom component, rather that a re-usable component.

Where a re-usable component would be a SSIS transformation...

Henrico Bekker (3/15/2011)

---

Was reading through some blogs of the top SQL people, Brent, Gail, Kimberley, Pinal etc....and was wondering, how do you start a good, no sorry, excellent blog, that...

Sorry, It can't really be done in SSIS (Aside from cut+paste).

Instead of opening it on the other server, you could run the script from the command line using SQLCMD

Do you have SA access and control over the second server? if so you could do something like John has suggested..

otherwise i dont think there is anything you can...

Try using a capital 'C' in the where clause the for color column name

SELECT [ProductID]

,[Name]

,[ProductNumber]

,[Color]

,[ReorderPoint]

,[ListPrice]

,[ProductLine]

,[Class]

,[Style]

FROM [AdventureWorks].[Production].[Product]

where [AdventureWorks].[Production].[Product].[Color] like 'black%'

It would appear that you have the database set to use...