Hi All, I have to a few backups restored from a set of backup files. The backup files have been removed from the drive because of some storage constrains... For some data comparison reasons, I need to figure out the actual date of these backup files that is used to restore these databases. ...more >>

I am using Access 2003 as a front-end to a SQL Server 2005 database. I make design changes using SQL Server Management Studio. I have a table that includes a datetime column. I create a view and sort by the datetime field. When I initially look at the result it is sorted correctly. Then I sa...more >>

I have made trigger on table 'FER' that would be fired if data is inserted, updated to the table. And also, I made batch file using bcp to extract the newly updated / inserted records. But I got missing data in bcp out file like this: Missing 1200 records, blocked at: /* 777946 296188 ...more >>

I have a trigger 'trgTblUpdate' working on the table 'Tbl'. When the table 'Tbl' got inserted/updated data, the tigger is fired and then we use a batch file with bcp command to unload those new inserted/updated data to another server. But in bcp out file, it didn't get all new inserted/updated d...more >>

I realize that this may not be the correct ng for this question, and if so, I'd appreciate a pointer to the correct group. I am not including DDL/DML for this question, because I do not believe it is relevant. What I have is a SQL query, which when executed in Query Analyzer takes about 10-...more >>

hi, we are having urgent requirement for one of client cmmi level5 company in hyd and chennai if u r intrested send me u r updated resume gangadhar.sadhu@optionsindia.com ...more >>

After loading the BCP files that are created during the trigger/ reporting events I've noticed that the data in the table is missing records. I've also noticed that the missing records (records in the table but not in the BCP out files) seem to occur in contiguous blocks. Since the complete s...more >>

After loading the BCP files that are created during the trigger/ reporting events I've noticed that the data in the table is missing records. I've also noticed that the missing records (records in the table but not in the BCP out files) seem to occur in contiguous blocks. Since the complete s...more >>

Can someone help me with an advanced query? I have two tables Table 1: Employees Cols: UID, lname, fname Table 2: StatEntry Cols: UID, Timestamp, description The queary should reaturn all the information in both tables. If more than one entry exists in the second table, it should r...more >>

While I was out of the office the Lan Team moved one of my SQL Server 2000 servers to a new network domain. Since then the maintenance job has not ran. The error log for the SQL Agents has the message listed in the subject line. I have not found any useful articles on the MS SQL Server ...more >>

Hi. I have an ancient preCambrian app that uses the db library to interface with sql server databases. It is written in c++. When testing it I noticed on one machine with sql server 2005 installed it runs fine, but on another it has some problems, notably.. it gets as a result of a selec...more >>

I'm trying to update an older table with some new information. Our previous systems stored US state info by their abbreviation, now have a state table and link with the appropriate state id. I would like to update the old table to our new system so set a new field called state_id to the stat...more >>

I have my first small SQl Server 2005 database developed on my local server and I have also its equivalent as an online database. I wish to update the local database (using and asp.net interface) and then to upload the data (at least the amended data, but given the small size all data should ...more >>

Hi, I have a client that needs to issue soap calls to a third-party web service from within a DTS package. Is this even possible? I've looked everywhere and found the sqlxml, but that looks like it provides a soap web service, not consumes one. Right now, we are consuming the same web ...more >>

i have a bunch of dts packages..from sql2k is there a utility to convert them to sql2005 any suggestions dave ...more >>

Hi, I have a database with table name as test in that i have 6 colums they are name varchar (20) address varchar (20) position varchar (20) nametype1 varchar (20) nametype2 varchar (20) nameval varchar(20) now in the nametype1 and nametype2 there are values like nametype1 ...more >>

In my asp.net application I have a local report with an image control in the detail row of the table and the Value attribute set as ="File://" & Fields!FQPhotoFileName.Value The first row in the table always shows the wrong image and it's always the same wrong image. The problem is there e...more >>

Here's an oversimplified version of a query that I'm writing and wanted to know if there are any performance differences between the two versions. select * from table_a a , table_b b where a.col_1 = b.col_1 and a.col_1 = 1000 versus select * from table_a a , table_b b where a.c...more >>

Avrei questo problema devo spostare dei campi da una tabella in cui appoggio i record recuperati da un file excel in varie tabelle esterne. La tabella di appoggio contiene in totale 92 colonne da spostare in varie tabelle relazionate. In pratica dovrei fare un loop su tutti i record della tabel...more >>

I have this problem occuring intermittently: When I try to add a package to the project, and click on the Package path button. I get a oledb error x080004005 (client unable to establish connection)... After I click ok, and click on the Package path again 2 or 3 times, the error go...more >>

We are trying to use source control to store our database objects and queries in Perforce. The general idea is to produce scripts which create all objects in the DB and then store the SQL in source control. Has anyone done this before and can suggest some advice? Alternatively if anyone has ...more >>

Hi All, I am running SQL2000. Can anyone tell me how I can use the contents of a table as parameters for a stored procedure that resides on a different SQL server? I have a table: Customers: Cust_ID Cust_Name Cust_Contact Cust_Phone I need to execute a stored procedure and pass e...more >>

I have installed SQL Server Management Studio 2005 and have been finding the equivalent of the Data Transfer Services in SQLServer 2000. I think I have worked out that it is in SQL Server Integration Services but when I open File-New-Project I do not see the SQL Server Integration Services the...more >>

Hi, New to SQL. Got some questions about it. Suppose I have two tables. Each of them has a single column, named as c1. For table T1, I have: 1 1 1 3 3 5 7 9 For table T2, I have: 1 2 3 4 5 1 3 The exercise I want to do is to select the number of occurence in T1 for those e...more >>

Trying to transfer databases from MSDE to SQL. When I use SQL Enterprise Manager - DTS - import or export, it works for the first database, but then fails for the others. I select the to and from databases using DTS - Import - 'MS OLE DB Provider for SQL Server', then select 'Copy objects ...more >>

I'm having difficulty searching for an answer to this challenge. Can someone give me a clue on the right keywords to use to find a discussion on this subject? All of the ones I saw appear to touch on older versions. I'm working with SQL Server 2000, and need to backup and restore only tables...more >>

I have a TSQL script that restores a production database to my local development machine. Every time I do a restore, I have to go into Enterprise Manager and set the recover model to simple to prevent Windows XP Backup from having shadow copy problems (that is a rant in and of itself). I w...more >>

Hi, I have a Scheduled Job on my PC that runs against a Linked Server. I have scheduled the Job to run when SQL Server Agent starts and I have configured my SQL Server and SQL Server Agent to start when the OS starts. The connection to the Linked Server is via my Broadband internet connec...more >>

I have a very very strange situation with a particular application and sql server 2005 enterprise. This application combines numerical data from multiple tables. User can make query over this kind of tables, can build queries with "group by" "order by" and "join", "sum, count(*) ecc. on many m...more >>

I want to use an input parameter as my filename, but I get a synatax error message. Howerve, when I hard code the filename the proc compiles successfully. Thanks for any help. I'm using SQL Server 2005 LTR_90, LTI_ELIG_pct, LTI_REC_pct, LOW_SALARY, ...more >>

Hello, I am attempting to write a stored procedure that builds and executes a dynamic SQL statement which can be up to 8000 characters long. Therefore, I have declared a variable of type varchar(8000) which, according to the documentation, is the maximum acceptable length of such a variable. ...more >>

Hi All, Hope someone can help me... Im trying to highlight the advantages of using table variables as apposed to temp tables within single scope. My manager seems to believe that table variables are not advantageous because they reside in memory. He also seems to believe that temp tables d...more >>

Hello, I created a script with database publishing wizard to convert a SS2005 db into a SS2k db. The script has schema and data and looks very good. When I try to start the created script in SS2k-Query analyzer, I get an error like (in german) Server: Nachr.-Nr. 105, Schweregrad 15, Status ...more >>

I am trying to recreate the same functionality Google has in regards to suggesting words (not names), when you misspell something it comes up with suggestions. We have a list of words in the database to match against. I've looked at SOUNDEX but it is not close enough, DIFFERENCE is even wor...more >>

Hello all, I am looking for the script, which I believe exists already.I need to be able to populate the script for security of one database and apply it to another database, even if it is located on another server: 1. All logins which not exist have to be created and which exists ignored inclu...more >>

will it be possible to increase number as below automatically 00000001 00000002 00000003 .... whenever the row is inserted, number will be increased like above format. which data type should I select and do some other setting to record like that? thanks ...more >>

I am using derived tables to Page data on the SQL Server side. I used this link as my mentor for doing paging on the SQL Serverhttp://msdn2.microsoft.com/en-us/library/ms979197.aspx I wanted to use USER PAGING, thus I used the following code: CREATE PROCEDURE UserPaging ( @currentPage int ...more >>

You can use a Select top @variable in sql server 2005: Thus: --'Throttle' the result set: Select Top (@MaxBatchSize) KeyID , LId , ArrivalDt , CaptureDt , Lat , Long From GPSData Order By CaptureDt Desc Makes messing with Set Rowcount *so* redundant :-) ...more >>

Hi All, What are the pros and cons between using Enterprise Manager or Query Analyzer for my queries. Currently I use Enterprise Manager because I prefer the interface and only use Query Analayzer when queries time out in Enterprise Manager, but I'm sure there must be more to it. Regards...more >>

Hi, i have two servers. database A on server A . database A on server B (both sql server 2000 - both same d/b - server B being the standy by).if i delete databse A on server Ai have to deleted the standyby copy on server B. can anybody please guide me as to how to do this. Thanks, Shark...more >>

MS SQL 2000 sp4 on WinXp Pro SP2 I am very new to this so please let me know what I can do to make it easier for you to understand the problem. I have a non delimited text file. This text file has several columns that for the most part are fixed length but.. The fixed format starts with...more >>

I do a SELECT * from table command in an ASP page to build a text file out on our server, but the export is not to allow a field name rows of records. The first thing I get is a row with all the field names. Why do these come in if they are not part of the table records? How do I eliminate this ...more >>

Say I have a table of data containing something like Region | County | Year | Month | Value for some sort of value (int). I want to re-arrange this data so that it comes out like this: Region | County | Year | J | F | M | A | M | J | J | A | S | O | N | D where the letters are obviously...more >>

Hi, I need to list all the tables in northwind database. I'm using sql server 2000. In query analyser i'm in master database. I don't want to change the database to northwind. How to list all the tables in northwind database when the database combobox has master in query analyser. I want to r...more >>

Hi, I want to create query where I could group records by quarters, and get the last record in each group. e.g Create Table MyTable ( Value [float], date[datetime] ) Insert into MyTable (value, [date]) values (100, '1-1-2000') Insert into MyTable (value, [date]) values (110, '1-2-2000') ...more >>

Hi, I am at a bit of a loss about what to do with a problem I am having. I have a 7GB database, loaded on to SQL Server 2000 SP4 on 2 different machines. Machines have following specs: 1) Intel Pentium 4 Dual Core 3.40 GHz, 3 GB RAM, 2GBb RAM available to SQL Server. Windows 2003 SP1 2)...more >>

I am trying to create a view that creates a mailing list from two different tables. The t-sql code executes successfully but when I try to open the view I get this error message [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type vchar to float. Here is the t-sql code I ...more >>

Okay, here is my issue: I have an access program that tracks the location of certain items. When the items are moved their record will be added with transfer information. So, there are two tables: tblContents and tblTransfer tblContents holds all the relevant information about each item as...more >>

Hi All, I am trying to create a user defined function that fetches the price of an item. I have written a scalar function that takes itemid and returns its price. Simple version of tables would be like this: Item( itemid int,--pk price decimal(18,4) ) item_detail( redid int , --pk i...more >>

Hi This is a dumb question as I know it's fairly easy but I cant seem to find an example after two hours of searching. In a stored procedure I'm trying to build up a string eg, (the following is in a loop) IF @xcount > 0 BEGIN Set @list = @list + @title + ': ' + @xcount END Probl...more >>