I recently needed to upgrade a sql 2000 machine to 2005. Instead of upgrading the sql 2000 default instance, I installed sql 2005 as a separate named instance so we could go back to sql 2000 if necessary. The web server that connected to the new server didn't have anything change on it except th...more >>

Hello, if there are tables with names starting with a # I can´t look into them, e.g. by doing "select * from tempdb.sys.tables". What is the reason for such tables, who creates them and how I can see their content? thanks and regards Mark ...more >>

Hello, I have: - server MS SQL MSDE (2000) - database 'COLLBASE' - table 'MAIN' - row: column 'NAME' value 'version' and column 'VALUE' value '003' I make backup files by SQL query. I have more backups for different versions of this database (different value in field 'VALUE' in table ...more >>

i'm trying to get total rows found by query that uses top clause... for example: select top 10 myTable.* from myTable where myTable.number > 200 let's say there are 13 rows matching that condition, and by using @@rowcount my result would be: 10. is there any way to get total row cou...more >>

Hi, Just curious. Would you use ANSI style table joining or the 'old fashion' table joining; especially if performance is the main concern? What I meant is illustrated below: ANSI Style select * from a join b on a.id = b.id Old Style select * from a, b where a.id = b.id I noticed t...more >>

We are running four servers at different sites say A,B,C and D and want it to connect main Server at head office what would be the configuration of main server for running SQL Server 2005.There are two database say X and Y at each server at sites A,B,C and D. X requires 37.4 MB memory while Y re...more >>

Hello Everyone, This is probably a simple fix so be kind when/if you reply. The query below retrieves information for individuals based on a column named ATTRIB_DEF, and assorted other columns; however, the ATTRIB_DEF column is important one. Currently the query gets all individuals that hav...more >>

I have table with 10-20 rows with field P6 which is empty. I want to update numbers to P6 starting 1 and increasing by 1. I suppose it is done by triggers but I don't know how to do that. Help :-) ...more >>

whats the difference betwwen mysql and sql server2000 in terms of using storedprocedures,stored functions and views. ...more >>

I have a Table that contains Items of the Type "Step". The primary key is "StepID". Each step can have have a target step, wich represents a subsequent step. So I have a Foreign key relationship within the same table: Primary Key: StepID --> Foreign Key: TargetStepID Now if I want to inser...more >>

A very simple one I hope? I have a table like this... ListID PropertyID MessageBody 1 75,62,2,4 erter tdfgs fd 2 6,25,75,23 dsfgsdfgsdfg sd 3 2,7,36,2 dfsdfgs dfgsdf 4 4,73,75,4 s dfgsdfg sfdg I want to sel...more >>

Dear Group Something that I ever found quite difficult was finding a bug in a script e.g. in a stp#ored procedure as often it would indicate the error in a completely different line in which the error is actually located. Take the following script ALTER PROCEDURE [dbo].[fra_UpdateCompany] ...more >>

I have a table that has records layed out as so: Table: fd_Id INT IDENTITY (1, 1) fd_User VARCHAR(30) fd_Effective DATETIME Data could be as follows: 1 | "user1" | 6/20/2001 2 | "user2" | 6/1/2002 3 | "user2" | 6/5/2002 4 | "user2" | 6/5/2002 5 | "user2" | 2/1/2002 6 | "user3" | 9/1/2...more >>

Hi, I have these two tables in a Database ITEMS ID numeric (Primary key) ZDID nvarchar 3 (not null) IDF_Family numeric (not null) Description nvarchar 40 (not null) DATAS ID numeric (Primary Key) IDF_Item numeric (Foreign key) IDF_Reference numeric (Foreign Key) [Date] smalldatetime ...more >>

Hi, I have a varchar column with values like: 000 BNP=Item one HOP=Item two LLT=Item three 001 LLT=Item one 002 BNP=Item one LLT=Item two I want to parse this rows into a table similar to the following output: 000 BNP=Item one 000 HOP=Item two 000 LLT=ItemThree 001 LLT=Item one ...more >>

I have a database that is around 2 to 4 GB. If I were to estimate some numbers like 4x growth or even 10x, the database size could reach 40GB. The new server will be running SQL Server 2005. I am not sure which configuration option to take. I've gathered some information from different places...more >>

Hello! I am looking for someone who has solved this multi-million people's problem. EVERYONE seems to ahve this problem. Im a creating a data set and populating it with a call to a store proc. Its a complex stored proc with the end result as an insert to a temp table. Then I do a select fro...more >>

Hi all, i am completely new to SQL Server. So how can I do that? With Integration Services? Thanks for your help Daniel ...more >>

I am trying to find the tables and columns that depends on 'table1' sp_fkeys @pktable_name='table1' and this takes about eight seconds, whereas if I run it for finding all tables and columns that 'table1' depends on sp_fkeys @fktable_name='table1' this only takes a second. How can I ...more >>

Hi, we have a SqlServer instance in production containing around 10 databases. It has just been realised that all the db's are held on the small c: partition with only a gig or so of space left. On the server there is another partition and another hard disk both will ample space (few hundre...more >>

I'm trying to copy files between 2 servers on a local network from within a SQL Job (and Query Analyzer) using xp_cmdshell.xcopy but get an access denied message returned. I'm able to successfully do the copy from within a command window so think the problem has something to do with using t...more >>

I am developing reporting service and using lots of 'LEFT OUTER JOIN', I am worried about the performance and want to use some subquery to improve the performance. Could I do that like below, [the origin source] SELECT * FROM TableA LEFT OUTER JOIN TableB ON TableA.item1 = Ta...more >>

How do I configure the MS-SQLSERVER to accept JDBC connections and process the sql? I'm using SQLSERVER 2000 on Windows NT. Thanks for your help ...more >>

Hi All, I have read MANY posts on how to track changes to data over time It appears there are two points of view 1. Each record supports a Change Indicator flag to indicate the current record (would this be EVERY table?) 2. Each table is dup...more >>

Hi. I need to give my customer an sql file that they can run in query analyzer. All the stuff they need to run is in a set of existing files. I'd like to just tell them to load this file (this is oracle syntax): @file1.sql @file2.sql @file3.sql is there some way of calling these fil...more >>

Hi I am very new to SqlServer. I want to my java application, using JDBC, to connect to the SQLServer on port 1433 (Running on Windows NT). How do I configure it? I am using 2000 version of SQL Server. Thank you ...more >>

If an instance of SQL 2005 was in use and was using row versioning, under what circumstances would the below error occur? Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction We used to get this s...more >>

I have a situation where I need a table if bad items to match to. For example, The main table may be as: Table Main: fd_Id INT IDENTITY (1, 1) fd_Type VARCHAR(100) Table Matcher: fd_SubType VARCHAR(20) Table Main might have a records like: 1 | "This is some full amount of text" 2 | "...more >>

Hi. I'm getting errors like this when I try to run an upgrade script I'm trying to write/test: altering labels to length 60 Server: Msg 5074, Level 16, State 4, Line 5 The object 'ALTPART_ANNOT_ANNOTID_FK' is dependent on column 'label'. I used this to bracket my script: sp_msforeacht...more >>

SELECT DISTINCTROW "01C" AS dummy, Buildings.BuildingNumber, UCASE(Buildings.BuildingName) AS BuildingName, Buildings.MasterPlanCode, Buildings.UniformBuildingCode, Buildings.FunctionalCategoryCode, Buildings.OwnershipCode, Buildings.ConditionCode, Format$([BasicGrossArea],"0000000") AS dBasicG...more >>

I have a loading process that periodically inserts a lot of relatively large files (up to 400MB) into a few substantial tables (about 50GB). Sometimes, after inserting many files with no problem, the DB server memory usage will suddenly jump from about 4.5GB to about 5.5GB (the server has 4GB ph...more >>

Hi, One of our third-party software vendors is planning to implement BLOB in their database for storing certain documents. We are not too thrilled about it, since it can be a drain on our resources, but I would like to get the expert opinion out there on the pros and cons of implementing thi...more >>

Hello, I wish to see if the tables from database A server A1 exist in database A on server B1. I setup a linked server from my first server (robertcamarda) to a target (cognos-dev) This works from robertcamarda: select count(*) from [cognos-dev].ds_v6_source.dbo.stdmas and this works: sele...more >>

hello ! I got some problems here. I have an attribute that determines the unit of something,e.g. the size of using "mm" , the length of using "seconds" and something others may using "n-page", so ,which data type should I use. the "nvarchar" or others? thank you very much! *** S...more >>

hello sirs purpose OUTPUT keyword with examples ...more >>

I am getting time-out errors when I try to perform a simple delete on a linked server. The command is: Delete From MyTable Where PKID=12345 I have tried executing this command directly from Query Analyzer, but it just times out. However, when I run it from QA against the server itself ...more >>

Hello, how I can detect via code (C++, C#) which sql servers like oracle, mssql, mysql are close to me and connectable within one or two second (timeout to wait for answers should be variable)? Thank you. regards Mark ...more >>

I would like to know how to put an attribute on the root node of the xml returned from a FOR XML PATH query. One thing I tried is this: select m.msgid '@msgID', st.namelong 'set/@namelong', st.nameshort 'set/@nameshort', from msgset m inner join settable st on (st.setid = m.setid) where ...more >>

I'm trying to debug/step through my t-sql code in SQL Server 2005 and I can't do it like I could in 2000. Any ideas? ...more >>

I have >200 tables and I want to create a table that lists the name of each table, the number of records, and the number of locations within the table. I've created a cursor to do this but it doesn't like it. I get the following error. Invalid column name '<tablename>'. Here's my script...more >>

Dear all, I'd like to explore more about indexing strategies and would appreciate a reference to some good resources this regard including book names. Best regards ...more >>

I am fairly new to SQL and I am currently trying to create a SQL table (using Microsoft SQL) that has a recursive relationship, let me try to explain: I have a piece of Data let's call it "Item" wich may again contain one more "Items". Now how would I design a set of SQL Tables that are capab...more >>

Hi I have set up a SQL database to contain alist FAQ's for our company and then plan to pull this info off using a web page. So far I have entered the data but I am unable to control how it is displayed inside SQL ie I cannot enter new blank lines I have tried using lots of spaces but this do...more >>

Hi all, I have installed SQL SERVER 2005 EXPRESS but i cant do a remote login with SQL Server Management Studio Express. I have deactivated Windows XP firewall in the SQL SERVER side and I have activated tcp/ip connections. Which can be the problem? Thanks all ...more >>

i have high cpu problem. i don't know why many .net sqlclinet data provider and IIS hold so much cpu resource. by the way, memery condition is normal. when i restart sqlserver, from windows task manager, i see the cpu time of sqlserver.exe process is low, but it grows gradually, and in two da...more >>

hi, in sql server, is it possible to access a UDF of other database in same server? ...more >>

Hi, I hope this is the right place to ask this question. If it is not, please let me know a more appropriate place. I have two tables. CREATE TABLE tblEmployees ( EmployeeID int identity NOT NULL, LastName varchar(50) NULL, FirstName varchar(50) NULL, ); ...more >>

I used to be able to enter new lines into the result pane cell for text (and varchar) data in Enterprise Manager, but now that I am using SQL 2005 Management Studio, this feature is gone. Is there any way to do this? Also, copying to/from excel chops off part of the text in a cell and is ve...more >>

After creating a linked server to a remote server, I needed to log in using sp_addlinkedsrvlogin to get my stored procedure to work. However, I noticed that after stopping SQL Server and the DTC and then restarting both, that my stored procedure worked without having to execute sp_addlinkedsrv...more >>

Can one use Truncate Table on a linked server table? When I try it, I get a message that only two prefixes are allowed. Here's what I'm using: Truncate Table svrname.dbname.dbo.tablename ...more >>