Is it possible to create a unique constraint to a column from another table? For example: tb_current: current_names -------------- aaa bbb tb_new: new_name -------- ccc Now I want to create a constraint on tb_new.new_name to be unique with respect to tb_current.current_names. Howev...more >>

I want to set up Multiserver Administration. The problem I encounter is a firewall between the master server and some target servers. What ports need to be set open to make this possible ? ...more >>

I am using DTS to import tables into my new database from another database, both of which reside on the same server. All the tables, fields and data copy over fine; however when I go into design view of the copied tables, the default values for all the fields are lost. It seems to copy the struc...more >>

hi we have a link server....and the user credentials are not being trasfered to link server.....any thoughts?? we get the following error message Server message 18542 level 16 state 1 -- Posted using the http://www.dbforumz.com interface, at author's request Articles individually checke...more >>

SQL 2000 I have inherited an application where many of the automated processes call a proc that simply returns the number of records with a NEW status. In watching the process in SQL, I see this ends up blocking a lot of processes - many like this are called every 5-30 seconds ... I wish...more >>

Hello All, I've got a stored proc that I can't change that creates a quite large dataset and takes in 5 parameters. I need to be able to have each of the parameters selectable from a drop down box so that as you go through the list of parameters you restrict the results. I have it able to l...more >>

So I installed an instance of SQL for an application (WSUS) and all was well. Having read in many places that I could install multiple instances of MSDE on the same box, I started the second install today (Live Communication Server). The MSDE install portion of LCS gets almost completed and th...more >>

Hi Guys I'm recovering from a hard disk crash, trying to reattach recovered files. The MDF file seems fine, but I get: "Server: Msg 9004, Level 23, State 1, Line 1 An error occurred while processing the log for database 'NetCoverAdmin'." when I try to include the LDF file. My command ...more >>

Hi all, I'd like to put together a SQL statement that will take the name of a stored procedure as a param, and return that SP's parameters. I'm writing a test application, and I'd like to wrte a generator to save myself some time, but I can't seem to figure out how to get the params from a ...more >>

hi all., How can I find the Data Base which can't backed up for reasons like Data Base is in the middle of the Restore before i start Backup Process . Regards., Sri ...more >>

How can I check (from TSQL) if a table is likely to bust the 8k limit? Thanks Mike ...more >>

I have a sql query in which I need to isolate part of the columm value and return only that isolated portion. I can only do this within the select statement, and cannot add a function or anything like that. I would also like to keep this query within sql (I don't want to do this in my programmi...more >>

Hi All Wonder if you could help, I have a bog standard table called STOCKPRICES that has served me well for a while, but now I need to change the structure of it and because a number of users have used it in it's present form I need to so the following in SQL script: a) Grab a snapshot of t...more >>

Hello Everyone We have a third party tool which maintains its own custom database,DB1 on SQL Server 2000 on Server A (Windows 2000). We built an inhouse application which maintains a transactional database, DB2 also on Server A derived from DB1. Since the DB1 is frequently updated the synch...more >>

Hi, I've got this dts package in sql server 2000 sp4 that has several transformation tasks with an oracle database (10g) as the destination. The package executes successfully when run through the dts designer but when run using dtsrun, I get the following error at the completion of all tasks ...more >>

I'm having trouble with an ODBC User that can't connect to 2003 Windows Server with SQL2000. The ODBC fails when he tries to contact with TCP client connection. When I view the Network Connection it is displaying TCP is checked, but when I view the error log is doesn't display that it is liste...more >>

Hi I am a dba for sql server recently we are facing problems with the no of connections. we have a database called ( x ) every day almost million users is using that databse after some time the cpu showing 100 percent utilization an error throwing like odbc error connection so in that cas...more >>

We have written an application which splits up our customers data into their individual databases. The structure of the databases is the same. Is it better to create the same stored procedures in each database or have them in one central location and use the sp_executesql and execute the gener...more >>

Hi How can i have Row number in my SELECT Statement ? Thanks ...more >>

Hi How can i have Row number in my SELECT Statement ? Thanks ...more >>

My application is to capture employee locations. Whenever an employee arrives at a location (whether it is arriving for work, or at one of the company's other sites) they scan the barcode on their employee badge. This writes a record to the tblTSCollected table (DDL and dummy data below). ...more >>

Hi All: I've read a whole slew of posts about creating temp tables using stored proceedures to get the crosstab ability, but I'm wondering if, for this specific case, there might be a more efficient way. What makes this question different from the others that I've read is that I'm using user ...more >>

Can anyone recommend a tool where I can email to someone both the SQL query and the result set? Right now, I'm just copying the results to a spreadsheet. No, I can't use Reporting Services or Crystal Reports. ...more >>

Has anyone had to deal with removing punctuation (commas, apostrophes, etc.) from a column? What is the most efficient way to have these characters automatically removed from the column? ...more >>

Hello, I need to produce with T-SQL a user defined function or stored procedure that make one SLQ-Statement and prepare as string from the result set. The request muss be able to return a very long unicode string. The return value nvarchar is being truncated so I'm trying to create a stored ...more >>

I need to know exactly what VBA lines Create and Destroy SQL Server Processes - i.e. those visible in Enterprise Manager under Management > Current Activity > Process Info. Why? I am experiencing strange behaviour with Processes that are created when I create a DAO Database Object with the ...more >>

my table ha follow structure.. SalaryTable: Value Salary ------------ Jan 1000 Feb 2000 Mar 3000 Apr 4000 i want the o/p as.. Jan Feb Mar Apr 1000 2000 3000 4000 Pls give me a query for this Regards, Satheesh ...more >>

I have a reporting query that I need to do a quarterly trending on. A user enters a begining date and end date, and from there, I have to determine the closest quarter to it. Also, the actual Quarter starts on Sept 4th, then add 13 weeks to that, will be the second quarter. I was able to d...more >>

Hi, Is there a way to exclude fields in a query other than just including the ones you want. If there are 20 fields and you want to see all but 3, it would be a lot easier to exclude the 3. Thanks ...more >>

Hi, I've developed an ASP.NET application which uses MS-SQL Server 2000 as a backend. But as the site hits increase SQL server reponse becomes lower. At some stage after that SQL Server gets automativally stopped bringing complete web-application down to halt. i checked the Windows 2000 Even...more >>

Is there any front IDE for MS SQL as there is MySQL Front for MySQL. I am looking for it so that it is easy to quickly add/edit/delete the data from the existing table. Please prode the Download URL is there is any. Regards. ...more >>

We have an asp.net app with about 200 data entry forms. Customers may enter data into any number of forms. Each form's data is persisted in a corresponding sql table. When data entry is complete, it needs to be processed. Here's where the questions start. How can we easily determine in whi...more >>

I am using MS-Access as a front end for my MS-SQL DB. I have a sql view that uses the following: SELECT TOP 100 PERCENT RECID, PATNUMBER AS [PAT #], SVCCODE AS [Service Code], QTY, PROF_CHRGS AS [Pro Fee's'], AMOUNT, BILLDATE AS [Bill Date], CHKAMT AS [Check Amt], P...more >>