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...
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...
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...
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...
How can you tell which columns in a database can told text data? I know you can look at information_schema.values. How about syscolumns tables? I...
Hello, I'm having problems writing a simple tsql. I know its something small but I just can't figure I out. Here's the scenario: I have a table...
Hello, I have a question regardign setting up active/active SQL 2K cluster. I was able to successfully set up two active/passive clusters from the...
Hello, I have a SQL cluster with 6 GB of RAM. I don#%92t have AWE enabled. Since I don#%92t have it enabled, does that mean that its not using...
Hello, Is it possible to change the name of a SQL 6.5 server running on NT 4? I have re-named a SQL 7 server but have never tried it on a SQL 6.5...
Separate names with a comma.
