Pradyothana Shastry (5/27/2009)

---

Adding more disk space is one better option. If you want to keep dialy one day backup then better option is 'With copy_only' so that it will overwrite...

Here is the code you are going to need. Please note the clustered index created on the temporary table. This is required as it controls the order of...

T o o m u c h b e e r.

Wait, no such thing! I think we are all "floating" and have too much fun.

:w00t:

I like that!

Actually, since neither FULL BACKUPS or DIFFERENTIAL BACKUPS truncate the transaction log, and starting with SQL Server 2005 TRANSACTION LOG BACKUPS can run while FULL BACKUPS are running, I see...

ningaraju.n (5/27/2009)

---

Thanx saurabh.dwivedy

The code is dynamic...

Occurence of CAST is not Known..... it may occur 100 times or 0 times

and the Variables inside the cast also not known...

and the code...

Hopefully I did it correctly for your databases and tables, but this is how I would have written and formatted your code. I am curious how you are using...

ningaraju.n (5/27/2009)

---

Hi Friends...

I need find the exact string pattern in an String

For Eg:

my Main String is like this

Declare @Str='I am going to have Asset table

and in that table...

Hey, I just hope they aren't using a smallint for the number of posts. If you think about it, we really aren't that far away from 32,768. :w00t:

And using dynamic configurations, you can change servers and databases as easily as modifying a configuration file. A good book is from Wrox, Professional SQL Server 200r Integration Services,...

Kris,

Glad you got you query problem solved. Now, I'd like you to carefully read the first article I have referenced in my signature block below. When you have...

9 bottles of beer on the wall, 9 bottles of beer! Take 1 down pass it around, 8 bottles of beer on the wall!!

Alvin Ramard (5/27/2009)

---

Lynn Pettis (5/27/2009)

---

There is nothing inherently wrong with this post, but I have to wonder off to my tent in the desert. What do we do as...

There is nothing inherently wrong with this post, but I have to wonder off to my tent in the desert. What do we do as DBA's that isn't technical...

Amol.Naik (5/27/2009)

---

I just edited my post which probably would have gone unnoticed, i am adding that here again:-

The Stored Procedure hangs indefinitely at the UPDATE statement.

Just to re-iterate, all i...