I am supplying the parameters for sp_trace_setevent dynamically. The string that I am storing the parameters in looks like the following: SET @sp = cast(@TraceID as varchar(10)) + ', ' + cast(@ev as varchar(10)) + ', ' + cast(@col as varchar(10)) + ', ' + cast(@on as varchar(10)) I ran a p...more >>

i have a stored procedure like this ... create proc mystoredproc as begin create table #temp1 (field1 numberic) insert into #temp1 select * from sometable if ( select count(*) from temp1 ) <= 20000 ) begin select 1 end else begin ...more >>

Hi, When I order by a field the sorting is wrong for Norwegian. The Å comes before the A for example. I have tried different collation settings of the database, but cannot find the correct one. Anyone ? Using SQL 2005/SQL 2000 David ...more >>

I've been testing a new 2005 server. After the install, I backed up the system databases. I've done a lot of junk testing stuff since then, and now I'm wondering if I should do a restore of the system databases before I put the machine into production. If so, which ones? ...more >>

Hello, I deleted a database and am now getting the error: cannot open user default database. login failed The database is on my machine using Windows Authentication. How do I change the default database, and what tools would I use to change it with? -- Thanks in advance, sck10 ...more >>

Hello I am looking for a command that would kill all sessions (active or not) on a database or server. Is there such command? thanks for your help Wilfrid ...more >>

I am having problems when I try to grow my database. It seems to be taken a long time (1 hour and still going) and is also making the system unresponsive. The CPU is at 0 but the computer is so slow nothing can be done. This is a dual processor system with 2ghz processors. I am using the ...more >>

This came up in a recent conversation. What happens if I reboot the computer while a reindexing process in underway? a. Acceptable b. Not a best practice c. Suicide Any feedback is greatly appreciated :-) Saga ...more >>

I'm trying to assist a customer - remotely yet - with a new install of SQL 2005. They built a new server - put Windows Server 2003 on it. They installed MS SQL 2005 - first time they did it they made in a "named" instance - I had them de-install and re-install as a standard instance... ...more >>

Hello all. I have a SP (MS SQL 2000) that will delete select records from 3 unique tables. The SP works fine but is there a way to return some kind of value from the SP to know whether it worked or not? I'm using ASP.NET to call the SP but I need to know whether or not the SP was successf...more >>

Hi all, I have scheduled a job to run everyday at 3am. But when I right click on the job and select "View Job History...", I get this message - "There is no history information for this job.". The Sql Server Agent service is running and the job is enabled. So I don't understand what else c...more >>

I created a job on SQL 2005 - logged in using Windows domain user. And I get the following error message. Any clue to fix it? Message The job failed. Unable to determine if the owner (Domain1\nick) of job test_job_1 has server access (reason: Could not obtain information about Windows NT ...more >>

We have a Windows 2003 - 64 bit server where we want to install SQL Server 2000 EE 64 bit. I am getting the: "The image file D:\setup.exe is valid, but is for a machine type other than the current machine." error because the processors is AMD Opteron(TM) Processor 852 ........ I heard th...more >>

trying to create an mp and i can't get past this failure (regardless of which steps and databases i select): "saving maintenance plan failed, one or more arguments are invalid." the plans all show up under jobs and i'm not able to delete them. nothing shows up in the logs and i couldn't fi...more >>

The first time I posted it landed under someone else's thread & I wasn't = sure anyone would see it to help me out. I have a database that's being restored on a monthly basis, but I think = this process is overkill. The users are using a few tables or whatever to run reports using = Crystal...more >>

I create a filegroup, added a file to it and created a table with 1 varchar(256) column to it. I then added several rows of data. I wanted to test removing the filegroup and can't. First I ran: DBCC SHRINKFILE('NewFile', EMPTYFILE) and received: DbId = 34, FileId = 8, CurrentSize = 13056, Min...more >>

I have a database that's being restored on a monthly basis, but I think = this process is overkill. The users are using a few tables or whatever to run reports using = Crystal Reports, and accessing tables via MS Access. What do I profile for to 'see' everything that is being used in this = ...more >>

Hello, This is my XML data: <RESPONSE> <FIELDS> <FIELD KEY="COLUMN1">a</FIELD> <FIELD KEY="COLUMN2">B</FIELD> <FIELD KEY="COLUMN3">C</FIELD> <FIELD KEY="COLUMN4">d</FIELD> </FIELDS> ...more >>

I have a database that it approx 20gb. The data file is 13gb, the index file is about 7gb and the trans file stays really low(not even worth mentioning). When I do a shrink database or shrink file from either the GUI or analyzer window the shrink sits and cranks for hours with no result. Is ...more >>

After four long hours of googling on the subject and finding almost nothing, I'm forced to post this one. I'm doing a small project that reads several IIS and stores in a database the domains hosted there. This application runs quite fine. But I'd like to add some transaction control on it,...more >>

I am working on virtual server 2005 and have installed SQL Server 2005 Enterprise edition and Visual studio 2005 on windows server 2003 SP1. During Visual Studio installation, there was an option to install SQL Express. I didnt select sql express since there was an instance of SQL Server 2005 En...more >>

I am running SQL Server 2005 Express. I am trying to change the server property to the mixed mode authentication (SQL Server and Windows authentication mode) in SQL Server Management Studio. I loged in to the server which is local in Managament Studio using windows authentication. When I rig...more >>

We have just bought new servers for separating out exchange server and SQL server. We have Windows 2003 Server Standard Edition with 4GB RAM, SQL Server 2000 Standard as I understand it uses only 2GB of memory. I was told about a switch you could add to make it recognise more than 2GB in the ...more >>

If you have a 'full' recovery option for a user database. And the transaction log is set to autogrow...Does the file ever shrink by itself? I know the used portion goes down. But does the file size on the hard drive go down once it has grown on its own after log backups or sql restart? If w...more >>

Hi, we are looking into using Service Broker on a new project and have a question concerning the isolation of the service brokers applications. What would happen if one of the assemblies initiated by service broker (message arrived, so event-triggered activation) does something bad, for exa...more >>

Hi Ok here is a challenge to the group, I have a stored procedure that I use to create a report, its based on the following scenario A user calls in a raises a log in tblLog They are then sold stuff in tblSales We want to track what they are sold based on what they had so tblLog has flags sh...more >>

I receive this error only when backing up database "a". I have changed times of day and ran it manually and it occurrs only on this one. THere are 15 other databases on the server. We are running SQL 2000 sp4 on Windows 2003 Dell server raid 5, 2 GB of ram. No external disks. Any ideas? ...more >>

The way our politicians rushed to talk about illegal immigration this week, maybe they thought it came with a free lunch. They won't do anything about it, but it will get them some money. The Expert provides the details at: http://www.ExpertHumor.com/ *** Free account sponsore...more >>

Hi, All I have one default SQL Server 2005 "LIANG" and "LIANG\SQLEXPRESS". After I set up a linked server "LING" in "LIANG\SQLEXPRESS"., I try to run a query select * from LIANG.Northwind.dbo.Customers it gives me the following error: OLE DB provider "SQLNCLI" for linked server "LIA...more >>

our database system is runninig in log shipping mode. currently, primary database log file get much more bigger, but I dare not shrink log file in primary database , because do this will affect log shipping. any way reslove this? regards! ...more >>

I am using a 3rd party tool to bind to the perf monitors, with no success. In the event log: Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a 64-bit environment. Contact the file vendor to obtain a 64-bit version. Alternatively, you can open the 32-bit extensible count...more >>

Hi, Will space used by an table be unallocated if the table is truncated or will it only be marked as unused? TIA, ...more >>

Dear Experts, I heard that MSDE Release A removes the limitation of 7 concurrent queries that affect MSDE when too many users connecting to the system at the same time. Is this correct? Thank you very much...more >>

Hello! All. I need to estimate a DataBase space growth, but I 've never had something like that. Anybody could help me wiht this? Which informations a need to make this estimative? Are there any rules or template to estimate it? Thanks a lot Juliano Horta -- Message posted via SQ...more >>

When I use Sql, I can choose between named pipe and TCP/IP. I never heard about named pipe before, what is it? ...more >>

I have a sql server (Sql 2k Sp3) that has a very high CPU utilization count for the Lock Monitor. The database is used by a Java application that controls all update transactions. There are some instances where the app is saving data, querying data and then saving more data inside a distribute...more >>

Hi I've been using SQL Server 2000 for quite some time. Every new database I used to add, it would set the Database Recovery option to "Simple". Now after shifting to SQL Server 2005, this option is being set to "Full" by default for every new database. Can someone tell me where is this proper...more >>

Hello, I am new to SQL Server. I am writing a stored procedure with a sql like this : SELECT sum(dbo.fn_Currency(Currency_Code, 'USD', ColumnA)) , sum(dbo.fn_Currency(Currency_Code, 'USD', ColumnB)) , sum(dbo.fn_Currency(Currency_Code, 'USD', ColumnC)) , sum(dbo.fn_Currency(Cu...more >>

Hi, Check this query: SELECT @ItemCodeID ,@ItemCategory ,LPD.LabelBatchContainerID ,LPD.ContainerNumber ,@TableID ,(SELECT ISNULL(SUM(QtyChange), 0) FROM tbl_Inventory AS I WHERE I.ItemCodeID = @ItemCodeID AND I.ItemCategory = @ItemCategory) + (SELECT ISNULL(SUM(...more >>

Can anyone tell the general cause for sql server to generate an stack dump. And how important it is to analyze the dumps generated. Thanx...more >>

Hi All We are maintaining around 20 SQL servers in our organization. I want to know is there is any operational guide documents are available to maintain large number of SQL servers? Please send me the link of articles or documents. Thanks to all. Regards Praveen ...more >>

I have created a database in AS/400 DB2 with 250 tables and 23GB data in the database, now I want to shift from DB2 to SQL Server. How can import the database from AS/400 DB2 to SQL Server, without corrupting any of the constraints and data. Can anyone explain in detail. Data is very cri...more >>

We have a SQL 2000 Database in both a production and test environment. There are numerous processes and procedures in this database that must communicate cross-server with another SQL 2000 database. This other server also has a corresponding production / test environment. There are many refer...more >>

I need to set up a table to define times when tasks will run. It needs to allow for multiple times per day and if the task should run on the weekends. Once the task has run once for the specified service window for that time of day I need to prevent the task from running again. I do not have...more >>

When I login to the windows server as administrator, the query runs. When I login as anyone else (incl a user with as many admin rights as I can give him), I get the following error: Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "VFPOLEDB" for linked server "A" reported an error. ...more >>

We are currently run into an issue with upgrading our production db in the lab to SQL2005 compatibility mode 9. The upgrade process: 1. Detached and copied production db to our test SQL2005 server 2. Attached PROD_COPY_DB to sql2005 3. Ran the following script USE PROD_COPY_DB ...more >>

I have a field in my table that is set as DATETIME The data that gets imported to it is a text file and has teh data with teh time. for example, 1/1/2006 4:57:12 PM I want to get rid of teh time part How can I make it so the data that I already have in the table will drop teh time?? ...more >>

MS SQL 2000 Server instance 2 on Window 2003 with another instance used for backup installed. I stopped the server and tried to start it. It says it cannot start the service because the system cannot find the file specified. It does not tell me the name of the file it cannot find. I have looke...more >>

Hi,, How do i delete all triggers in one database? Quick way. Thanks ...more >>

I am running SQL 2k on WinS2003 servers. We are using Log Shipping, leaving our secondary in a Read-Only state to be used for reporting. I have a need to get a new index on the secondary server (to decrease the 14 hour run time for a report). Our primary is in Full Recovery mode as well. I...more >>