Hello, Being a bit of a SQL Server novice, need some advice with the following situation. Server A and Server B have SQLServer 2000 based databases. The vendor of the application/system has implemented their own replication process to ensure the 2 databases are in sync. However, there is no...more >>

Previously in Sql Server 2000, we would be in enterprise manager, you'd double click on a view, and a nice little dialog box opened with the t-sql statetments, there was also a check sql syntax and apply and cancel buttons. Not exactly query anaylizer, just a quick lightweight dialog box. Is t...more >>

The problem: I'm updating a report to be "multi-language" capable. Previously, any items that had text associated with them were unconditionally pulling in the English text. The database has always been capable of storing multiple languages for an item, however. Desired output: Given the...more >>

Hello all, I'm at a loss on how to do this. We're using MS SQL 2000 Server and I have a list of fields I need to find the first and last entry for. Here's an example of the table: Number - VarChar(10) Jan - Int Feb - Int Mar - Int Apr - Int May - Int June - Int ANd it'll look somet...more >>

using the tools in Enterprise Manager (SQL) how do I pull the several ms access db (tbls) over to SQL BE? Does the import/export feature do this? -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200606/1...more >>

Hi all, A (possibly dumb) question, but I've had no luck finding a definitive answer to it. Suppose I have two tables, Employees and Employers, which both have a column named "Id": Employees -Id -FirstName -LastName -SSN etc. Employers -Id -Name -Address etc. and now ...more >>

I would like to reinstall the enterprise manager of sql server 2000, and i have currently sql server 2000 SP4 installed on it. I googled on it, and read that installation of enterprise manager is possible from the setup disk, however, this is not possible: it rejects because of the service pack....more >>

Apparently the query analyser of sql server does not recognise a database with a point in it, like mail.archive.mdf I receive the following error when I use it: Server: Msg 911, Level 16, State 1, Line 1 Could not locate entry in sysdatabases for database 'mail'. No entry found with that n...more >>

I have about 20 Ms Access Databases to need to be upload onto a SQL Server 2005. Currently the are on a network/server residing on a specific drive. The goal is to keep the user face the same (ms access) and put all of the tables onto a SQL Server 2005 BE, and yet make those databases accessib...more >>

Dear all, Tables: COMPANY: COM_ID, COM_NAME, ..... PROPERTY: PRP_ID, PRP_NAME, PRP_DATATYPE_ID, PRP_DEFAULT_VALUE ( nvarchar) COMPANY_PROPERTY: CPROP_COM_ID, CPROP_PRP_ID, CPROP_VALUE (nvarchar) Use: Without adding new field the user can add new properties to the c...more >>

I need to design a system which represents multiple "projects" in SQL Server. Each project has the same data model, but is independent of all others. My inclination is to use one database to store all projects. Looking at the numbers involved, however, I wonder if I would get better performance ...more >>

Hi Hope someone can help me with this - have been staring at this problem all day, and with the cold I've got, just don't seem to be able to figure it out! I've got two tables, here with some test data - sorry, can't create DDL as I'm at home & can't access the server :-( TABLE 1: Applic...more >>

I work at a place which is currently running SQL 2000, but they are planning to migrate to 2k5. I was thinking that this is the perfect opportunity to fix all the weaknesses we have had in our data model for the longest: primary keys and foreign keys with different names, use of character column...more >>

Hi All, Does any body know how to use encryption in sql server 2005.Is it possible to encrypt a particular column in a table. thanks ...more >>

Hi to all, I have a problem I can not trace. Andgeneraly this is my problem probably. I have a SQL Server 2000 SP3 with one database. On this DB are runing lot of threads from different applications. So the access is multiple. The problem is, on one of the applications (C++ programmed) I...more >>

Hi, I am new to the mysteries of SQLDMO. I have written a program whereby the user can select which SQL server to connect to on the Network and this works fine. I am using the SQLDMO.Application.ListAvailableSQLServers routine and this works fine. However, the Server on the users machi...more >>

Hi guys! i want to create one cursor in the t-sql. the problem is i want to use stored procedure instead of select command in cursor. can anyone tell me how can i use stored procedure's o/p to create cursor? i'm using sql 2000 and .net 2.0 thanks, Lucky ...more >>

Relationships between tables disappear without explanation in the database diagram using SQL Server 2005. Many thanks for any thoughts/questions on the topic! ...more >>

Hi guys. I have a huge database file. When I run sp_spaceused this are the results: db_size 1337,31 Mb unallocated 14,62 Mb reserved 1088456 Kb data 258992 Kb index_si...more >>

Hello, Since SQL Server has no sequence generator, I wrote my own. (I claim no ownership of it as it is closely modeled after earlier discussions on this topic.) I have included the sql statements below. While it works independently on its own, It seems to lock in multi-user environments ...more >>

Hi. I have read lots, but obviously not the right stuff. A reference pointer would be fine, or an answer. I in fact got an oracle solution that I am still researching, but was wondering about either a generic or an ms sql server solution? I'd like to use sql to find out: given a metad...more >>

Hello folks, Old programmer learning new tricks. I think similar issues have been posted, but I would like to ask some help with the following code... select [t1.*],[t2.userid] as [userid2],[t2.approved],[t2.type] from [tblMembers] as t1 left outer join [tblProfiles] as t2 on [t1....more >>

Hello, I'm trying to do a join based on the following tables: Person(person_id,person_name) Grade(grade_id,grade_person_id,grade_score) The data looks like this: Person: 1,John 2,Dave Grade: 1,1,80 2,1,90 3,2,60 4,2,70 I'd like a query that returns the each persons name alon...more >>

IPB WARNING [2] mysql_connect() [function.mysql-connect]: Too many connections (Line: 131 of /ips_kernel/class_db_mysql.php) There appears to be an error with the database. You can try to refresh the page by clicking here. Error Returned SQL error: Too many connections SQL error co...more >>

Hi Folks, SQL Server 2000 SP3 on Windows 2000. I have a database on which I ran the command : dbcc dbreindex ('tablename') go for all tables in the database. Then I compared the dbcc showcontig with all_index output from before and after the reindex and on the largest table in the da...more >>

In the login properties on the Database Access tab, a user's name says dbo instead of his name. I do not want him to have dbo permissions. I cannot drop the db_owner permissions that he has on the database because I get the error "Error 15405: Cannot use the reserved user or role name 'dbo'."...more >>

hi, we were doing something and began to wonder which jobs/dts were affecting a certain table (we use SQL 2000)... is there anyway to check this? and have the features for such dependency analysis been added for SQL 2005? ...more >>

Hi We are planning to move over to SQL Server 2005 in near future. At the moment Website is on a seperate server then the Database. OS for both the server is Window 2003 and currently our data is on SQL Server 2000(on which everything works fine). Part of the testing process we tried to c...more >>

My MS-SQL 2000 Database have 50 more Stored Procedure . How to FAST and EASY ENCRYPTION ALL Stored Procedure in my MS-SQL Database? ...more >>

Hi, I'm using Sybase driver under Linux and I'm trying to connect to MSSQL server 2000. But unfortunately connection fails. In Event Log on my Win 2k3 SBS I'm getting the following error message: Error: 17832, Severity: 20, State: 7 Connection opened but invalid login packet(s) sent. Conn...more >>

Hi, I have a problem, I have a table with a text type column and a nvarchar(2000) type column on my MS SQL 2000 Server. I know that the longest text in the text field is 1000 chars. I want to copy the content the content of the text field into the nvarchar field. I tried convert and cas...more >>

Hi All, Quick question, I have always heard it best practice to check for exist, if so, drop, then create the proc. I just wanted to know why that's a best practice. I am trying to put that theory in place at my work, but they are asking for a good reason to do this before actually implementi...more >>

Itemlookup table Field names : index_id (primary key), itemno, description. It has a child table, which is ItemPriceHistory table The relationship to the child table is one (parent table)-to-many (child table). - It is possible to have no child record for some rows in the parent table. ItemP...more >>

how to convert number to string in sqlserver eg:- 10 -> ten display *** Sent via Developersdex http://www.developersdex.com ***...more >>

I am trying to generate some datasets with some queries... With a given series information, it should return PART_NOs that has STD = 1 and a unique price at that particular 'START', and keeping the 'TYPE' in consideration... DB examples below: Main DB ID PART_NO SERIES STD 1 A-1 A 1...more >>

This has got to be easier than I am making it out to be. I have a query that calls on two tables linked by unique ids. I would like to have the previous outing's # of laps brought into the current outing. An example of what the view follows SELECT TOP 100 PERCENT [Main Outing].OutingNumber...more >>