I have one performance problem.... I am using follwing query to get some data back from sql server 2000... select @Rec_Cnt = count(Customer_Id) FROM products with (nolock) WHERE product1 like COALESCE(@product1, product1) and product2 like COALESCE(@product2, product2) and product3...more >>

Hi Is there a way to get notified that a table is modifyed without adding trigger to to a table. The software vendor warrant will not permit us to add trigger, but we have access to master tables and msdb. We need to query the table when anything changes in the table. There is no field in the t...more >>

Below are two update queries. One of the queries uses the *IN* keyword to figure out what to update and the other one does not: -------------------------------------------------- UPDATE SomeTable SET SomeColumn = 'abc' WHERE AnotherColumn = (SELECT XColumn FROM XTable) UPDATE SomeTable...more >>

I am wanting to script sp_add_notification in SS 2000 where you tie an operator to an alert. But I don't want to run it if the notification already exists. I have found where the alerts exist (msdb.dbo.sysalers), but I cannot find where the notifications exist. Can anybody tell me where...more >>

I'm not even sure my subject is accurate, but here goes. Is it possible to combine multiple update queries into 1 statement? As in: 'Change salary to $65000 where currently $60000 and change to $80000 where currently $75000' My SQL attempts, chron. desc.: UPDATE tblEmp SET fldSal = 6...more >>

Hi. We have a performance DB .. big one with enough records to test performace of an OLTP db. sometimes procedure executions fly and sometimes they just don't execute .. the difference I am talking about is between 120ms 1 or more minuts for exactly the same proc. the server has 12 GB of m...more >>

I can do this in VBA, but not sure how to do it in T-SQL I would like to pass a series of comma separated values in a variable into the "IN" clause of a SELECT statement for a stored procedure. e.g. @VarName 'string containing comma separated values i.e. "5,9,20" SELECT ProductName F...more >>

Hi, I want to monitor add/update row in a table, I assume use trigger... Then I want to launch a console perl script to do something. How can I make a trigger to launch a perl script? This is on SQL2005. A example will be great. Thanks...more >>

Hi, I want to set monday as teh first day of the week, how to make it global to all database? Thanks. SET DATEFIRST 1 ...more >>

I've got a 2000 SP4 server that has context switching over 25,000 day and night. Disk i/o is clearly very overburdened on this server as well. I'm not seeing memory problems though. Also, lightweight pooling is not turned on this server since the cpu is not that busy (way less than 80%). ...more >>

I've been wracking my brain on this one and don't have an elegant solution to this. I have a problem in which I'm inserting into a target table which has different PK than the source table. If there's a duplicate of the target PK, I want to only insert one of the source table rows. For exam...more >>

Is there any way to obtain the result and output parameters from a call to an SP inside of a trigger? What I'm seeing is that the SP gets called just fine, but is executing out of process so the trigger continues on its merry way and never gets a value set in the output variables from the ...more >>

I've got a new computer. I want to set up a local database server and use the name of my machine, "TOSHIBA-USER", as the name of the database server. However, I see in Enterprise Manager that the default name of the local database server is "(Local)(Windows NT)". How can I get the server rena...more >>

I've inserted a record into the sysservers table by executing the stored procedure, "sp_addlinkedserver". Then I saw that the record contained incorrect data in several fields. Therefore, I want to delete the record and start over. However, it doesn't allow me to delete the record. When I ran...more >>

I have a table with two columns: DistrictNumber and MapNumber. The are many maps per district and there are a few maps that are in multiple districts. I am trying to create a query that will give me a list, sorted numerically, by map number, that will show the districts that the map is in. Somet...more >>

Is there a way to select all fields from a table except one without specifing every field? Example: Select U.*, -U.Birthday (psuedo code) From Users U Where FirstName = 'Bill' Or could I select it into a Cursor or something and then slice off the fields I don't wan...more >>

Can someone please help me? I need to create a trigger to update between two database on the same sql server. Database 1 name is emdb. Table is BranchLoanNumber. Column: org_code, next_number Database 2 name is LoanNumbers. Table is LoanNumbers. Column: BranchID, CurrentLoanNumber. ...more >>

Hi, Is there any way I can encrypt a column that I need when it is saved into a database or during the process in Integration Services? Thanks Ed...more >>

SQL 2000 Enterprise SP4 1. Can I add -T1204 to my startup params? If yes, how much load does it put on a server? Is it resource-consuming? 2. After I add 1204 trace flag, how do I check the output? How do I check deadlocks and victims specifically? Thank you in advance, Leon...more >>

I have a huge table, EventLog, that contains 52,000,000 records. I run the following purging routine to purge the table: SET ROWCOUNT 10000 WHILE (1 = 1) BEGIN DELETE el FROM EventLog AS el WHERE (el.ReportInstanceID IS NULL AND el.EventTime < DateAdd (Week, -@days, GetDate()))-- 2 weeks...more >>

How to set clustered index key by using SQL command? ...more >>

I need to update millions of records and I am affraid that when I will do this my file size for transaction log will fill up my drive. Is there any way I can stop writing transaction log during my update. I tried following statement but when i updated about 10,000 records my log file grow...more >>

Cannot add rows to sysdepends for the current object because it depends on the missing object 'executesql'. The object will still be created. Hello all: I get the above error message when I try to run the following stored procedure in SQL2K5. It seems that "executesql " does not work in SQL...more >>

hey all, what can i do to make sure my database is in tip top shape. to use a common windows analogy, is there a defrag and cleanup diskspace for sql server? thanks, rodchar...more >>

Hi, S2K question. I'm very confused. I have a FOR XML EXPLICIT statement that I looked at in Profiler and the Server Trace in QA. They gave very different results. Profiler: Event Class TextData SQL:BatchCompleted select 1 as TAG,0 as parent,_Q1.C0_member_statuses_id ... order by 3,4...more >>

Hi there all I'm trying to produce a revenue report with detailed description - the description can be up to 5 lines held individually in a table called costdesc current code uses 5 left joins on costdesc question is whether there is a better way of doing this */-----------Current Cod...more >>

Hi, I have a stored Procedure, which has a several different queries to fetch some data. The data from different queries is added to a temp table, and at last all the rows from the temp table is sent to a c#.net 2.0 windows forms application. We are using SQL Server 2005. Now, I want to ...more >>

In SQL what is the equivalent of a VB Now() TIA Sam ...more >>

How do you handle db version control with your team (changes to procs, views, tables, UDFs, etc)? What does your process look like? ...more >>

Hi, We have a weird problem. We have our application running at about 100 clients, and at one customer suddenly some clients cannot connect anymore to the SQL server. This customer is using VPN and ISA and about 20 clients, and since 4 days ago we have these problems. Our client conne...more >>

To avoid having to pass this user specific ID via a parameter in the stored procedure, is it possible to create your own function like (like suser_sid()) or variable (like @@SPID) ? This value would be passed from a Web Service (asp.net 2.0) in the connection string or something and could be r...more >>