Joy Smith San (3/15/2014)

---

Gile,

Suppose an...

you will need to run a query to find "your" blocked spid and kill that if you want to use the current SSMS application you have open (you will need...

You just have to wait for the rollback to complete (and yes it may take a very long time for such a large table). What do you mean the...

the script below will help - you can parse through the "PackageData" column to see what each connection string is pointed to with ChildFolders

as

(

select PARENT.parentfolderid, PARENT.folderid,...

Is this database acting as a publisher? Or do you have CDC enabled? What does the log_wait_reuse_desc say?

You should never opt to use RECOMPILE over looking to see if you need an index (and creating it if it is needed). That being said, you don't want...

Is there any chance there was index, or statistics maintenance going on during this time?

Ouch, very sorry about that, Ville-Pekka Vahteala is correct, these service do NOT need to be enabled.

Glad you got it figured out without resorting to using the hints 😉

You mean that the input parameter contains a string like: 'INPS45,INPS46,XYZK45'?

Thanks for clarifying that Gail, I see the difference!

To aid, you can also use:

DBCC FREEPROCCACHE(plan_handle) - this will only remove the plan for the specific thing you're running and will not flush the entire cache.

Or, if it's a...

You could also create a variable in your package, set it to the rowcount of the table, then add a precedence constraint on your connection to the send mail task...

Give this a try:SELECT City, cust_name [Customer], SUM(sales) [Sales] FROM cust_details

WHERE city = 'Tamilnadu'

GROUP BY GROUPING SETS ((city, cust_name), ())

SELECT cust_name [Customer], SUM(sales) [Sales] FROM cust_details

WHERE city = 'Tamilnadu'

GROUP...

selvakumar.sms (3/13/2014)

---

I tried various possibilities,no luck...

here my small doubt i need IIS service in Server or i need to enable SMTP service in server ?

IIS and SMTP services are not...