Hi, I am using the SQL Server 2000 as RDBMS.. I am tasked to develop an application which is supposed to handle user's comments/notes on many different web sites. Each site has its own specific data which uniquely identify the notes/comments entered on it. So, i must store that specific data in my...

I have a SQL Server 2005 active/passive cluster which has the quorum drive on a partitioned SAN LUN. I want to fix this and get the quorum drive on its own dedicated SAN LUN. What is the best way to move the quorum from the old LUN to the new LUN? Thanks in advance.

Hi, I'm experiencing a hugh performance difference between 3 SQLServer setups where the best/quickest machine has the worst performance. I'm out of ideas where to look. I have a very simple database with 2 tables each containing 1 nvarchar(35) column with a unique non clustered index on that...

Hi, I have problem after exporting excel data to sql server. I got whitespaces in columns and I need to remove whitespaces in all columns in a single query. I can remove the whitespaces single column at a time.But I need to remove whitespaces in all columns at a time.Is there any possiblity to remove...

one final item that was found by the development team that eliminated the need to change the column to Nvarchar was an article by IBM that pointed out this same deadlock scenario. There solution is as stated: There is no easy way with JDBC to specify or identify the proper types to be used for this type...

Hi, I'm trying to build a stored procedure in order to import data from an excel file to a temporary table. I'm using the following code: set @strSql = 'SELECT * INTO #TempTable FROM OPENROWSET( "Microsoft.Jet.OLEDB.4.0", "Excel 12.0;Database=C:\FileName.xls ","SELECT...

True, when ever a new user is created it is added to public role by default. While creating a user if you set it for the particular db access he/she can access that particular database only (including system databases). Refer http://www.databasejournal.com/features/mssql/article.php/1478701 or BOL for...

see if the snapshot folder is their and by any chance not deleted by anybody and it has a proper NT permission for the SQLServer Agent account....also check the snapshot agent job history for the exact error message which will help u rectify this issue

Hi, Please refer Books Online about the collations where you can find all the information you wants to know