Can you advise me on this one .Initially I thought it was due to remote query .... as described here so i changed the remote query time out settings as shown here http://support.microsoft.com/default.aspx?scid=314530 ... but thats not the actual problem as it hasnt helped . Can you suggest wha...more >>

Can a table have 2 triggers associated with it? Thanks. -- --------------------- zwieback89 Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200701/1 ...more >>

Case: I have a table -lets call it "tbl_users_friends" - with the following structure: ID FriendID __ ________ 15 16 This sample data means that 16 is friend of 15 and visa versa. I am trying to get the friends of a person using his ID. The table contain the friends uses both co...more >>

Hi, I want to dynamically create a filegroup. i.e., through code i need to find out what are all the filegroup names already used and assign a new name to "Alter database add filegroup @newFileGroupName". Is it possible? If not, whats the work around. Regards Pradeep...more >>

Hello there I have sql server 2000 SP4 I've started placing small tables in the memory by DBCC PINTABLE Can i get on query anlyser the amout of the memory that sql server is using right now? and can i know how mutch of this memory is being using by RAM or HD? ...more >>

Hello I have this select which works fine but i can't make it work with self join instead of the subquery , i don't know what im doing wrong , the select returns sum of qty at each store date storeid > int tdate > datetime = transaction date dtid > int = data track id , a separator insid...more >>

A sample table has two rows CREATE TABLE QtyAdj ( ModDate DATETIME, Qty INT ) If sorted by ModDate, the result set would represent the modification events in the order they have occured. I can number the result set, loop through it, get last ModDate from each pair and display before a...more >>

Hi, I want to back up the database but I also want to know when the backup is finished, is there any way of knowing that? Thank you, Samuel ...more >>

I'm running a stored procedure that has been working for months. It is = suddenly however throwing errors like: "Invalid column name 'ADM'" and "Invalid column name 'PAYMENT'" Here's my syntax for the code: EXEC ('INSERT INTO ' + @NewPaidEnding + ' (SubRef) SELECT DISTINCT Transactions.SubR...more >>

Lets assume we have a table with x number of columns and y number of rows, it's just not that important. I have a primary key, which has a clustered index, column with a datatype of Char(14). This value is populated using LEFT(REPLACE(NEWID(),'-',''),14). I've seen a statement in another gr...more >>

I need to select only the year-month-day part of datetime values that have also hour-minute and second values stored in the field in the table. I can't seem to put my finger on the function to do that. The values are stored as datetime. Any help appreciated, Bob ...more >>

I'm trying to create a CLRSQL stored procedure in SQL Server 2005 which references System.Web.dll. Has anyone had any success in calling CREATE ASSEMBLY on System.Web.dll? Here's my situation: I'm using Charles Cook's excellent library for calling xml-rpc web services (http://www.xml-rpc.net/)...more >>

Hi all, I have a table that stores a tree like strucure based on the adjacency model. When a node is update with a particular value, I want a trigger that will update its parent. This is easy to do. But what I cant get working is to roll that update up the tree to its final root. So when ...more >>

I have a crosstab query that I have set up to return a variable number of divisions (channels) in any given month. Since my intention is to set up a job to throw the results of this crosstab query into an Excel sheet & mail it, I need to have matching headers for the columns. However, they...more >>

Hi, I have a ASCII text file that I need to import programmatically into a table on a regular basis. The format of each file is as follows: yyyy-mm-ddThh:mm:ss|<text>|<int><lf/cr> Example: 2007-01-08T15:08:15|UNIT0101|141 The file contains close to 6K lines on average. The target tab...more >>

Hello there I have access 2000 SP4 Is there a way not to send parameter which will be a default ...more >>

Thought the following Microsoft MSDN article may be of use to us all: http://msdn2.microsoft.com/en-us/library/ms189798.aspx ...more >>

I have the following query: select l.imei, l.dtesubmit, l.shipdte, l.bounce from dbo.unitinfo as l inner join (select imei, dtesubmit, bounce, shipdte from dbo.unitinfo where dockdate Is not null and bounce = 'no' and dtesubmit betwe...more >>

Greatings all, How efficient is the use of NOT IN in the where clause filter. As a mechanism of filtering out values from a record set what is the next best option. -- obelix "Whether you think you can or you think you cant you are right" .... Anon Message posted via SQLMonster.com ...more >>

Hello, our sql server admins installed the SP4 to our sql 2000 database. Now when we are using access ado to call a stored proc like so it FAILS...(also this code was in place and working prior to the patch): EXEC someproc_name @mydate = '12/4/2007', myint=2 however if I take out the...more >>

Using SQL 2005. Applies to SP0 and SP1. I have a stored procedure, that returns a resultset based on the join of four tables. Our support department reported that for one particular instance of the database, the procedure was taking 40 seconds to execute within the Management Studio, and w...more >>

Hi, I am trying to write a SQL Server 2005 query that will return me a summary report of an applications lifecycle. The source table is comprised of (this is gross simplification of actual table!): Application ID | Date Deployed ---------------+------------------- 1001 | 1/1/2006 ...more >>

Hi!! I need to know which of this aprooch is best. SET @var =3D N or SELECT @var =3D N I some places i heard that the SET aprooch is best, because, the set instruction is more efficient, but in other places says that is the same. What is your opinion? Thanks a lot. Andr=E9s M...more >>

Hi, i am about to set the memory options on sql server 2005 cluster running on 16 Gb RAM nodes (windows 2003). The Cluster has 3 instances of sql server installed and I want to set max server memory to about 4,7 Gb for each instance, leaving the OS with approx 2 GB. The question is how to ...more >>

Sending out an S.O.S to the world ...Help problem: The format of datetime column differs on select and on update/insert queries. installed system. SQL server express 2005 on windows 2003 web server edition regional settings greek (also tried UK english) query(1): SELECT START_DAT...more >>

I have some requirement for an automated payment system. The system has four machines setup as follows: 1- Two machines have a clustered database. 2- Two machines have a .net business logic component that will handle payment transactions with certain external component (Payment Gateway) My ...more >>

I've got a csv file to import with BULK INSERT. It contains a date column, some values and some NULLs. In the csv, the NULLs are held as the string 'NULL' as follows: 1987-11-19 00:00:00.000 1962-08-27 00:00:00.000 NULL 1967-05-13 00:00:00.000 If I try and load this file into a date co...more >>

We have developed an application that use .NET 2.0 and in the same server are installed the SQL server. The problem is that when i use "LOCALHOST" on the application everething works fine, but when i chage it to the IP number the application works VERY SLOOOW. Why? It must work both way... Ple...more >>

Hi everyone, Can anyone tell me how I can create a mirror database? please give me the information step by step. Thanks, Nassa ...more >>