This is SQL Server 2005... I have the following Trigger. I need it to update the field specified in the code (Total_Credits) by the amount of School_Credits inserted. Trigger works, but when I insert a new row it is updating EVERY row for every Client, it should only be updating one Client/...more >>

hi, I have a database and i want to enable auditing. I've read (not always about MS SQL) that a second database can be created easily that audits the original database using triggers. For instance, if there is a table named "Tree" and i need to delete a record in tree, a record would be ins...more >>

Hi All, This is my existing query and i have given below the output sample as well. btw I am using SQL Server 2005. Select field1, field2, Sum(A) as A, Sum(B) As B, '1 : ' + convert(varchar(20),convert(decimal(8,2),NULLIF(sum(B),0)) / convert(decimal(8,2),NULLIF(sum(A),0))) as C From (...more >>

My table contains 100 rows of data that was collected every 10 seconds. The datetime is recorded along with other information. I want to retrieve every 6th row from this table - that would be the row at each minute interval. How to accomplish this? pseudo code here select * from mytbl...more >>

Is there any system function in SQL Server 2005 that would return the maximum possible value of an int? (I know that it's 2147483647; I'm looking for a way to avoid pasting in that number.) (What I'm trying to do, by the way, is run a comparison between two positive integer values that might...more >>

I have four 2000 SP4 databases that I need to move tonight to a different drive on the same server. Can I leave the log shipping intact when I do this? If so, how? Or do I need to delete out the log shipping and then add it back in?...more >>

I am running SQL Server 2000 on Server 2003. I have a good backup regiment in place. I do a full backup at midnight every day, then every hour I do a transaction log backup. My network backup then picks up the backups and we store them in an archive. Also, I pick up the files in a nightly ...more >>

Once upon a time, I asked a DBA if he would create a linked server so I can easily access a remote server from SQL. He recommended against doing so asking me to find an alternate approach. His reasoning was something to the effect of a failure cascading into the local server. Something like...more >>

We have a situation where we have to expand a primary key field. We want to do full analysis and understand any foreign keys that might be affected by this as well. That would entail searching views as well. Does anyone have a script where I can search a column name against all the defin...more >>

Does SQL Server have a function (similar to sp_helpText) where I can view the CREATE TABLE script for a particular table? Thanks. ...more >>

Hello, I'm attempting to upgrade from MSDE 1.0 to MSDE 2000. However, before removing MSDE 1.0, a database apparently was not properly detached before attempting to attach (using sp_attach_db not attach w/ single file) this very database to MSDE 2000. The following error is rec'd: "C...more >>

Hi all, Is it possible to execute a stored proc with an OUTPUT param inside a select statemement? I have a need to do this becuase functions will not work here. You will notice the " EXEC uspf_MEDIAN_CLOSE_DAYS" towards the bottom of the example. Thanks. /*Example:*/ CREATE PROCEDUR...more >>

Hi, I have a database that I created two file groups. One is called Primary (d drive) and another is called Secondary (e drive). I think it can increase the performance with better I/O. I put 10 tables into the Secondary File Group. I am wondering what would happen when I restore a ...more >>

Hi all, Is there a more effient way to write this? IF @status = 'ALL' BEGIN SELECT A.COL1 A.COL2 ETC.... from @salesTemp end IF @status = 'Active' BEGIN SELECT A.COL1 A.COL2 ETC.... FROM @salesTemp WHERE A.status = 'Active' END IF @status...more >>

I cannot get the syntax to work for me. I have a string like this: 2828^Edmonton 9889^Danvers etc. I need to extract everything to the right of the carat (^). I've tried this: RIGHT(description,CHARINDEX('^',REVERSE(description))-1) and a variant using the substring but cannot get ...more >>

ok i manage to make a Vbscript that do in order : - Backup DeeBee (database name) from production server it make a full of it - Copy over network to development server - Restore the database there (Database already exist just replace) here's the vbs (name of servers and path where remove inte...more >>

I have a time value. How can I build a complete datetime value from it? Thanks ...more >>

Hi All, I would like to know what are the things one should consider for getting optimum performance in this scenario. 1. If we have tables which are going to be used only for "Report" generation purpose and it doesn't involve in any front end transactions. 2. Once in a week or so these...more >>

I have just inherited a DB in which data model needs to change. Lot's of SPs are already written, applications use them. What's the best way to go about this change? There is over a 100 SPs and Functions written. I'd hate to have to thru all of them open/look[edit]/compile ... room for er...more >>

I am trying to use the script table feature on Management Studio and the ALTER TABLE is disabled, is there anyone who has an idea how to enable it or why it is disabled? Thanks...more >>

Hello. I'm running the command sp_helpdb on a SQLServer 2005 database and it is taking 15 seconds to respond. What is making this SP take so long? Is there a way to make it perform better? The reason I'm running the command is to determine the names of all databases on the server. Is t...more >>

integrated Security= true or Integrated Security=SSPI Does the above mean the same thing in a connection string? -- Arne Garvander (I program VB.Net for fun and C# to get paid.)...more >>

Hi all, I have this query. Select VO.idOperation,G.Description AS Group,VO.Active, count(VO.idOperation) as tot from TB_ViaturOperation VO INNER JOIN TB_Groups AS G ON VO.Group = G.CODGroup Where VO.idOperation = 10000014 GROUP BY VO.idOperation,G.Description,VO.Active Result :...more >>

I imported 60 tables with 50k rows from DBASE III to MS SQL Server. In doing so we converted many data types from int, numeric and others to real, float, smallint, etc. We experienced some rounding issues. We also experienced problems with positional notation (ie, columns switched). I download...more >>

Hi there, I hope someone has any ideas how to handle the next situation. I've got a table and need to insert data in a field which will consist of the following: Department (let's say 900) than I need to add the current year. So far no problem. But I need to add a sequenatial number start...more >>

Hi There, Is there any difference between the two sql, in terms of result, performance .. SELECT MEMBER_BROKER.BR_CODE AS Expr1, * FROM MEMBER inner JOIN MEMBER_BROKER ON MEMBER.[PLAN] = MEMBER_BROKER.PLAN_ID where MEMBER_BROKER.BR_CODE = 'SBKR' SEL...more >>

Hi, Is there a way of retrieving the last 12 (or 15 or 20, or any number) of values from a column/s that match a certain criteria from a record easily (or built into SQL 2000 or SQL 2005)??? Something like select last 12 games where Played = true and week < 16 Is this simple, or am I g...more >>

Dear All I have a table with fields SensorCode (nvarchar), TDate (datetime), = and Value (float) If the value exceeds 300 the sensor considered violates the rules. I need sql statment to get the SensorCodes that have Values over 300 and = violation duration The result should be l...more >>

best / simplest way to detect user logon event (to perform some db action )in SqlS2000? thx ...more >>

Hi, I had a need to extract a customer’s phone number(s) from a child table and attach them as a string onto the end of an existing ( SQLServer7 ) SPROC’s output. i.e. Alter the sproc so that it also produced the phone numbers for each customer (parent) row. I got the impression fro...more >>

Hi all I have this problem when connecting to sql 2005 : A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Serv...more >>

create table #CursorRVPV (docid nvarchar(10) not null,docno char(20) not null,cocode nchar(10) not null,paidinvamt decimal(9,2) not null,paidbaseamt decimal(9,2) not null,reportid nvarchar(50) not null) INSERT INTO #CursorRVPV (docid,docno,cocode,paidinvamt,paidbaseamt,reportid) SELECT doc...more >>

Hello, is there an easy documentation how to debug a stored procedure with remote on SQL 2005? I tried everything and I get always the error message "DCOM error. Check firewall". I opened all ports but I still get this message. Please help me. Thanks in advance! Andreas ...more >>