Hi Can somebody tell me, is there a load - balancing or grid techn. in the next version of SQL Server Yukon We are currently using the SQL 2000, but it has only the failover clustering(if one server hangs, then the another takes over), but we need load-balancing(we need to balance the server wor...more >>

RESTORE DATABASE upperbridge FROM DISK = C:\.............. WITH REPLACE gets the error Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not be obtained because the database is in use. This is on my t...more >>

Hello All, I have a simple table with 2 columns. datetime int 27.05.04 1 29.05.04 2 31.05.04 5 and i need to get a view that looks like this below : 27.05.04 1 1 29.05.04 2 3 31.05.04 5 8 The third column shows a sum of numbers that were display before ...more >>

How can I move a database from one SQL server name to another server with a different name?...more >>

Hi All I would like to know if it is possible to figure out what user change the field names of one of my table on my SQL Server It seems that somebody change and after all nobody it guilty Do you know Thanks in advanc Roberto...more >>

Hello I am doing some revising for the SQL admin exam, and one of the question explanations had this. "The sp_adduser procedure cannot run within a user-defined transaction;" What does it mean? I think it means that the sp_adduser procedure can only be used within the master database, is...more >>

Hello, I have analysis services running on a server in our internet datacentre (servers are colocated at an ISP). It is working fine with no problems whatsoever. I can also manage it fine when I terminal onto the box. However, the problems start when I try to mange the server from my local...more >>

Can anyone assist...What does this error mean; and possible solutions SQL Server error #21268 - Severity 1 Cannot change queue type while there are subscriptions to the publication Thanks..........Joseph Simmons...more >>

Thanxs for the site but what i really wanted to know (and=20 found that it=B4s not documented) if whats the best way to=20 analyse DBCC Showcontig results: for example: I usualy look at the extent switches and extents numbers.=20 If extent switches > extents than the index needs a=20 defrag. ...more >>

I had to re-format my main hard drive after a crash. How can I restore the MSSQL database which I had saved in a Backup on my second hatd drive? I had re-named my computer the Operating System of which is Windows 2000 Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5 GB of RAM ava...more >>

I had to re-format my hard drive because of a crash. How could I retrieve the database which I had backed-up on another hard drive before the crash?...more >>

I'm connecting to Oracle 8i databases from SQL Server through Linked Server. Now I need to connect to Oracle9i databases from the same SQL Server. What currently I'm doing is: (already installed Oracle 9i client tools on the Server machine) changing the registry setting of "[HKEY_LOCAL_MACHINE\SOFTW...more >>

Does anyone know a good site or can anyone explain me how to analyse a dbcc showcontig results. Ex: whats the best thing to look at to see if you got fragmentation or not? Thanxs...more >>

HI i need to downgrade one of my databases to SQL 7..but ti doesnt allow me to not a backup restore or a script import works please can any one help.or is there some tool that does this fot you ...more >>

Hello, I need to check the duration of execution of some Stored Procedures. I dont know when these stored procedures will run, so i execute the Profiler to catch these Stored Procedures but i dont know if im going to get the desired result. Am I doing it right or may i do anything else? ...more >>

Hello, What would be the way to go after rebuilding master database: (1) restore it from the backup, restore msdb, and then user databases or (2) restore user databases, restore master, and then msdb. I mean, is it bad, when the master is restored w/o user databases being accessible? ...more >>

I index my database nightly since I have many changes to cluster indexes and non-cluster indexes daily. I ran a script the would tells me every table the number of rows, index space, data space, and unused space. Next I applied the DBCC INDEXDEFRAG to every table and each index which r...more >>

How can I obtain a Beta copy of Yukon? Thanks, Mark...more >>

I like to obtain information on several of the largest SQL Server 2000 Enterprise Edition databases? With the hardware specification and disk space (SAN, LUN, etc.) they are using. Also would be helpful the average number of transactions per minute the server is handling. If the ...more >>

My company has 5 SQL Servers, their configurations are : SQL Server 7.0 + Service Pack 3. But I could not do DBCC DBREINDEX on one of them and got the following error : DBCC DBREINDEX('dbo.SA_TRN_DTL', ' ', 0) The error was : Server: Msg 1105, Level 17, State 2, Line 1 Could not alloc...more >>

Given a column of dates, I would like to create a computed column showing how many days from the current date until that date (ignoring the year) next occurs. E.G. given 3 rows: DateID StartDate 1 2 January 1954 2 1 March 1978 3 30 December 2001 if today...more >>

We have a query that appears to be built to fail, but never meets the criteria to cause a failure. Basically select isnull(CurrentValue,'blank') Value from Table1 Since this isnull condition never occurred, everything worked fine in sql 7.0, the query at least execute with no syntax err...more >>

Hi, I am trying to do a bulk insert using a text file that is comma delimited. In the text file there are fields which are surrounded by quotes and contain commas; these commans should not be considered delimiters. Is there a way to tell the BULK INSERT statement not to treat these as delimite...more >>

Hi all, We have 3 sql servers tha are on the public internet, behind a firewall, and there is open only 1433 inbound and outbound as from Friday morning all 3 have the following problem, i cant open regedit and ipsec the system says dont have access. Iam and admin, also when i do netstat -n there is...more >>

Hi, Our users complained that the performance is unacceptable on some workstations, but some others say acceptable. We have arranged a testing for those workstations to run the same application at the same time. It is a client-server application written in PowerBuilder, using DB-Library to co...more >>

Dear All i cannot view any databases under the enterprise manager (it just say no item) while i can see the databases from the query analyser, i restarted the server and the same, the users are working fine and i can acess the databases from the application to any idea?...more >>

Hello, i need two tables like: Country(IDcountry,country_name)....City(IDcity, IDcountry, city_name), so i need to put all the countrys in the world and there respective citys....it´s a lot of records....is there a simple way to do this?Thanks!...more >>

When I try to install SQL Server 2000 on Windows 2003, I get the message that SQL Server 2000 SP2 and below are not supported. How do I install SQL Server 2000 on Windows 2003? ...more >>

I added an alias in Client Network Utility. (cliconfg.exe). I am in Administrators and hence was able to add the ALias. Alias Name : MyDatabase Protocols Enabled : Named Pipes, TCP/IP. Protocol for Alias : tried both Tcp/ip and Named Pipes Server : MyServer From query analyser if I try to ...more >>

hi, i have sql server sp3 running upon win 2000 adv server sp 4. the server is configured for merge replication with another machine with same configuration (sql server sp3 running upon win 2000 adv server sp 4). few days back i recieved this error when i was trying to connect SQL server remo...more >>

Problem: For safety reasons, I want an exact copy of all SQL databases on another hard drive. I'm trying to guard against a hard drive crash. Currently, I detach, file copy to another drive, then reattach each individual database. Since SQL Server is running on different hard drive from the da...more >>

My SQL Server 7.0 (with Service Pack 3) server has 3 drives : C, D, E. By default, the TempDB locates at C drive and I increased its size by adding 2 more files (1 for TempDB database file and 1 for Temp log) at D drive. However, I don't know why the TempDB always cannot recognize these 2 D-dri...more >>

Hello, im having troubles copying data from our hosted remote server, to our local server, we want to do this inorder to have a copy of our database locally, incase the server ever goes down.. etc. I have tried, grabbing the *.BAK file and it keeps giving me an error saying the connection is l...more >>

Hi All, When I've tried to edit my procedure in QA , I have a message like stored procedure was not scripted it is possible that information in system table 'syscomments' about the object was corrupted or missing is there any way to fix this ? Thanhks in advance ...more >>

Hi, For some reason, my SQL server is sometimes processing 99% cpu. But on the SQL server is no activity from users or jobs running. Can someone help me with an TSQL script to retrieve CPU usage at that moment. Regards, Rene ...more >>

Hello everyone, I think I have done this before, but it has been a long time, is there some way to truncate a database? I have trimmed all the data in it, but the size is still the same. Thanks for any help!! ...more >>

I am beginning to see blocked and blocking processes in Lock / Process ID tab under the current activity window. SQL Server resolves this after a while but is this normal ?? If not how can I resolve the blocking problems ?? Database is a highly transactional ~500 user database. Thanks fo...more >>

I create a index on a "date" field on a table. When I use query: Select ... From table Where date='5/21/2004', in the estimated executation plan, I can see it use the bookmark lookup which is the "date" index. However, if I change the query to: .....where date between '1/1/2004' and ...more >>

I have a corrupt SQL 2K database that I am trying to repair. I do not have a backup. The following statements all result in the same error: DBCC CHECKTABLE(TableName) DBCC CHECKTABLE(TableName, repair_allow_data_loss) DBCC DBREINDEX(TableName) Server: Msg 601, Level 12, State 3, Line 1 C...more >>

Let me start be saying I have a 8 proc sql machine set to use all processors for parallelism, with a cost threshold for parallelism set for 5 seconds. In an effort to optimized my database performance, I added Performance: Execution Plan to my profiler and kicked off a query that I new wa...more >>

I have the following in an update script. ALTER TABLE [dbo].[SoftwareRentalMaster] ADD CONSTRAINT [FK_SoftwareRentalMaster_ProductLookup] FOREIGN KEY ( [ProductCode] ) REFERENCES [dbo].[ProductLookup] ( [ProductCode] ) GO I would like to check if the FOREIGN KEY exists and delet...more >>

We are running SQL 2000, DB2. We recently purchased H.I.S. and are trying to add a linked server to DB2. The DSN we set up using the OLE DB Driver for DB2 tests successful. However, when we try to use this DSN when creating a linked server with EM or sp_addlinkedserver it fails eevery time givin...more >>

I have a database in SQL Server 2000 A. It has 2 data device and 2 log device. I have backup the database into a file, and try to restore it into another SQL Server 2000. The new database has only 1 data device and 1 log. However, when I try to restore it, in Option page, it has 2 data device...more >>

Hi We have an app which is being listed with lots of sleeping processes in SQL Server. Some of those are 2, even 3 days old, and we are not getting to determine which is causing that (our lab environment doesn't show up this behaviour). We've checked, and Windows, SPs, SQL, SPs and MDAC versions, ...more >>

Hi All I dont know how to modify the table schema (e.g. Alter Column) without removing the applied replication. Would anyone please tell me the solution? Thanks alot, Douglas ...more >>

Is it possible to get all indexes for all tables and views in one script? ...more >>

**** Post for FREE via your newsreader at post.usenet.com **** We're going to set up a Win2003 cluster on two dual cpu with 8 GB of ram systems. I'd like to install multiple instances of SQL server so i can switch instances on the computers. When i use 3 instances of sql server can they each...more >>

Good friday, SQL 7.0 In some case, when i use Sp_who to see from where an process is coming, i don't see anything under hostname. Does anyone knows what is missing on the host computer Thanks !!! ps : please, don't talk to me about sledgehammer... :o) donald...more >>

Help gurus, I'm in the very beginning of learning to use sql server 2000 and i have manged to have a test data-driven web site online base on sql server 2000. But , i did quite a very stupid mistake recently. My site literaly has all it contents in the database . I mistakenly imported th...more >>

If an application uses a lot of views and the performance is slow, should we create indexes on views? What kind of indexes to create? Thanks....more >>