Hi, When I search and find a topic in SQL 2005 Books Online, the help browser doesn't give me any option to synchronize the found topic with the "Contents Tree Hierarchy". Is there any way to have synchronize feature available in SQL 2005 Books Online? Thank you, Max ...more >>

Hi Everyone, i have two tables in the database . One is called address table and one is adressPhone Table. Below is the sample of those two tables Address col1 col2 col3 X 12 13 y 15 19 z 18 10 create table address(col1 varchar(20),col2 int, col3 int)...more >>

Hi everyone, A number of my clients keep talking about creating a backup server so that they can quickly switch to the backup server in case the live database server failed. I was dabbling with the following idea. If I could create a software that continuosly trapped SQL commands being f...more >>

hi, can i know vhdl code for PID? -- aramis ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ ...more >>

My application is developed in VB.NET and uses a single/same connection string for all users (all installations), which uses SQL Server 2000 as the data store. But I need to keep track of who inserted a record and who modified a record (along with the dates and times). Using triggers, I can ea...more >>

I'm having trouble getting the following stored procedure to work. When I call it, I get 0 rows returned. I call it like so: EXEC RetrieveShipments 'City','Is','Omaha' or EXEC RetrieveShipments 'City','Contains','Omaha' neither method returns any rows. Each field in the database is d...more >>

Values of two columns in two different tables--presentation using select Hi Everyone, i have two tables in the database . One is called address table and one is adressPhone Table. Below is the sample of those two tables Address col1 col2 col3 X 12 13 y 15 ...more >>

We have two remote data sources that we will access via a SOAP call. But then we need to operate on the two sets (remove dups, etc.) and, ideally, return a SQL result set to the client app. So questions: * Can we make a SOAP call using C# from within SQL Server? * Can SQL Server operate on...more >>

I am running SQLServer 2000 and am parsing a delimited file. Each line is delimited with a crlf, but each line also ends with a tilda (~) that I do not want to process. Each line does not have the same number of elements, but every line ends with a tilda. Is there a way to set the input file p...more >>

I have 2 columns both float and containing numbers as follows : 3.75 and 2.5533333333333328E-3 These are the returned via a dataset into my code and when I add the values together I get the value 6.30 ------ But this doesnt seem right as the value that is return "2.553333333333332...more >>

I would like to find the cleanest way to do a backup and not have to backup the log. I have a number of DTS jobs that run as batch - loads data into SQL Server. I know for fact that at a certain time after the batch, no one is in the database and no jobs are running that affect the database ...more >>

Bonjour, I wish to access a DB2 database wich is on a AS 400. 1) wich OLE db driver must we use ? 2) where can we download it ? 3) is it free ? 3) how to configure it ? We have try different syntaxes without success : Example : sp_addlinkedserver @server = 'AccesDB2_AS400_TRY1'...more >>

I have a Visual Basic 6.0 app that I developed initially using MS SQL Server 7, then MS SQL Server 2000 and now MS SQL Server 2005. I seem to get this error more often in 2005 that the older versions. Googling does not seem to give any help. What are the causes of this error? What can I do to a...more >>

Hi I should write an Extended Stored Procedure for a SQL Server 2000. This Extended Stored Procedure includes differnet function which I like to call from applications (C++, Java) via ODBC or JDBC. I have done that already, I mean I know how to do that. But now I read something about CLR...more >>

Start playing around with SQL 2000 Server and Visual.net made an instance of sql, I can go in and add tables,etc. I downloaded MSDE2000 and installed as per instruction went to a command prompted and entered Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA PASS...more >>

Hi, I am assisting someone trying to look up information for the following question. Please keep in mind that he is computer tech savvy and I am not. If this question does not apply to you could you please direct me to the department that would best handle this question. How do I call a...more >>

HI all, Whats the best practice when it comes to deciding what to put into triggers or SP. At the moment I find myself putting a lot of stuff into triggers. I have no idea as to what is generally considered too much for triggers. Any thoughts Thanks Robert ...more >>

Can you use a 4-part name to execute a User Defined Function? For example, server.database.owner.function_name()...more >>

I recently had a problem with a process that had been working, well, forever. The process starts a DTS package step (SQL Server 2000, Windows Server 2003 on both machines; both machines are in the same domain, behind our firewall) that copies records from one server to another. For some reason...more >>

I have a DB with 22 columns. My first column is Serial_Number. Original serial numbers are 8 characters 12345678 Rework serial numbers are 10 characters 12345678-R If I want to retrieve the all 22 columns but just rows with original serial numbers what query would I use? Likewise, if I wan...more >>

Is it possible to find who was deleted row from sql server 2000 with t-sql, query analyzer??? ...more >>

We have used a template for 350 excel files and now we are trying to extract certain information from these files to either one excel file or to an access database. The problem is that in this template the rows are not necessarily the same in each file. (E.G. If a company started in 1995 the cor...more >>

Hi All I have created a Stored proc to get the all user rights on a server by database. I am going to use this SP in my reporting services 2005. I created a user with public rights in all Databases on my server. For some reason unless I grant this user SA rights, it will not return any rows...more >>

Hi Our third party provider extracts data into a SQL database and use the character '@' within certain column names. This does not prove to be a problem if all records within a table are required. In other words, a 'Select * from TABLE' query works without a problem. The problem arises w...more >>

Pet_CIF varchar 15 Pet_Name varchar 50 Pet_Surname varchar 50 Pet_CompanyName varchar 200 Pet_Particular bit 1 Pet_PostalCode char 5 I need to order this structure. Using case I want to order by Name and Surname if it is a Person and by CompanyName if it is a Company, the problem is whe...more >>

I need some help with two problems. 1. I'm importing a text file into my db however the text file has the following rows that I do not want imported The First 4 rows Source File Name : CDW - Facility File Create Date : 20060209 Time Period : 200512 SRC_SYS_ID|CORP_NBR|IP_ID|OBLIGOR_NUM...more >>

Can someone tell me why my query is not working the way I think/need it to. I build a #tmp table with columns Company AccountNo, ContactName, Title, etc in it. There can be many records with the same company name, different contacts. Example: Company ABC 123 John Smith CEO Compa...more >>

Does anyone know how one might, from within a SQL query, determine when the last successful full backup occurred. I can see this information within Enterprise Manager (or Management Studio in this case) but I'd like to take that information and use it to execute a cleanup task to delete all ...more >>

I am writing a script that will go through all the database files on a server, collect the file sizes and return the values in a single table. This script works for the most part, but there is an instance when the script fails to collect the information properly. When there are two or more data...more >>

Hi, Is there any way I can get serial number in sql result? e.g. Serial Name 1 Joe 2 Ray 3 Sue etc.. Thank you in advance Shailesh ...more >>

Hi all, May I know what is the select statement to find the number of occurrences of a particular value of a column? Thanks. -- Eric_Singapore ------------------------------------------------------------------------ Posted via http://www.codecomments.com -------------------------...more >>

Hi, Nightly I am importing 8000 rows of data into a table with 3 billion rows. The table has one clustered index. Should I disable the clustered index before importing? If so where do I find info on disabling and enabling clustered index on a column? Thanks...more >>

I am in the process of creating naming and design guidelines for Sql Server for our new project. If you have any suggestions about naming conventions(in particular) and design guidelines it would be exteremely handy. Thanks for reading this post. ...more >>

I need to compare the permissions for a specific user between two databases for views, tables, and stored procedures, to make sure that they are the same. If I could just figure out how to extract the data from each database, I don't mind a certain level of manual comparison in Excel. I hav...more >>

Hello, I'm hoping someone can help me with the following problem. We are using ISQL in a batch file to execute a lot of SQL files. The problem we have is that some of the foreign characters are being changed; e.g. Benötigte Lieferungen becomes Ben÷tigte Lieferungen If I open an ...more >>

I have a simple database with several columns of nvarchar text. I can do a search and replace if I know the entire string of text to replace. In a table I have used: update Table1 set Column1='NewText' where Column1='OldText'. However, that only works when I know the entire string to be sear...more >>

Hello All, I have an strange issue regarding inserts via a view. Below are the environemnts and the code. Both environments are identical however, service packs a different. Environment 1: This environmnet the insert works Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Windows 2k sp4 ...more >>

Does DBCC CheckDB update the sysindexes table, similar to DBCC Updateusage? Thanks, Mitch...more >>

Hi to all! I want to inert values on the basis of another query e.g. insert into northwind values Select * from from pubs.dbo.orders where orderid = '16887' it is giving me syntax error, can someone explain wht is the reason. Thanx, Farid. *** Sent via Developersdex htt...more >>

Please help me.. I am stuck on the Problem related to Store Procedure I want to use Extended Store Procedure. I read tech document related that on MSDN, but i am unable to register the Extended Store Procedure. Please guide me step wise step, So that I can register the extended store Pro...more >>

I need to generate a report where the column names are defined by the results of the first query and the data by the second query. The closest I can get is to create a stored procedure that creates a temp table with named columns fill it with a single row (query 1) and then fill it with da...more >>

Hello NG, is there a way to evaluate a resolver error (after a ddl statement) within a stored procedure? If you run the following code: select 10 / 0 select @@error you will receive an error for the first statement, but the second statement will be processed (so you see the...more >>

Hi All, I have a table in which one of the columns is Text. I need to concatenate a hard coded text with the value of the text column for each and every row of the table. Is this possible. -- Sevugan.C...more >>

Hi, I am using SQL Server 2005 and .NET Framework 2.0. I need to create a trigger using managed code assembly. I did following steps: 1. Wrote a .NET class that implements the functionality of the trigger. 2. Compiled the class to produce .NET assembly 3. Registered that assembly using C...more >>