create a dummy job with incorrect syntax and run it. It'll fail.

Also how can create a database and...

Glad I could help you 🙂

mike-g (6/17/2009)

---

Pradeep,

Thanks for the links. I did read through them but still don't completely understand what I need to do.

I've created a login on sqlserver using an Active Directory...

That wont be necessary as you will be restoring the databases on the same version...

Charindex finds specific characters in a string

Patindex finds a pattern(you can use wild characters here)

Refer BOL. it has good examples.

http://msdn.microsoft.com/en-us/library/ms188395(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms186323(SQL.90).aspx

Pls do not cross post. this fragments your replies.

All, pls post your replies to http://www.sqlservercentral.com/Forums/Topic736804-146-1.aspx

mike-g (6/17/2009)

---

Pradeep,

ps (6/17/2009)

---

If you're creating AD accounts, you dont need to create seperate user ids for accessing databases. They'll use windows authetication to login to the server and then access...

I hope u've already planned but thought it worthwhile to mention here.

1. Are you going to restore msdb from backup? If not, you might want to script out all ur...

If you're creating AD accounts, you dont need to create seperate user ids for accessing databases. They'll use windows authetication to login to the server and then access databases as...

Dabears2k, Also go through the first link in Christopher's signature. This will help you to get correct answer to the point in future :-). You posted desired output much later...

Good point. however i tested it with the example mentioned in the same post. I used begin tran which gave correct identity value for logged-in user's scope... however i'll try...

seems to me like there is huge data insert activity happening?

Or are you running maintainance plans(index rebuilds?)

for the moment, take backup of the log more frequently.

later when there is less...

My next task would be learn CTE 😎 I've seen many solutions using CTE here.

i tried googling but of no help. I guess it's not supported.

Great analysis Christopher!! in fact subqueries are more often slower than not.

and yeah, I'm not that proficient in CTE 😉

Got something to learn here. Thanks 🙂