Is there a rough rule of thumb for the stripe size to use for SQL Server 2000? I am going to reorganise our disks. Assume 4 disk raid 10 for log and two 6 disk raid 10 sets for data. Environment fairly mixed. Probably more reads than writes but still plenty of updates etc. Controllers hav...more >>

Hi All, I have several questions regarding sql server 2005, as follows: 1-Can we run on the same Physical Server (box) an instance of Sql Server 2005 as well an instance or Sql server 2000. I have a number of Analysis Services 2000 MDX-based - Reporting Services SP2 reports that need migrating...more >>

I get the following error when i try to run a query on a linked server. Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL statement. SQLSTATE 42000 (Error 16805) Associated statement is not prepared SQLSTATE HY007 (Error 0). The step failed. any good ideas on how to...more >>

Technically what exactly does the backup do ?, and what can users/sysadmins do in a database when a backup is in progress ? Does it put table/page locks on data when it is backing up that specific table/page or does it back up the actual mdf/ndf file ?. How does this change with Full, dif...more >>

I have a basic question: We have a database db1 on SQLServer 2005 that gets updated v frequently. We would to like use a different database db2 (on a different SQL Server instance) that is a snapshot of db1. db2 is a read-only database that would be used for reporting purposes. On a daily ...more >>

We just upgraded our database server to 8 processors and 24 GB RAM. With the hyperthreading, SQL Server is recognizing 16 processors. It looks like some of the processors are running at less than 5%. I'm wondering if turning up the number of max threads will spread the load across the processo...more >>

Ok, here's the situation. Our MIS department recently relocated to a new office space about 5 miles away from our database servers. We used to be in the same building. We have about 10 different servers over there. For this example...let's say two of those are called DevData and ProdDat...more >>

Is there a way to change the logival filename of a database? I did a restore of one database to another and the logical name is the same in the new database. Thanks. ...more >>

I have problems when trying to restore a database using the command line isql program. I use a trusted connection and it says the database is in use when no one is connected to it. Is there a problem trying to do this? ...more >>

Hi, I have a temp table in a particular order,When i group by and add with rollup,the order is lost.y is it so?I need to retain the order.I cannot add a order by clause after roll up as the subtotals also get ordered and the groups are lost. Thanks, Sudha...more >>

In SQL2k, I have a linked server to an Ora9 db set up using the Oracle OLEDB driver. I get the error from a SQL Server stored procedure at the point it inserts data into an Oracle view which has an INSTEAD OF INSERT trigger, something like: .... INSERT INTO LINKED_SERVER_NAME..ORACLE_USER...more >>

Over the past months I have used SQLIOStress extensively to validate proposed hardware going to production. In most cases, the hardware has failed to meet performance expectations and the SQLIOStress results have not mattered. However, today we have a piece of hardware which seems to perform ...more >>

Hi I copied a dbase over to another machine and am trying set up a user. Anyhow in users for the database there is nothing and in roles there is just public and the default roles db_accessadmin ect.. Anyhow I need to add a user and a role, when I try to add the user it says that is is alre...more >>

Hi, We have two DataBases Residing on two different Servers. We would like to set up real time uodates between these two servers. We have an Inventory System on server A and a Tracking System on Server B. Now an Transaction in Server B should Update a Certain Table or Tables on Server A. and ...more >>

I am trying to move whole bunch of stored procedures from 1 db to another. Instead of going into each of them and change the table names to fully qualified name, is there a command that I can set the current database? I know USE does not work in sp. Any help will be highly appreciated!...more >>

Does the Processor Licence replace the Internet Connector Licence? I have a machine with 4 processors and I am looking for the cheapest way to licence 300 Internet users that will logon to sql via IIS. Many Thanks ...more >>

Hi I am trying to copy a complete database and did the following. backup database, saved file at location C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak on machine 1-source machine. I then copied this to C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\ on machine two-desti...more >>

Hi, Were using SQL Server 2000 on a Windows 2000 Server machine and one (and only one out of about 40) of our databases periodically (say twice a month) gets set to the "suspect" state. I've already looked through the log files and searched the internet/newsgroups but they don't help me muc...more >>

I just installed SQL Server 2000 on my Win 2000 machine. Both Client & Server. When I run my program that executes ADO, I receive message "Login failed for user 'Mylogin Name' ". I am using Windows Authentication. I do not have a password for my windows log in. So I am not passing a passwor...more >>

I've got a quirky situation here. Another developer created several diagrams of our database. I'm unable to see any tables when I open the diagrams and furthermore I cannot do anything to modify the diagram. We were connected to this particular database as "sa" so I don't expect there were ...more >>

Can SQL 2K Enterprise address more than 8 GB of memory on Win 2003 Enterprise Server? Can find any Microsoft info on this. Oscar Elleseff...more >>

Even though just querying one column, I can only see part of the results on some rows when these rows contain very long text. What I want is like what SQL server error log does. That is when you double click one message, a window will pop up showing full message. Thanks in advance. B...more >>

...more >>

Is Microsoft going to reissue SP4 with the AWE issue corrected or leave it in the "hotfix" state? ...more >>

We have several applications, each with its own database. We also have a "Reference" database that is used by all of the applications. My manager would like me to create some relationships between tables in Reference and one of the other databases. I can't do this in either the Database Diagra...more >>

I am running EM ver 8 with SP3 on Windows Sever 2003 only the client tools are installed. After adding the remote SQL server to EM and trying to expland the snap-in tree I got the following error "Snap-in failed to initialize. Name: Meta Data Serivces CLSID: {1dba4dd4-eb97-4rfd2-a...more >>

Hi, This is a simple SQL: select orders_id,keycode,validpayment,moneyreceived,prospect_id from orders where Keycode='ABCDEF123' and validpayment='valid' and moneyreceived>0 and prospect_id is NULL option (maxdop 1) If I run with option (maxdop 1), it returns correct lines. But if I run ...more >>

Hi NG, having a strang problem. I use a T-SQL-Cursor in a scalar UDF in a view. it should return a bit it is integrated in a view in one field. If i run the view in m Access-adp the field value is 0. if i execute the same view from query analyzer it returns 1 for thi field on the same d...more >>

I have recently upgraded my server from Win 2K to Win 2K3 this included upgrading office to 2K3 as well. The upgrade involved a rebuild of the server. Now when I try to setup the mail in Sql Server Agent the mail profile drop down is remaining greyed out. I use a domain account with an assoc...more >>

When I restart a machine, the following message appears, note that the SQL Server status icon in the server tray has a blank circle: The network path was not found. When I double-click on the SQL Server status icon in the system tray and select the SQL Server from the SQL Server Serv...more >>

Hi, I am trying to keep track all my sql servers in my co. There are so many servers and so many sql installation. Any tool i can use to scan the servers to find out which server is installed with sql server 2000? or any other way? TIA...more >>

If I use SQL 2000 Standard as a backend for IIS 6.0 with Anonymous User connections only, do I need to use the processor license? Thanks, Dan ...more >>

I wonder if anyone here knows what the problem is. On one server that I administer, when running a Profiler trace (either through the GUI or directly using the stored procs) the “Reads” column always returns 0 no matter what event is being monitored. The server runs SQL 2000 Enterpri...more >>

Other than the standard MS white papers, anyone have recommendations regarding securing the SQL 2000 SE DB?...more >>

Hi, We have a scheduled stored procedure running on SQL Server (enterprise server I believe). This stored proc is one of a set of procs run by one job, it takes about 11 minutes to do everything. Sometimes, during the execution of the Job, the server seems to not respond to connection reque...more >>

Hello Im used SQL server 2000 with Services pack 3 i have problem if external program "gathercoda" want adding records to sql db. error message: 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data, Start to read the metrics 2005/06/30 13:53:22 (5):(2648) server_where_ga...more >>

Can anyone help me with a query on SQL Server memory use? * Windows 2000 Std server with SP3. * SQL Server 2000 Enterprise with SP3a. * There is 4GB RAM in the server. * 4GB pagefile on each of the 3 Windows partitions, giving 12GB in total. The only thing I can find about using additio...more >>

Can I view my sql server 2000 license number (not only per seat or per processor) after installation of sql server. It is not shown in sql server licensing, enterprise manager, I think......more >>

Hi , i have set up odbc database source --> OD1 to connect to SERVER1 , from crystal report i have used OD1 to connect to SERVER1 --> DB1 however , i could not see the views but only the tables , stored procedures when i create the same view in SERVER1 --> DB2 and i used OD2 to connect ...more >>

hi, I wish to add a new column in published table. i know using sp_repladdcolumn we can add columns. but i wish to know using sp_repladdcolumn is better or drop the replication then add the column and recreate the replication is better. Can anyone suggest the right way ? Thanks in advan...more >>

Hi Everyone, Im sending mail using "xpsmtp.dll" & with the following Statment: exec master.dbo.xp_smtp_sendmail @FROM = N'From@Domain',@TO = N'To@Domain', @subject = N'subject',@message = N'Message',@type = N'text/html',@server = N'ServerName' This Stament Works Very Good , but from a while...more >>

Does anyone know who will be presenting SQL 2005 & BI sessions at TechEd 2005 Australia at the Gold Coast at the end of August? I've seen a rough agenda but no info about if any of the speakers are going to be worth listening to. -- *mike hodgson* / mallesons stephen jaques/ blog: http:...more >>

I have set up a warm-standby server with log shipping. How do I get the standby database out of "warm-standby" mode (and thus read-only) so that it can be used as the production database? ...more >>

when starting the wizard i get the following error: DTA Emport/Export Wizard Error: GetSourcesRowset Class not registered I have manually registered all the suggested dll's i have updated to the latest service pack, i have even uninstalled and reistalled. Anyone have any ne...more >>

Hi , I have set up SQL server 2000 on this machine COM_A and i am trying to monitor the performance of the server via performance monitor on my desktop( i have got MSDE2000 installed locally on my machine) however, when i enter the server name \\COM_A or it's ip addr to get the counters f...more >>

if you read below, you'll get many details. basically, i've installed a sharepoint server farm, and noticed when i add a web part then click on a drop down arrow on the web part, i get an error on the sql server... Application popup: mssdmn.exe - Application Error : The instruction at "0x00...more >>

I have recently installed MS-Outloook 2000 in my Win 2000 Professional system. I want Outlook to be the default mail client so that I can send mails from SQL Server 7 but when I start Outlook for the 1st time after installing it, I am facing problems. As soon as I start Outlook, the 1st step g...more >>

I can no longer connect to SQL Server 2000 using ADO after installing XP SP2. I receive authentication error. I have even turned off all firewalls. I also installed SQL Server Service Pack 4. I also added the SQL Server data source(ODBC). I am using Windows Authentication. When I test the OD...more >>

Hello! We are planning to install Windows 2003 SP1 soon. Our current OS/SQL Server configuration is as following: Windows 2003 Enterprise Edition SQL Server 2000 SP3 Enterprise Edition ; 16 GB of RAM (AWE and PAE enabled), EMC SAN I was wondering if there know issues with Window...more >>

I just recently migrating a legacy MSSQL 2000 database (containing Simplified Chinese GBK double-width characters) from varchar data_type to nvarchar using DTS, which in the process requires me to switch the Windows 2000 US English locale to Chinese PRC locale. All these are to allow me to ...more >>