Hello, We are getting a very strange and generic error in our application log and I am unable to find any information on it. From my testing, the...
Greetings, There is a bug in a Cognos product that causes a report SQL query to deadlock all the tables used in the select statement. This issue is...
Very simple problem. We moved corporate offices, let's say location A to location B. The SQL servers are still in location A. We are in location B...
Has anyone ever seen this error? I got it on a process that has been running without change for over a year. What is causing this and what would be...
Hi, I am using Cognos Data Manager 8 ETL tool to run a simple delete statement agsinst a SQL server table. It has run without issues for years....
Hello,<br /><br />I have a major production issue in SQL 2000. I have software that no longer supports DBLIB and is forcing the connection to be...
I had TiVoli monitoring activated on my SQL machine. I am seeing the following TiVoli warning messages during my native SQL backups. What is...
Hello, I haven't posted here in quite some time. I like the new site and miss you guys. Now that SQL 2005 is out and a few months has gone by i...
Hello, I have a SQL server in the company that is on a differnet domain than where I want to connect to it from in Enterprise Manager. When I try...
Hello, I have a server with 6 internal drives and I asked for a 4 drive RAID 10 and a 2 drive RAID 1 configuration to my network team for them to...
I just got the marketing e-mail for QuickShift. Does anyone know anything about this or has anyone used this product? Does it live up to its...
My Network team is setting up a RAID10 for me on a dev server and they are asking what "Stripe size" they should set for the drive. It can be set...
Hello, I am replacing my 72GB 15K disks with 140GB 15 disks to increase the space on my server's hard drive and I am installing a new operating...
I see in some documentation on the web that there is an "LPAD" function: LPAD(string, length, pad), RPAD(string, length, pad) Returns string padded...
Hello, I looked through prior posts but did not find a solution to this problem. I need to do a conversion to a quasi Julian date (PeopleSoft E1...
Hello, I remember seeing a post here a while back related to this, but I am not able to remember the fix or find the post. I am testing a process...
Hello, I am looking at upgrading to enterprise to increase performance of my DB. I would like SQL to use more than 2GB of memory, which can only be...
Hello fellow SQL Server gurus and professionals. Hope all is well with all of you. I would appreciate if any of you can add your quick 2 cents on...
Hello, I am posting this question in this forum because, going by the descriptions of the other, it did not match up with any other. Also, I think...
I have a process that hangs at the drop index statement. I killed it and am trying to reindex using DBCC DBREINDEX or drop the index using the drop...
Separate names with a comma.
