I have a customer with two companies. Both companies stock the same items but not all of the item numbers are the same. They would like to have the same item numbers in both company's and are looking for some help in identifying the possible matches. For example, company A has item 12345 an...more >>

I noticed that SQL-Server has an "image" type field. How can I store a Word document, or a .pdf file in that field, and retrieve a copy to inspect? Thanks Jeff ...more >>

I am trying to change this query so that the output in the DTE and TME column are combined in a single column and would like it to be formatted as yyyy-mm-dd hh:mm:ss:000 but I seem to keep getting errors when I incorporate various changes. Any direction would be appreciated. SELECT Comput...more >>

I have created one trace with Security Audits event only and about 10 data columns and no filter. Which runs fine SQL profiler. I just want to trace users activity on server. But I want to keep this trace running on the server. How can I setup to run trace on server from client. I have admin rig...more >>

Hi, I need to make a copy for testing purposes of the a live database. I am not concerned that my data is completely accurate, ie. can handle seeing a transaction in action. The one thing I cannot do is detach the database, since the database is operational 7 X 24. Any thoughts on the best ...more >>

Hello, I've installed BizTalk Server 2004, but was not able to configure it. I tried few possibilities and was not successful. As i'm new to BizTalk Server, can some one help in configuring it. Please provide me with steps to follow or any website where a detailed description is given. Kind...more >>

Hello, I've a problem in DTS.The following is the scenario: The DTS which i developed is scheduled to run every day thru JOBS. The DTS has to check for the new data which has come in the past 24hrs and it connects between Oracle and SQL Server. So,when ever the new data comes fromOracle to SQL...more >>

Can I assign a single Trigger to multiple tables?...more >>

I am trying to pass a UniqueIdentifier as a parameter to a SQL Server stored procedure from a .asmx webservice. Whenever I try to run it, I get the following error: "Invalid cast from System.String to System.Guid." I have tried changing the datatype of the parameter in the WebMethod but noth...more >>

I am trying to learn more about SQL Server 2000 and wonder if anyone can recommend a book to help? Thank you. ...more >>

I am tired and it looks correct but I get a syntax error near MOVE use master go restore database MMS_CSS_DATA from disk = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MMS_CSS_DATA\MMS_CSS_DATA_db_200412211730.BAK' with norecovery MOVE 'InventorySQL_dat' to 'C:\Program Fil...more >>

Hi All, thank you for you time in advance. I am new to MSSQL, and I managed to create a sample database in my local machine, query the database etc.(using ASP.NET and C#) My next step is to "upload" the database to the Hosting service which support MSSQL. There is alot information on the net,...more >>

Dear all: I have three table named A, B and C. If any data inserted into or updated to table A, a trigger of A will deal with data extraction and write extracted data to B and C. And, B has a trigger to deal with other data consistency job, a stored procedure named sp_D. This stored pro...more >>

I have an asp.net page that is querying an SqlServer Db for various data to be displayed. Is it better to hit the database several times to pull this data over to the page or, should my stored procedure contain several select statements thereby only connecting to the database once? ...more >>

hi all, I want to send email daily by executing a stored procedure. This stored procedure should be automatically executed daily. I want to use my existing official company mail id for sending emails ( i cant create separate mail id for that). Kindly reply . -- Regards Ashok s p Lov...more >>

We have a DTS SqlServer that run every nigth at 4.00 am. To accelerate this execution i would like to re-utilezed the access plan created the previous night, but every night the DTS recreated the access-plan because the work during the day clean and write the memory. As can I resolve this pr...more >>

Hi, We've just set up Sql Server 2000 on Win2003 server. My office machine is currently running Win2000. It's been years since I played with Sql Server and I don't remember the drill for setting up remote administration. I.e. I'm in my office and the machine is in the server room. I need...more >>

I would like to creat a table in Access, that is linked to my SQL server. I have never done this and I am very new at SQL. Is this even possible and how do I accomplish it? Thank you -- Sarah Kathleen Stockton...more >>

Hi, I am upsizing an Access database to SQL 2000. 1) In an Access query the following is allowed: SELECT ...,Expr1 AS A, Expr2 AS B, [A]+[B] AS C, .... FROM ..... Apart from replacing the [A] and [B] with the whole of Expr1 and Expr2 again is there an equivalent in SQL? 2) There ar...more >>

Hello, I wrote a report in COBOL using embedded SQL. This report opens 5 insensitive cursors (to avoid locking) sometimes one within the other to access data. 5 tables accessed by this report used in the mission critical applications that require high performance and speed for insert, update ...more >>

Dear Teammembers, is there any posibility to designate which user causes a database lock? Thanks in advice. Gunnar ...more >>

Hi, Im new to this use group and this will be my first post. I have been running in to this problem, with counting the actual rows in three tables in the same query. Two tables I have managed to count from, but three is over my head. I have theese three tables: 1. Is the table with image ...more >>

Purchased Sudio MediaSuite software and that software installed SQL Server Service Manager by Microsoft ver 8.x. I have no idea what this software is, there was no choice when installing MediaSuite asking if I wanted SQL Server installed, it running on my PC, I see it in the Startup menu and ...more >>

Hi, How can I get a profile to show up in the drop-down on SQL Server Agent properties? Is there a way to do this without installing Outlook on the machine? Thanks amit ...more >>

We presently have a server running sql server for our Great Plains accounting application. The server has an attached array that contains the database data files, tempdb, and backups. The server contains the operating system, and sql server database log files on internal drives. Company does...more >>

I'm just starting out with SQL server and I am trying to understand the following. I have two tables, say "Clients" and "Products" A client can buy one or more products so I want to have a "Products" field in the clients table. which stores the list of products a client has bought. How do...more >>

Is there a way to get it so that the columns in a result set are preceded with the table name that column belongs do? Without manually aliasing each column? Right now, if I run the following query: select table1.*, table2.* from table1, table2; it only shows the column names. For example, ...more >>

I am a little confused about this point in time restore stuff. Currently I have a full backup of the database and I have the uncorrupted logfile (I guess it could be corrupted but I don't think it is). I thought that I was supposed to be able to restore the full backup and then apply the log...more >>

Is it possible to change the default location for newly created user databases? I have recently changed the location of the user databases to another drive and would like to configure SQL to create new databases in this location instead. Is this possible by changing the database and transact...more >>

Hello, What is the best method of copying databases between servers? We have some servers with Sql Server 7 and others with Sql Server 2000 and many times the wizards don't work for the version 7. The method that I have been using is rather drastic in my opinion - I copy the mdf file from server...more >>

Here is what I'm trying to achieve... select field1, field2, field3 as theDate from table1 where field2 = someAmount and field1 not in (select top 5 field1 from table1 where field2 = someAmount order by field3) union select field1, field2, field3 as theDate from table2 where field2 = anot...more >>

Hello NG, I have production DB (SQL 2000) and I have to make something that will allow customers of my application to install sql server db on there running server. Now what could be the best way to do as I have +300 tables , tons of SPs, Indexes, Jobs, and other objects on production and t...more >>

What are the requirements for installing SQL 2k and Webserver HP unix so that I can host online Database application from the Servers...more >>

For many good reasons, all my company's databases are set to the "Simple" recovery model. Would there be any performance boost in terms of BULK INSERT and SELECT INTO operation if we used the "Bulk-Logged" recovery model? BOL says that both models "Permits high-performance bulk copy operatio...more >>

Hello all, I'm getting unexpected behavior when running DBCC SHRINKFILE on my 9 GB data file. First, it's been running in excess of 10.5 hours now and, second, it is ever-so-slowly *growing* the used portion of the file. For instance, when I look at the 'Space allocated' section of the Task...more >>

Is there any way to work on a sql server database remotely (using Enterprise Manager or an Access Project) securely? ...more >>

Running SQL 2000Enterprise Edition. Is there a limit to the number of databases one installaion can support? (Is an installation of sql referred to as an instance?)...more >>

I'm sure I'm doing something very simple wrong here. I've defined a table where the primary key is defined as type uniqueidentifier, nulls not allowed, and the default value is (newid()). I'm trying to insert a new row using a command like the following: insert into MyTable values(null, '...more >>

Hy, May problem is...i have changed sort-order on sql server 2k. Target is change collation from "SQL_Latin1_General_CP1_CI_AS" to "Latin1_General_BIN" I explain step by step my operation: 1 - Backup user database 2 - Export data DTS user database in another istance of sql with collation "L...more >>

Is there a script to create the NorthWind database in SQL2005? There doesn't appear to be any sample databases....more >>

Hello NG, I have TSQL script that creates table (using cursor). When I run it directly on query analyzer it takes 45 mins but if I make a store proc and run the same script (by calling it from a job) it takes more than 12 hours. What is happening in job or store proc that it is slower that ...more >>

I was trying to run my Access Report using Link Tables from SQL Server. It is very strange that i am recieving ODBC-call failed when executing a query. RIGHT JOIN = Error INNER JOIN = Ok. dbo.TableName does not match with a table name or alias name used in the query #107.. How can i fi...more >>

Greetings ! We need to find if MS SQL has an API for connecting C++ components to it. We don't know if "extended stored procedure (xp)" is the way to go. Why do we need that ? We must implement a synchronization software layer to make sure an ODBMS has the same values as tho...more >>

Hi, I'm trying to find a sample on how to set-up (or trigger) a SQL Server event alert of Severity 009- User Defined. Thanks in advance, Ignacio ...more >>

I have an application that uses SQL and another that we will be upgrading soon. The application we are upgrading has the option to use SQL or SQL Lite. I'm assuming SQL Lite means MSDE. I was wondering if it is possible to run SQL and SQL Lite on the same server for two different applicatio...more >>

everytime i want to (Open Table-->Show All Rows), this error message comes up (( The query cannot be executed because some files are either missing or not registered. Run setup agian to make sure the required files are registered. )) Then a windows comes up with an empty table. No data and no ...more >>

Can someone tell me how to enable or disable connection pooling for SQL server?...more >>

Hi all! I am having problem with a stored procedure in which I have an input parameter that is dynamic. I want to use that parameter - in this case the sessionid for the current user - to execute an SQL Query and store the result in a temp table named as the sessionid. For example... ...more >>

If I am running SQL Server 6.5 and own 25 licenses and I wish to upgrade = to 2000 or 2003, are my licenses any good on the newer version? I expect an upgrade fee but do I need all new licenses?...more >>

dear all, I am new to sql, I have purchased a web hosting service which is supported to SQL7 can you please tell me how to create a database on that webserver, I have created a database in my local systems also let me know how to export that database to my website server. Your answer is ver...more >>