Hi We have a SQL Server 2000 server where the transaction log of TempDB is growing rapidly. It has been running along fine until the other day when I noticed the transaction Log was up to 58GB. There was an open transaction from one of the ASPState stored procedures (ASPState stores i...more >>

Hi, I have a bulk insert statement: BULK INSERT DatabaseTMP_CONVERT FROM 'CONVERT.CSV' WITH ( DATAFILETYPE = 'WIDECHAR' FIRSTROW = 1, FIELDTERMINATOR = 'COL_SEP', ROWTERMINATOR = 'ROW_SEP', CODEPAGE = 'RAW') Some fields that are inserted are encrypted using special characters beyond ...more >>

Dear experts, I am confused. I always thought that using NORECOVERY was essential when restoring multiple transactional log backups in a row and I always thought this was due to the fact that without NORECOVERY the transactional log backups wouldn't "fit" to each other, because of potential...more >>

I have the back up of master(master_db.bak), distribution(distribution_db.bak), model(model_db.bak, model_tlog.trn), pubs(pubs_db.bak), Northwind(Northwind_db.bak),msdb(msdb_db.bak) and compny(compny_db.bak,compny_db.trn). I have to restore all these databases. What will be the correct sequence ...more >>

Hi, I have SQL Server 2005 installed on my dev system. I am working on an app that i would like to distribute SQL Server with. SQL Server EXpress edition seem to be ideal for this. My questions are: -If i installed Express Edition, Can both SQL Server 2005 and Express Edition coincide peac...more >>

Hi, I have recently upgraded to the 64 bit SQL server 2005 from 32 bit SQL Server 2000. my daily Data warehouse update used to run 10 hrs on old environment, processing some millions of rows and 50 cubes. the old environment has 4GB RAM and 4 processor , Windows 2000 standard and sql server 20...more >>

hi all, I was wondering how I can enforce some configurations to sql server 2000, like auditing failure logins for example, but without using the enterprise manager. I need to implement a tool that will set some configurations automatically without human intervention, any idea how can i do ...more >>

I have a long list of records that I need to select and then delete...such as: 3139559 3139560 3139565 3139566 3139567 3139568 3139613 3139614 3139617 3139618 There are about 200 and they are not in consecutive order. Is...more >>

According to this article Microsoft recommends one tempdb file per processor core. I am in the process of purchasing a 24 core database server therefore according to this article I should create a TempDB with 24 files. This seems extreme. My question is how will SQL Server utilise the 24 f...more >>

I thought I read somewhere that the SQL2k5 trial copy could be licensed at or before the 180 days expired, but I can't find it. Can some one please confirm, If I install SQL2k5 Enterprise Trial copy. Can I license that copy, or do I need to uninstall and reinstall the licensed copy??? ...more >>

Hi, Anyone know why this won't work? declare @q numeric (38,0), @w numeric (38,0), @e numeric (38,0) set @q = 87654321098765432109876543210987654321 print @q set @w = 2631308369336935301672180121600000 print @w set @e = @q / @w print @e I get this output with error message: 8765432...more >>

I'm running SQL 2000 and need to export a copy of a database w/o the data. I need this for a consultant so I don't want the client information on the database. Any help? ...more >>

Hi Everyone, I currently have a Stored procedure that I'm having a problem with. The requirement for the SP: Return all clients that missed appointment dates between a date range, but do not sure them missing that date if the client was not admitted for a date within the date range. for ex...more >>

I had to uninstall SQL Server 2005 and when I tried to reinstall SQL Server 2005, I get the following error message. I have tried this several times and seem to hit this ro Thanks Jagannathan Santhanam ad block. The error message is least bit helpful. What am I missing? Appreciate any help...more >>

Why does SQL Server seem to return some results right away, then delay the rest when returning large result sets? Perhaps I'm mistaking client or driver behavior for SQL Server engine behavior, but I just cannot find an explanation for this. For example, I'm running a large query (returning a...more >>

BOL says this about the KILL command: Use KILL very carefully, especially when critical processes are running. You cannot kill your own process. Other processes not to kill are: AWAITING COMMAND CHECKPOINT SLEEP LAZY WRITER LOCK MONITOR SELECT SIGNAL HANDLER Those all make sense exce...more >>

SQL2K5 SP1 Howdy all. I'm trying to open up Dedicated Admins Connection in Management Studio and getting "DAC's are not supported. (Object Explorer)" Any idea's? TIA, ChrisR...more >>

IS there anyway to calculate a week number. What is the word to use, because week isnt valid. ...more >>

We currently own a per processor license for SQL. If I split off some databases in a separate instance (on the same server) does that require additional licensing or does the processor license cover all connections to that box regardless of which instance they connect to? Thanks, Ryan ...more >>

Hello, Is it generally easier to migrate data from SQL Server to other databases? I tried to find migration tools that would help move data from SQL Server to other databases, and there were many. However, trying to find tools that would migrate data from DB2, Oracle or any other database t...more >>

Hi everyone, I am new to this so any help will be much appreciated. I have a problem running triggers between two SQL servers. I am running Windows Server 2003 and SQL server 2000 SP4. I found Microsoft article which pointed me to enable MSDTC by checking the Allow Outbound and Allow Inboun...more >>

Hi Got some valuable questions answered here v.quickly so doing it again. Have SQL Server 2000 machine working as default instance. Would like to add SQLServer2005 as default instance and move DB over - test it then shut down 2000. So If 2005 install/migration don't work I have 2000 to fall...more >>

I have a weird problem in Sql Server 2005 that I need some help on. Below you'll find two queries. Both queries are exactly the same; they query the same database, query for the same info, same sql statement, same where clause... The first query (the one with all the parameters included in the...more >>

I have recently installed SQL Server 2005 on a system, without including Reporting Services. Both sp1 and the Cumulative hotfix package (build 2153) have been applied. Now, my client wants to install Reporting Services. Will I need to reapply sp1 after adding Reporting Services? I would ass...more >>

Hi Everyone, I need create the batch file to check sql server databases available during the weekend. I try to do run query use osql in batch file and the result write to a log file. And check if the log file include "fail" string then email or page someone, if not that means database is ...more >>

Is any one else encountering long lasting (several minutes) self blocking (connections blocking themselves) I have an smp system which is monitored closely for blocking and this is extremely prevalent. It is 99% of the time pageio_latches and is always i/o intensive operations such as bulk ins...more >>

Hi, I am restoring a DB from osql command line and I am getting following message at the end of the resotration. I couldn't understand first two lines. I searched BOL but couldn't find anything.. anyone know what is the _dat file? and why it was created? I can see that DB was restored succesf...more >>

can someone help me here? i got an error 3205 saying that i cant restore database cuz the limit is 64..... if there's anyone that knows how to fix it plz email me i beg u! (piporama@hotmail.com) From http://www.developmentnow.com/g/118_2004_3_0_21_0/.htm Posted via DevelopmentNow.com Groups http:/...more >>

I'm using sql server 2005 sp1 on win2003 server I want to reorganize all indices in my database. Online-docu says that dbcc indexdefrag should not be used anymore. Instead, 'alter index' should be used My syntax for one table is like this: alter index all on bew reorganize sql server...more >>

I have windows servers. One is win2k3 and other is windows xp. and sql server 2000 is set up on both. now when I make the xp server as primary and win2k3 secondary, i am able to set up log shipping with no issues at all. but when i try the other way , I can not. also when I try to switch the...more >>

Hi I am using Visual studio 2005 to write a web service. I am not able to connect to database. I get the usual Named pipes provider error:could not open a connection to the server. So I read up some material and found out that I have to start the sqlbrowser service(using surface area configurat...more >>

Hi there, I try to run the following update statement on MS SQL Server 2000 SP4 UPDATE Site SET Active = 0 WHERE RID IN (SELECT site.RID AS site_rid FROM Site INNER JOIN ManagerSite ms ON site.RID = ms.ArtistSiteID INNER JOIN Manager m ON ms...more >>

Hi We have a bunch of apps running on MSSQL server 2000. We will have to support both environments soon - before I download and get testing certain features I would like some advice. 1. Can 2005 and 2000 (Dev edition) co-exist on the same machine? This is just so I don't screw up my machi...more >>

Hello, I use sql server 2005 standard edition, sp1 installed on win2003server. I can't find the maintenance plan wizard in the object explorer in the management-studio. In documentation I found out, that the user connection must be done via windows authentication and you have to be a role-...more >>

Hi Team, Let me explain my doubts. There are two types of query optimizer 1. Syntax-based 2. Cost-based. Whatever I know, SQL Server internally maintain this optimization issue. Now I have two doubts. 1. Can user select the option before running any proc/sql statement? 2. If question no. 1 i...more >>

We have some client software developed by 3rd party that is used internally and requires use of our SQL server. We've had some problems with this software in the past and the developers solution was to add the dbclient login (used by the client software) to the dbo (owner) group of the SQL ...more >>

I have a table with a column that is nvarchar and I have inserted the following lines - the first is Bulgarian and the second is Russian DDS = ????? ???????? ???????? ??? = ????? ?? ??????????? ????????? They are both being displayed in the SQL 2005 Managament studio as '???????????????'....more >>

Dear All, I need a tool to see what transactions and in what order are being issued against the SQL Server Express 2005 DB. Because of the SQL Server tools don't come with SQL Server Express 2005, then i run SQL Server 2000's Profiler with SQL Server Express 2005. But It prompt error "F...more >>

Hi, Is there a way to delete the trace files on the sql server without using xp_cmdshell. Since, xp_cmdshell can be disabled in SQL Server 2005 I dont want to go with this option. This option should work on both 2000 as well as 2005 :) Any other suggestions ? TIA Thanks Pra...more >>

Hi, As a certified DBA in 2000 I've done hundreds of views in Enterprise manager. I've just started to get my teeth into 2005. As one of my first forays, I thought I'd whip up a typical view. No problems, but when I execute, the results pane say 'cell is read only'. I'm used to directly...more >>