I found I have a lot of process to run this process, but I don't know whats that. Thank you. ...more >>

Hi, Im having trouble connecting to the SQL2005 default instance installed on one of my sql servers within my domain. I have a second SQL2005 server that I can connect to just fine. Both are in the same OU. This particular server, I can connect to AS2005, but not to SQL2005. I keep get...more >>

Dear all, I need to copy a database from SQL server A to SQL server B, but the name of database in SQL server B should not be the same as in server A. (Both SQL servers are 2000) Can anyone advise which is the best way to do that? Thanks in advance! Ivan...more >>

my config is SQL2000, outlook xp now i use xp_sendmail to see email from SQL2k how can i use different mail profiles for different database? or i can control it at script level? i have searched google for this and seems it is feasible. grateful if you could give me some hints. by t...more >>

my config is SQL2000, outlook xp now i use xp_sendmail to see email from SQL2k how can i use different mail profiles for different database? or i can control it at script level? i have searched google for this and seems it is feasible. grateful if you could give me some hints. by t...more >>

Hi, I'm trying to process a cube that I've just migrated from AS2000. The cube processed just fine in AS2000, however when I try to process the cube in AS2005, I get a nested too deeply error when processing one of my dimensions. Is there a setting that manages how much nesting is possible...more >>

hello, any white paper from microsoft or 3rd party that show the performance differnet between 2005 sql 32 bit and 64bit edition?? Thanks in advanced. ...more >>

I am experiencing an error message when I run a TSQL and I don't know how to correct it. Server: Msg 8115, Level 16, State 8, Line 38 Arithmetic overflow error converting numeric to data type numeric. In this code I am extracting hierarchical information. I am going 6 levels deep. The s...more >>

I use SqlServerExprerss 2005 Manager to backup a DataBase to c:\aa.bak, but it fail with message "Can't open c:\aa.bak" But if the file is in the directory of C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup it ok. How can I bakup a file to c:\ ? ...more >>

SQL2K SP4 Howdy all. I have a query with bizarre results in Query Analyzer. Box1; 4 x 3.0 processors, 4 gigs of RAM. Results never come back. Box2; 8 x 3.0 processors, 16 gigs of RAM. Results never come back. Both of the above boxes are extremely under utilized. The absolute max amount ...more >>

Hello, After analysing waits in my SQL2005 database, it appears that a lot of time is spent waiting SQL Trace buffer to be flushed. Is there a way to disable SQL Trace counters to improve overall performance ? TIA. ...more >>

Hi. I was wondering what is the default differences in the following 2 sort order ids: 51 - SQL_Latin1_General_CP1_CS_AS collation. 71 - Latin1_General_CS_AS collation. As some of you may have guess, the same SQL code returns different results sets from two servers that are nearly the sa...more >>

Hi, What is the difference between SQL2000 and WMSDE ? Thanks ...more >>

Hello - I'm trying to migrate data from an Access 2000 database to SQL 2005 Express programatically. Both databases have the same schema. Most primary keys are Auto Increment fields. I'm having the issue that even if I set primary key manually in my code, the Auto Increment rules seem t...more >>

Hi guys. We have a DB system that is relatively small and transactions are not very big, but very important, losing data will be very costly to the business. I am assigned to port this system to SQL Server 2005 Sp1, we have decided to implement the DB mirroring with the High Protection mode....more >>

hi, I have created my own dll file that I would like to use in sql 2000 as an extended stored procedure. I have checked the dll is written correctly (I can use it in other application). The dll file is created in C# (Visual Studio 2005). Unfortunatelly I cannot use it in sql as the extended ...more >>

Hi, does anyone have the overflow issue with the column, rows in the sysindexes table? We have table with over 3 billions records and it throws error 8115 overflow error when I double click the table, which should return row counts in the table. There is no issue with all data manipulation on ...more >>

Has anyone encountered this behavior? SQL Server Hot Fix Roll-Up package was installed on SQL Server 2000. SQL versions were updated from 8.00.2040 to 8.00.2187 as part of this roll-up package installation. The SQL Server patch installer required a server reboot after the installation which w...more >>

This is one that I've seen asked often but without a definitive answer: Is it possible to migrate linked servers including passwords to a different server. I can get this to work on the same server with the script below but I can't get it to work on a different server. --set up sp_addlogin ...more >>

Here is a very simple test that I ran on my 2000 and 2005 box and in both cases I got different results. When I ran this command on 2000 it worked fine but when I ran the same script on a 2005 box I got the follwoing error. sp_addapprole 'aaa','aa1' exec sp_setapprole 'aaa','aa1' exec sp_hel...more >>

I am using SQL Server 7, 2000 and 2005. I want to create a stored procedure for my query. My query is as follows: select column1, column2, column3, column4 from table where date1 >= 'Jan 1, 2006' and date1 M 'Jan 2, 2006' and id1 in ('1', '343', 'ABC') The trouble I have is the dynami...more >>

I need to peform a log backup with no truncate. My regular maintenance plan runs like this: EXECUTE master.dbo.xp_sqlmaint N'-PlanID FB8A5BE6-65F9-498C-8F76-AA324BB6139D -Rpt "G:\Program Files\Microsoft SQL Server\MSSQL\LOG\DATABASE_NAMEDB Maintenance Plan6.txt" -DelTxtRpt 4WEEKS -WriteHistor...more >>

Using AccessXP as Frontend and SQL Server 2005 as backend. Tables are linked via ODBC. Last Known action before error appeared: Deleted all records from linked Tables. I add a record including the PK to a table - no problem. I do it again and get error message because of key violation. Code...more >>

I'm using SQL Server 2005 Express. Before this, I use SQL Server 2000 there's a SQL Trace utility, is there an equivalent for SQLExpress? -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1 ...more >>

How can I pass a list of comma seperated values to an IN statememnt? ie @parameter = '1,2,3,4' select * from table_name where column_name in (@parameter) This can be executed dynamically, but is there any other method? ...more >>

I am accessing a linked server through a VPN connection. I am updating through an Access interface. The first time that I perform an update on the linked server table, I get an update on linked table error. The new transaction could not enlist in the specified transaction.... After I click OK...more >>

Does anybody know where stored column description in sql2K database is? Is it possible to script table with this information. Thanks in advance ...more >>

I would like to add SQL Server 2005 management console to my custom built MMC – but the only snap in I can find is SQL Server Configuration Manager. Is there a snap-in for SQL Server 2005 available or do I have to use SQL Server Management Studio? Cheers, Nina...more >>

I you create a table containing one or more blob's (image og text fields) where ist the acctual data storet - in the table og "outside" the table...more >>

We need to export tables with binary data and then import them into an "isolated" instance. How can we do? Thanks....more >>

We have a supplier that has an application written in Visual Foxpro 8 connecting to a SQL server database. Does this cause any known problems as upon testing we are finding massive problems with connection speeds and page/database locking. Si...more >>

Hi I need to create multiple type of file from the stored procedure based on the input. If the user passes the parameter as txt, I have to create Text file, if XML I have to create XML file. and csv type etc . How to do this. Thanks ...more >>