Hi, I ran below to setup Event Notification but it did not seem to work (SELECT * FROM EventLog returns 0 row). Can you help? -- enable Service Broker USE AdventureWorks ALTER DATABASE AdventureWorks SET ENABLE_BROKER; -- drop and create the eventLog table IF exists (select * from dbo.sy...more >>

I need your advice since I have searched the web and looked at the = Newsgroups but don't really know the terminology that I am looking for. I have migrated my data to SQL Express 2005 and am now (trying) to = convert the FE Access 2003 Jet SQL to use the SQL server. Through trial = and error ...more >>

Dear All, If I insert only 1 ID in parameter @ComIdList the SP run OK. But it is mostly a list of values like 1, 2, 5, 7, 8 If the list is more than 1 figure it return an error: Syntax error converting the varchar 1, 2, 5, 7, 8 ' to a column of datatype int. HOW TO SOLVE THIS PROBLEM !...more >>

hi, i have query like select empid,name,deptid from emp join dept on emp.empid = dept.empid union select empid,name,deptid from emp join dept on emp.empid = dept.secempid just one of my join clause varies, as union takes more time, is there any other way to achieve this. thank yo...more >>

i am reading the books on line to understand why a former co worker used a lock hint an update statement. if i specify a locking hint on an update query, (e.g. update sometable with (rowlock) set......) the lock manager will not necessarily grant the request if it feels that a higher lock...more >>

i have been reading the topics on guid being bad for primary keys because of performance and i had a question. i have a database server that has multiple databases with the same tables. i have a program that reads audit data from a table in each of these databases and inserts them into a ce...more >>

i have this table that i'm designing create table person (id int identity(1,1) primary key, name varchar(50) not null, skill_id int not null) create table skill (skill_id int identity(1,1) primary key, skill_name varchar(30)) i'd like to make skill_id of the person table a foreign ...more >>

I want to store a "document MRU list" in a database (table "DocMRU"). The list in question really has nothing to do with the data model otherwise implemented in the database. Each list entry would be 3 integers - so 3 int columns in the: UserID, DocID, MRU_Sequence. While I could have th...more >>

Hello everyone, we have a database we use for an aspnet application that, sometimes, gives us problems. Checking my applications' logs I found many Timeout Expired problems, looks like a transaction is blocking some tables... I checked all my source code and it seems there is no way to let ...more >>

I have a TEXT column in a table in SQL2000 that stores information in RTF. I would like to be able to strip out all the RTF codes etc and extract just the text used for use in reporting. Anyone have a solution that might meet my needs? Thanks in advance, Mark ...more >>

Hi all, I have a bit of a connundrum (let alone not being able to spell that big word!)... I have an old legacy database system which can only be access via an equally old cache driver...I can fire off extremely simple SQL statements to it, which an MSQL job on the system must convert in...more >>

Hi all, Need SP to: a. update values in one table based on values in another. in order to do that, I need to get the last entries in a history table called "GA_Acct_Reset_History" I've got this code straightened out: (thanks to you Forumites... much appreciate it) (it gets the last Thre...more >>

Hello there, I want to partition a very large SQL Server 2000 database into 2 parts and separate them in to different geographical locations (let's say 'A' and 'B'). My plan is: - step1: back up the original database in location A and delete some records from the largest table (DELETE FROM ...more >>

Here's my issue ======== history table to select from has the following columns: Acct_id, Threshold, DateCreated In this table, there are multiple rows that contain the same Acct_id & threshold but all DateCreated dates are different. (its a history table as well as the reference for the ...more >>

In a smalldatetime field I need the default value to equal current date with a format of mm/dd/yyyy. In the Default Value of the design view (getdate()) returns 12/18/2006 10:47:00 AM and (datepart(day,getdate())) returns 1/16/1900 I don't want the time, and I'm not sure where 1/16/1...more >>

In a smalldatetime field I need the default value to equal current date with a format of mm/dd/yyyy. In the Default Value of the design view (getdate()) returns 12/18/2006 10:47:00 AM and (datepart(day,getdate())) returns 1/16/1900 I don't want the time, and I'm not sure where 1/16/1...more >>

Hello folks, I am messing around with MsSqlSpatial extension for SQL Server 2005 and am attempting to create a simple reverse geocoding query. The problem is rather simple & boils down to passing parameters into a table function when those parameters are obtained from the SELECT statement. ...more >>

Well i am rather new to sql about a month into it and not sure if what i am trying to do is impossible or not. On my join i am trying to get the result of a specific products most recent date and time as well as who made the move. I have everything fine it will give me a result of about "30 ro...more >>

I have one of our production Accounting Databases starting from 2 GB now grown into a 20 GB Database over the period of a few years... I have been getting timeouts when transactions are trying to update different tables in the database.. Most of the error I get are I/O requests to the data f...more >>

Can someone help me with the delete statement below? I am running SQL 2000 and I can't find a good way to run this delete. I am not a very good optimizer in SQL statements. I am not sure why but I cannot use the alias in the original delete statement hence the ridiculous code. I tried somethi...more >>

I want to insert a text file into a tabel, and I am using the BCP utility. The file I am inserting looks like this: aaaa;1234;bbbb;123456;Dog Cat Bird;097763 I'm using a xml formatfile. Is there a way to truncate the field "Dog Cat Bird" so the string inserted into the database is only...more >>

I have created a function which returns a table with two fields which works correctly when using select * from myFunction(1234) I have an exisitng SQL Statement that I would like to use this function in and use an int field from the existing SQL statement. When adding to the Select part of the...more >>

hi, i want to retrieve records with distinct emp_last for the ord_num example ord_num,emp_first,emp_last,desc duplicate records of ord_num is allowed only if there is different emp_last. please help me to solve this. thank you vanitha...more >>

How to get list of all relations (references) of certein database's table? eg.: SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS COLS INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS CONS ON COLS.CONSTRAINT_NAME = CONS.CONSTRAINT_NAME WHERE COLS.CONSTRAINT_CATALOG = DB_NAME() ORDER BY C...more >>