Hard to tell from here, can't see what you see. Please read the first article I have referenced below in my signature block regarding asking for help. Follow...

I'm going to go out on a limb here and say it may be a bug. I tried it on a check constraint on a table in AdventureWorks, and...

I would not put them on the same spindle as the OS and paging file. I would still give them their own spindle to reside on, separate from the...

Not worth the hassel. You can use SQL Server Express (free!) as a witness for database mirroring. Why would I pay for this functionality when it is easily...

Does the following snippit help?

declare @TestStr varchar(128) = 'TRITON9700 L9700031288172 10-07-09 | EDC TRITON 9700 CASH DISPENSER';

select

SUBSTRING(@TestStr, PATINDEX('%[0-9][0-9]-[0-9][0-9]-[0-9][0-9]%|%',@TestStr), 8) as CharDate,

CAST(SUBSTRING(@TestStr, PATINDEX('%[0-9][0-9]-[0-9][0-9]-[0-9][0-9]%|%',@TestStr),...

Hot link to other post: http://www.sqlservercentral.com/Forums/Topic1053496-149-1.aspx

Hopefully you have read all of the info regarding BACKUP LOG. Your command above will create...

Little Nick (1/25/2011)

---

I've gone through Managing Transaction Logs, http://www.sqlservercentral.com/articles/64582/

My final decision is

1. I choose Recovery Model is FULL

Based on article quote "Full recovery can be difficult to manage as the...

Nevermind, I found it in the Visual Studio Help System,...

In what? As I said, I can't find it anywhere in Books Online.

ada.xi (1/25/2011)

---

hi all,

I try to give a expression to round some filed like below,

Round(Fields!unit_price.Value, Fields!Dom_Price_Places.Value)

...

Also, from SQL Server 2008 BOL:

Important:

The Pager and net send options will be removed from SQL Server Agent in a future version of Microsoft SQL Server. Avoid using...

IIRC, pages are simply not sent outside the stated hours. A good place to check this out would Books Online, the SQL Server Help System.

cabrerajm (1/25/2011)

---

Hello good people,

Need help with this update query statement. I am trying to update multiple records with this update query. It looks something like this:

update...

I have written code that does just this, however, just like Gail I'd like to know the business case behind doing this. In addition, I am curious to know...