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

Hi, i'm trying to make a stored procedure and appear this error on the code, i hope somebody can help me SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE factura_detalle_data AS BEGIN SET NOCOUNT ON; DECLARE @tipo_documento VARCHAR DECLARE @documento NUMERIC DECLAR...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 >>