Hello All, Could someone help provide a query that I can run to determine the primary key and unique columns for any given table ? Thanks in Advance, Akintoye ...more >>

Can you create a unique constraint on multiple columns, or does it have to be implemented as a unique index? If possible can someone please post some sample code? Thanks, ...more >>

I have some users that I need to run stored procedures, but they can't seem to run them unless they are in the db_owner role of the database. How do I give them access to run the stored procs without giving them the complete rights of the db_owner role? Thanks in advance. ...more >>

Hello, My boss wants me to create a front end webpage for our Reporting Services reports that customers can log onto through a webform. I'm a PHP programmer, so I'd rather do this site and the authentication in PHP than learn .NET. The main problem I see is finding a way to pass the authent...more >>

Hello all Would it be possible to migrate the MS Access 2000 to MS SQL Server 2000? My application is using MS Access 2000 as database and as user interface such as forms. Now, I want to migrate the backend database from MS Access 2000 to MS SQL Server 2000. However, I want to keep the MS ...more >>

Hi, I have a table of folders that I would like to be able to display in a depth first manner, similar to what you would see in Windows Explorer. the table is defined similar to CREATE TABLE Folders ( folderID int, parentFolderID int, name varchar(32) ) .... ...more >>

I have an Access 2000 MDB file with a SQL 7 back end. I have a main table with 50,000 records; and I have a selections table with 50,000 records for each machine that uses the database (about 25-50). This allows each user to have their own set of selections. The selections table has three f...more >>

I am doing a little research on Google about this topic and I ran into this thread: http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/63cce060ff152dcc/1dc13d4ee6758966?lnk=st&q=difference+constraint+sql+defaults&rnum=14#1dc13d4ee6758966 I read SQL Serv...more >>

I have the next question, and i would like to hear what do you think about, and if is there a better solution for "my problem" here is the question, I have a huge table with 60GB of data (image files). The problem happen always when i try to ALTER the structure of the table. For example I chan...more >>

i have a db set up that i access using an ftp connection, and an sql script file that i wish to run, how do i go about doing so? tia ...more >>

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 >>

SQL 2000 SP3 ================================================ In reviewing this screen, I have SPIDS > 100 that have a status of sleeping, command = AWAITING COMMAND and login/batch dates that are weeks old ... Shouldn't this list be more recent activity only ? Thanks, Craig ...more >>

Greetings! I am now doing one type of analysis every month, and wanted to creat table names in a more efficient way. Here is what happens now, everytime I do the analysis, I will create a table called something like customer_20050930, and then update the table by using several update steps....more >>

Hello, i have created some (test) Web Services in a Sql Server 2005 via the Create Endpoint Statement. Now i look for a node in the "Managment Studio" where i can see these Web Services. But i dont found that. What is the plainest way to do that? What alternatives are existent? Thank you, ...more >>

A general data design question: We have data which changes every week. We had considered seperating historical records and current records into two different tables with the same columns, but thought it might be simpler to have them all together in one table and just add a WeekID int column to...more >>

The following sql statement fails: SELECT IdFlight, OrganizerLastName + ", " + OrganizerFirstName + " Flt:" + FlightNumber As Concat FROM TableFlights Order By OrganizerLastName, OrganizerFirstName I'm trying to concatenate fields and words, but my asp.net page gives me an error saying " Flt:"...more >>

Hi I've got the following problem I'm using DTS to transfer fata from csv files into a table In the file there are often duplicated rows, therefore I made trigge on the table The trigger works fine when i tried in query analyzer, but it no launche from the dts. I've learned that i have...more >>

I am sort of new to SQL. I use MS-Access most of the time so I do not know if you can do this, but... In MS-Access there was a tool called documenter that would list out the table def's such as fields, sizes, data types, etc. Is there such a thing in SQL? I am using MS-SQL 2000 server. ...more >>