i need to programmatically obtain and process constraint key information. the problem with the output from sp_helpconstraint is that it outputs 2, and sometimes 3 resultsets. (the 2nd resultset/constraint_keys is exactly what i need however) because the resultsets vary in output format, i ca...more >>

i need to programmatically obtain and the process constraint information. the problem with the output from sp_helpconstraint is that it outputs two resultsets. (the 2nd resultset is exactly what i need though) as far as i know i can't stick this output into a temp table to then process with...more >>

Hi I'm using Access 2002. I have 2 tables tblGroupContact, tblGroupPermission, both have 2 fields identical structure: ContactID GroupID (Both are Composite keys and both hold integers) tblGroupContact holds everybody and the groups they are members of. tblGroupPermission holds only th...more >>

SQL Server 2000 SP4 I was wondering what has the best performance for maintaining referential integrity ... triggers, constraints etc ..... Thanks, Craig ...more >>

One table I manage has a clustered index, and it includes some varchar columns. When it is initially created, all the columns in the clustered index are populated, and then some of the longer varchars are populated through update queries. If the varchar columns are stored outside the clustered...more >>

I am wanting to set up some kind of metadata catalogue to manage metadata records of the data we collect and create for my companies clients. I am thinking I want to do this using XML and SQL Server and have some type of web-based browser to search for records. Any suggestions on existing a...more >>

Hi - I'm getting this error on a merge subscription between two SQL 2000 SP3 machines. The agent has been working fine for many weeks and nothing obvious has changed. Calling up details on the error doesn't give any further info. I've even tried putting it onto the 'Verbose' agent profile. ...more >>

Hi, I'm trying to get an overview of counted visits per day for a webapplication. The thing is that SQL doesn't work with full days. For instance: getdate() returns a fulldate instead of a date in the format 'yyyy-mm-dd'. I need this format, without time specifics, to be able to group rows...more >>

Hi Gurus I have a sproc that checks a certain field in our software. It is to prevent users from entering alphabets. The problem I have now is that this sproc is looking for a number to be in there. I need to only raise the error when there is an alphabet in this field and NOT if the field is...more >>

Hi All, If have a sql table with 2 columns and 2 rows with values [["col1row1","col2row1"],["col1row2","col2row2"]]. Using t-SQL with "for xml" How can i create a xml where the cell values (not column names) appear as elements? eg: <col1row1>col2row1</col1row1> <col1row2>col2row2</c...more >>

The cost of query with usage of functions is as same as that of without functions In the below code, the query cost of insert is 0.02% and two select statements costs same 0.04% Declare @t table(mydate datetime) Declare @i int set @i=1 while @i<=5000 Begin insert into @t values(getdate(...more >>

I have over three hundred text files that I need to import to SQL Server. Each is in the exact same format. I want to import tham as seperate tables. Is there any way to do it in one process? Regards, Ciar=E1n ...more >>

Hallo ! I have 2 tables with similar construction. DataOLD and DataNEW. In my grid I need a JOINED table. On the one hand I need all the data from the old table and the data from then new table with the same id (left outer join works) But additionally I need all rows from the new tab...more >>

The event log is showing a ton of failed sa logins. The server is connected to the net. I am assuming this is a dictionary attack to get the sa password. I am trying to find out if this is an inside attempt or from the outside. While the profiler will tell me which program or script is sending ...more >>

I know that there are tools like Lumigent, but an wondering about the internal facilities to track events such as table creation, security operations (add login, add role), and such. Under Sybase, there is a set of procedures that permit you to set theses events and to record the results for l...more >>

I am creating a stored procedure that will perform a search against a table. I am passing search parameters to the SP. If the user did not select a value on the front end, then I am passing NULL into the SP for that field. So my question is, what is the best practice to only search on a field if...more >>

Hi, I have a table with about 305 million rows, and a composite primary key that consists of an ascending int and an ascending varchar(18), which is typically of length 13. Even if all the keys used the full 18 characters of the varchar, it seems to me each key should be 22 bytes, so the inde...more >>

Hi I'm trying to port some data from one database table to another database table on the same server. This is the query I am using: -----> INSERT into newdatabase.dbo.contactevents (EventTypeID, UserID, ContactID, DateEntered, EventDate, Description) select '20','1', ContactID, '1/1/20...more >>

Hi, I'm getting the above error when i try to fill a Dataset through a dataAdapter. I presume it is to do with the sql statement. Below is the relevant code: string strPntUnitID = patientCodeLbl.Text; string strPntFName = fNameLbl.Text; string strPntLName = lNameLbl.Text; // Create D...more >>

Hi All, My question is that can I configure SQL MAIL, if my EXCHANGE SERVER is on different domain and my SQL is running on different domain.Can anyone guide me for this because I googled a lot without any result. I am using SQL SERVER 2000 Enterprise Edition with service pack 3. a...more >>

hi gurus the scenario Frontend - MS Access (not yet decided whether MDB or ADP) Backend - MS SQL Server it is a conversion from MS Access backend to MS SQL Server Backend. Planning to create stored procedures for all the Inserts, Updates, Deletes and Business Rules / Validations wherever...more >>

I have made the following test stored proc that all it does right now is accept a string variable that will be a list ie. :5,9,6,13. Right now all the SP is doing is creating a temp table to store the values in the list, then looping through the list and inserting the values into the temp table,...more >>

Hi all, Is it possible to move the distribution database to a new folder/drive without removing replication? I am attempting to do it the same way you would move tempdb: ALTER DATABASE distribution MODIFY FILE (name = distmodel, filename = 'C:\DISTMOVED\distribution.MDF') ALTER DATABASE dist...more >>

Before I go into specifics, this is my problem. I've have a table that gets updated with large amounts of data on a monthly basis. Sometimes (rarely) identical rows of data are on one months import that already exist from the previous month. I can identify these rows from a combination of two ...more >>

Hi all, I was running an MSDN version of SQL 2000 Developer Edition on a server until I accidentally upgraded it to Enterprise Edition while attempting to install some Management Tools. Is it possible to downgrade it back to Dev Edition? Thanks, Josh ...more >>

Hi, Does anyone have any suggestions on an approach to speed this up please? I need to check a given column in a given table to see whether there are any characters within any of the records that fall outside of a range of valid ASCII characters. My problem is that of speed. The approach...more >>

hi, my structure table in database: Amount float(53) not null default 0 when i try to run his script: alter table ABC alter column Amount float(53) null it can only set the Amount to allow null, but can't set the default value to empty. anyone know how to set the field to allow null a...more >>

hi gurus have a employee table which consist of the normal employee related fields which the fields empid and supervisor mainly related to this question. have to create a single (the question is whether it is possible) or a stored procedure to get the result as follow. the input parameter i...more >>

I have a DateTime column in a database table. How can I get the equivalent UTC value for this column? eg something like the DateTime.ToUniversalTime() in C#. or select DATE_COL1, getutcdate(DATE_COL1) FROM TABLE nb: The GETUTCDATE() function returns the current utc DATE ...more >>

I have two tables. The first one is called Protocols and contains the following columns: ID (table key) Name The second is called ActiveProtocols and contains the following columns: ID (table key) ProtocolsID (foreign key to Protocols) I want to create a dataset that will exclude all rows...more >>

I have a stored procedure which is performing a search against a "task" table. I would like to pass in a variable called @strAssignedTo which will be a comma delimeted list of employee ID's ie: "5,6,10". So my SQL without this variable would be something like: WHERE intAssignedTo IN (5,6,10) ...more >>

The third edition of SQL FOR SMARTIES was just released. http://books.elsevier.com/us/mk/us/subindex.asp?isbn=0123693799&country=United+States&community=mk&ref=&mscssid=S6KSJJEP0NU19NPCDAVNKEJMF3HA1L99 ...more >>

OMNI GROUP tgugger@aimexec.com T-SQL/ CONTRACT TO PERM/ ATLANTA I'm looking for 1-2 TSQL developers for a 4 month contract to hire ...more >>

Hi Group! I would like to get a list of all the table names from a database, can anybody please tell me how to do that? Many thanks! ...more >>

Hello ! This is my table: Ordernr Date Article O1 1.1.05 22 O2 2.2.05 33 O3 5.5.05 22 O4 2.2.05 33 O7 8.8.05 55 I need one result-row for each article with the newest Order (max(date)): article lastDate lastOrdernumber 22 ...more >>

Hello! Does anybody know how to get tables structure of linked server (DBF tables via ODBC connection). I know that table structure of "normal" (not linked) server can get from systables and syscolumns tables, but now I need a structure of linked server tables. Thanks! ...more >>

Someone told me that some non-US address do not have State/Province, and some might not have Postal Code. Is this true? ...more >>

Hi, I am looking for a good SQL Server Editor which can be used for writting stored procedures, doing queries etc. It should have features like autocomplete and so on. Any recommendations. Thanks ! ...more >>

Hello group, Does anyone know how near a word needs to be to another word to be included in the results of a CONTAINS search that uses NEAR? Is this setting adjustable? Is is stored in the registry? INI or config file? I'm using SQL Server 7 SP3. Thanks, Kelly Greer KellyGreer1@nospam.c...more >>

We are experiencing problems inserting or updating image fields from one table to another in SQL Server. When we do this what ever size of file we insert is doubled in size when it is inserted into the destination table. This happens in insert and update queries, and if we use DTS. Any he...more >>

Hi, I'm kind of a newbie on DB management but I have to deal with a huge DB used for real time operations. I got a temporal table where current data is stored to work with frecuently, and then a table for each past month (historic tables, that is). The issue is that each of these tables are 1 G...more >>