Hello, I am not familiar with SQL at all any good sites on install I understand that best practice is to use two aprtitions one foe logs and one for data. I have it as part of a SBS package. Many thanks Nic ...more >>

Hi guys, I really have a strange problem that I have no where to look for answer. I have a DTS that generate a text file with data queries from sql server 2K then stores it in a local drive. The last step of that DTS is to copy that file to a network drive using a batch file called by the Proce...more >>

I want to do something like this in a stored proc: ------ Create Procedure dbo.GetPatients @PatientIdList varchar(200) -- comma separated list of PatientIDs As Select * From Patients Where PatientId In (@PatientIdList) ------ I know the above won't work, but of course what ...more >>

Hi All Im unsure of how to use vb to read the results of my stored procedure. Ive included the stored procedure at the end of this message for reference. Basically the stored procedure will first of all construct a select string based on the your computer name and perform this select on a tabl...more >>

DB is 150GB and I cannot take it offline long enough to apply logs to a back up. I am moving from one sub storage system to another. Any mirroring ideas? Thanks...more >>

Hi all, I’m a bit new to this so hope this is not too obvious! I am running a query like so (simplified form) Select Cus_no, Cust_Name, course_id Where Cust_id = 2 From course table However not all the Cust_Id’s have been entered therefore so using a two filters out the information I migh...more >>

I need to insert a row into a table in SQL Server 2000. The primary key for the row is an identity type, so it auto-numbers for me without needing to put in the value in the insert statement. My problem, is that after i insert a row, i need to insert another row in a different table that refe...more >>

The database is configured for single publisher, many subscribers, merge replication. The maintenance plan started to fail a couple of months ago and the database would not get backed up. After clearing all the locks, I am able to backup the database manually. The locks return again and I'm n...more >>

I'm having much difficulty figuring out how to write the following query. Please help! I have this table: Event EventId int Primary Key PatientId int SeverityLevel int What I want returned in my query is a list of all (distinct) PatientIds appearing in Event, wi...more >>

Without the Client Network Utility that is available in the full blown MS SQL Server is there a way to find out what port the MSDE is running on? Short and sweet, thats all I need TIA ...more >>

Please could someone explain to me the differences between a stored procedure and a view. The reason for this question is I have two almost identical ASP pages. Both get the same results but one uses a stored procedure and one uses a view. If the query returns no results the 'view page' genera...more >>

Hi - I can get this to work in SQL Server - but when also trying to make the application compatible with MS Access I get an error: Select tblfaqnetgroups.group_name from tblfaqnetroles Inner Join tblfaqnetgroups ON tblfaqnetroles.group_id = tblfaqnetgroups.group_id Inner Join tblaccess ON tbl...more >>

Hello All, I am looking at the performance of our production database. It is 40gb, and growing reasonably fast. It is placed in one file group on a RAID-5 array. The array is made up of 20 (or so) 9gb disks. The data, the indexes and the transaction log are all on the "one logical disk". M...more >>

I know other people have posted stuff like this before, but I am still to see a definitive answer. I have created a table in Enterprise manager called tblUsers. I later added a column in EM and saved the change. I then noticed I had misnamed the column, so I renamed and when I tried to save the ...more >>

Hello! We are developping a project using MS-SQLServer 7 and we need a process for the synchronization of 3 tables together. Inserts and updates in the table A should immediately and automatically occur on table C, and updates on table C should also automatically occur on table B. We think t...more >>

I currently have a sql statement that works great. I want to convert it to a stored procedure so I can generate results from a webpage. Below is the stored procedure that is working fine. select SUBSTRING(tblPersonnel.SSN_SM,6,9) AS L4, SIDPERS_PERS_UNIT_TBL.UNAME, SIDPERS_PERS_UNIT_TBL.AD...more >>

Hi! Happy New Year! I'm having windows authetication connection problem. Although I can see all the servers by using SQL Server authentication conncection, I can see only some of the SQL family servers by using windows authentication connection. I checked the servers' properties of that I can a...more >>

is there a setting that will ebnable uniform extent allocation upon creation of index/table by default ? if there isn't any default setting can you code it in? thanks, Doron...more >>

Hello, Is it possible to install "SQL 2000 Server 1CPU" on a dual processor machine and make SQL use only one CPU? Thanx ...more >>

Hello, I am fairly new at stored procedures. I have created some that will go through a table and return a start date and an end date that is dependent upon the fiscal period you want, but I then need to use those dates in another stored procedure to retrieve the information I need. My stor...more >>

Hi, I'm using "select [name] from sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1" to get all user-defined tables(about 17000 tables) and found out there are tables missing in sysobjects. How can I refresh/rebuild sysobjects table? is there a better way to get a list of user-defined ta...more >>

Hi, I made a DTS-package and it works when I execute it manually, but when it is run by the SQL Server Agent, it fails. I have use the guide to create a maintenance plan. That doesn't work so good either. It runs Optimizations, but not integrity checks or backups (probably because integrity...more >>

I just upgraded from SQL 7.0 to 2000. I know I have an error with the CAST and CONVERT functions I used in some views. Anyway, is there a sp I can run that will run all my views and give me back a list of those which have an error instead of going through each view one by one? Thanks. Sher...more >>

Does anyone know what the following instance name means? I know the two servers this is running on is a NAS server running Dell PowerVault. I am having to do some maintenance on a network I am unfamiliar with and am just trying to figure a few things out and can find no docs on this. Thanks...more >>

Hi I have a dynamically constructed sql query that I want to execute, e.g. exec('select * from ' + @tablename) (1) Can I suppress the output somehow if this returns no values? (2) Can I use the result of this query in another query somehow? e.g. select (3) Can I control the size of the co...more >>

MS-SQL 2000 Is there any way to run a SQL script against MSDE other than with OSQL? = (No Enterprise manager or Query Analyzer) TIA --=20 Tim Morrison -------------------------------------------------------------------------= ------- Vehicle Web Studio - The easiest way to create a...more >>

I've come up with this issue in several apps now. There are things that, from one perspective, are all handled the same, so it would be desirable that they all be handled in the same table with some field as a type specification. From other perspective of foreign key relationships, however, they...more >>

Hi, Just wonder why PRINT CAST(0.0573542567654 AS float) will give the rounded reult 0.0573543 rather than the original number? "float" should be 'big' enough to hold numbers that have even more decimal places. How come it round up at the 7 decimal place? since I need to do so...more >>

Data: PROJ PLAN TOTTIME UNIT A P1 10 DAY A P2 10 HOUR A P3 1 MONTH WHEN I'M DOING GROUP BY ON PROJ AND CALCULATING TOTTIME IT CONSIDER ONE OF THE UNIT I.E. DAY, HOUR, MONTH I WANT TO SUMUP ALL WITH HAVING UNIT CALCULATION ALSO. ...more >>

Hai friends Could u pleas give me some noites on replication . I worked out thru wizards but not succeded. With thanks Raghu...more >>

I asked this question elsewhere, but I am still hoping for some clue. I can't start SQL server because the login doesn't work on my home WinXP computer. This is what I did: Downloaded GER_SQLEVAL from <http://download.microsoft.com/> (274MB) It installed nicely and autostarts "SQL Server Se...more >>

Hejsa, Jeg har lavet en DTS-package og den virker når jeg kører den pr. håndkraft, men når den køres af SQL Server Agenten, fejler den. Det skal også lige siges at jeg har brugt guiden til at oprette en "standard" vedligeholdelse/backup rutine. Den går heller ikke så godt. Den kører optimiz...more >>

I thought this problem would go away over the Christmas holiday, but of course it did not. I'm trying to write a stored procedure incorporating wildcards, so I can search for variations. Example, if name 'Smith' is submitted, sproc should retrieve all records containing 'John Smith', 'Zenia Smit...more >>

Hi Oracle 8.1.7.4 Hp Unix 11 Application run peoplesoft Logon_time from v$session shows Friday Jan 3.The database was halted on Saturday Jan 4. What is logon_time supposed to represent.All inquiries so far does not indicate Thanks for your input Vincento...more >>

hi, i am using MSDE 2000 with Visual Studio.Net 2003. I am not able to connect to the sql server with Ado.net. When i test with a odbc data source, the test connection works fine. I am using Windows authentication and have granted login and database access to my username also. I have also ...more >>

Hi, My application needs to calculate the sort order of an index key (whether the index key is descending or ascending). The user may connect to MS7 or MS2K servers. As far as I know, the descending indices are supported in version 8 i.e SQL 2000. In MS2K, I can get the index key informatio...more >>

Hi Is it possible to force row level locking in one or more tables in some database. We have some problems when SQL Server decides to choose page- or table-level locking. We are using SQL Server 2000. Best regards Aarno...more >>

Hi All, Can multiple updates on one table using single query generate deadlock ? For example, at the same time, there are 2 users run 2 queries as follows : User1 runs : update tab1 set tab1.v = tab1.v + 1 from tab1 inner join tab2 on tab1.no = tab2.no User2 runs : update tab1 set t...more >>

please help to select these rows from these tables my tables are table1 table1Id groupId table2id price 1 1 1 10 2 1 3 1000 3 1 4 500 4 2 1 5 5 2 3 1000 6 2...more >>

Hi All Im trying to use the code at the bottom of this message inside my stored procedure and when i execute the procedure in query analyzer i get the following error: Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'H'. This error happens a few times and im pretty sure it...more >>

Hi, We have a problem when using the dbuse function, with a database that include a space in its name. Any suggestions ??? I try to wrape it with 'db name' - got 000170 015 Line 1: Incorrect syntax near And with "db name" and got the same. Thanks Eyal...more >>

Hi all, I'm working on the schema for a database that must represent data about stock & bond funds over time. My connundrum is that, for any of several dimension fields, including the fund name itself, the dimension may be represented in different ways over time, and may split or combine from...more >>

I'm looking for an efficient t-sql script to loop through all user tables in a db and determine/print the value of each row having a datetime field (including cases where there are multiple datetime fields per row) Help greatly appreciated.....more >>

I just bought a copy of SQL Server 2000 (with service pack 3a) that I intended to install and run on XP Pro. My concern is that the requirements list on the box do not include XP or XP Pro. Will SQL Server 2000 developer edition run on XP Pro? ...more >>

what is the syntax to join a table with the result of antoher query. For example i have two tables Create Table Customers ( CustomerID int, LastPaymentDate Datetime ) Create Table Payments ( PaymentID int, CustomerID int, PaymentDate Datetime ) What query will bring me the custome...more >>

Hello, I am importing a file using BCP, with a format file. It is a fixed-width file, which I am importing into a table that has a column for each field in the file. The columns in my import table are all defined as CHAR. I use it as a staging area to check the data (are dates formatted corre...more >>

In Ms SQL 2000, I want to be able to share my database with another user but I only want them to be able to look at the database and not be able to change anything. Does anyone know how I go about doing this? ...more >>

I am working on a personal project and am drawing a complete blank (too much celebrating last night?) on the SQL term that is used to eliminate multiples of like data when it is returned from the database. ie, instead of .... red blue red green it would return ... red blue green ...more >>

I have 2 installations: 1. W2k with MS SQL 2000 sp2. 2. W2003 with MS SQL sp3. There are two databases in all instalations: "maindb" and "userdb". The table with data is in maindb. In the 1'st installation I restict user access to all data in table in this way: - create user's login a...more >>

Hi I'm hoping that some could point me in the right direction for "best practice" in: 1) securely backing up a complete sql7 and 2000 server containing many databases. 2) backing up an individual database 3) Securing the transaction on the hour as a mile stone to return to in the even...more >>

Hi, If I have a database with collation Sequence X and I change the collation sequence of database to Collation Sequence Y , do I have to migrate the data of tables with collation Sequence X to collation Sequence Y or SQl server takes care of migrating the data internally. Thanks in advance...more >>

Hi, I want to create a DTS package programatically (preferably in C#.net),which will copy all my tables from a oracle database to my sql-server database. Can anybody help me doing this??? Thanks Patnayak...more >>

Hi, WITH SQL SERVER QUETY, I have output like PRJ item qty ================= P1 I1 10 P1 I1 20 P1 I2 10 P2 I2 10 P2 I3 10 ================ I WANT TO MANIPULATE IT LIKE THIS PRJ item qty ================= P1 I1 30 P1 I2 1...more >>