sysadm 77674 (6/17/2011)

---

As mentioned before the online rebuild is not working as expected.

Whenever we do this and there is a transaction which makes an insert into the designated table where...

mirroring won't help because one database will always be offline in NORECOVERY mode having the transactions applied. you won't be able to do anything with that database. you might try...

thanks. a dns alias is a better idea.

what is the procedure to switch back to the publisher after the failover error is resolved? do you need to re-setup the...

Syed Jahanzaib Bin hassan (5/20/2011)

---

Performance can be effect and its depends on the Processor physical or logical ,RAM and Storage controller

Operating System Version ? Windows Server 2008 R2 Enterprise

Total...

Grant Fritchey (3/8/2011)

---

Not to argue with you, but I put in a decimal value, 0.50, and it accepted it just fine. If I didn't put the zero in front, it...

for the 3rd time...IT WON'T ACCEPT DECIMAL VALUES. :crazy:

and 95% is simply an example value. it's just an easy value to make the server hit to test alerts.

the BCHR isn't working for the reason i mentioned. it won't let me enter decimal values, only integers. i entered 50 (for 50%) but it's warning for .97 (97%). ...

FYI

It was recommended to me on another board that I try this:

You get this error, because SQL Server does not know which rules to apply. If the strings are "April"...

The problem is that this is an SAP db server and it is required to run the SQL_Latin1_General_CP850_BIN collation. So I can't change the server or db collation.

I tried...

wow, so responsive! i wish all forums were so well moderated. thanks!

would you like to send my post on sharpoint to the forum as the honorary first post? 🙂

http://www.sqlservercentral.com/Forums/Topic1020810-391-1.aspx

good point but the service account issue should not be a problem. we're using the same service account currently on both servers (SharePoint and SQL 2008 cluster) so the end...

***SOLVED***

The problem is that there seems to be a bug in the IBM 64bit ODBC driver. We have ODBC connections working properly to this AS/400 database for other applications (MS...

Ed, thanks for the help but sadly, I still have the same problem.

The OPENQUERY syntax is from our developer. I let him run with it as it doesn't matter to...

More strangeness -

I use the IBM Data Transfer from Iseries program to test out a direct transfer outside of SQL. When I connect and transfer to 'display', I see...

That was actually a mistake in the above cut and paste. It was from one of my later experimental tries. I have tried Force Translate = 0 (and = 1)...