Hello, We have a new sharepoint 2010 farm setup and we were playing with fliestream. We decided not to use it and I disabled filestream. After...
Hello Everyone, I have a table in one of my sql server 2000 database that needs to store Chinese characters. So, I created a table and added data...
Hello all, I have an existing SQL 2K5 active/active cluster and I want to add a third node to it. Could someone please point me to any articles on...
Hello, I'm having an issue with one of my SQL 2K5 server. I'm trying to schedule my full-text catalog and I get SQL Server does not allow remote...
Hello, I have a question regarding unicode to ascii conversion. I'll be receiving data from a system that's stored in unicode format. Would SQL...
Hello, How can I determine the SQL server ODBC version? I'm trying to set up a an access from Oracle to SQL Server and its asking me for that. I'm...
We figured out the issue. And this is going to sound stupid....but we ran out of space on the drive. I verified that there was ample space but then...
Hello, I have a SQL 2K SP4 database on Win 2K datacenter that is set to autogrow but for some reason it does not do it. I verified that the machine...
Hello, I have a SQL 2K server w/ 4 processors. I read somewhere that its best to set the MAXDOP option to n-1. For example, in my case the max...
I found this article that explianed why I'm seeing the blocking. We started seeing this after we installed SP4....
Hello, On one of my sql 2k server I have spids that are being blocked by themselves. The blocking usually lasts a second and then another spid...
Hello, Right now I have my SQL 2K on a 32-bit cluster w/ 16GB of memory. I have the /3GB switch, along with AWE, and Max server memory option...
I have noticed that the CPU spikes up to 100% for about 10 to 15 minutes and then comes back to normal (30 to 40%). When it spikes up, I run a...
Hello, When I ran the sp_who2 command on one of my SQL servers, under the command column I got some processes that showed up as 'Conditional'. What...
Hello, I would like to set up an audit on one of my table to see who updates it, when its updated, and the statment issued to update the table?...
Hello, I have a question regarding datetime comparison. I have a table with a column called last_dml_update. The data type for that column is...
I have a database with about 900 stored procedures. I need to give execute permission to all those procedures for a new login. Is there a way to do...
Hello Everyone, We're trying to set up an active/active SQL 2K (32-bit) cluster on a Windows 2K3 64-bit environment. I was able to successfully...
I found what I was looking for: 34 - Image 35 - Text 48 - TinyInt 52 - SmallInt 56 - Int 58 - SmallDateTime 59 - Real 60 - Money 61 - DateTime 62 -...
When I looked at the syscolumns table I saw the value 231 in the xtype column. When I looked at the corresponding columns they were nvarchar. I...
Separate names with a comma.
