i am sure your email address list will be huge.So better to add a distribution list in exchange server and add that it in "@copy_recipients" parameter.

JHow ? through SSMS ? then my guess is it will taking backup at default backup folder ? other...

"select *" command will fetch every thing from the given table.

select the "acual execution plan " option to see how sql optimizer is fetching data.means which index or which operator...

30 is for char or varchar ?

Any article link ??

i loved this internal hidden casting in case of integer values

can we opt here MANUAL FAILOVER option ?

yes..true ..i was also talking about...

which catalog ? try this select * from sys.databases where name = 'new Db name'

Spliting file definitely helps you. but the question what makes you to decide this spliting ?

What kind of issues you are facing on tempdb side ?

Rather you should focus towards the TEmpdb maintenance.thats the way to maintain tempdb size.

GilaMonster (8/3/2010)

---

So ask the DBA to run it.

Difference could be related to data volumes, stats that haven't been updated, difference in schema, etc.

Have you run the procedure from management studio...

vatha.meba (8/3/2010)

---

In development server it takes less than 1 min. but in Testing server it takes more than 10 mins and in testing server we don't have permission to...

vatha.meba (8/3/2010)

---

The scenario is there is a thread that works in the background in vb.net code which calls a stored procedure which does the insert.

Earlier it use to take 1...

James Tech (8/2/2010)

---

Yes it is the same...here is the...