Hi, How do I automate the successful / error working of replication - both transactional as well as merge. Is there any system tables based on which i can do a join? Appreciate if someone can provide a query... regards. bharath ...more >>

Hi We are facing a problem with SQL Server 7.0 Locks The error code is 1204 We have Java components which has a collection of Java DB objects. These objects are iterated and their values (using SQL statements. The statements are not in a Transaction)are inserted into a table say A, later based o...more >>

Hi All Anyone know how to have SQL send mail based on a trigger in html format? I changed the SQL profile to send mail in html format and if I send it from outlook on the server it comes out in html but if SQL sends out a mail notification, then it is in plain text. Thanks in advance. J...more >>

Greetings al Any feedback on 64-bit SQL Server? Is anyone using it? Any positive results or problems experienced I read in the BOL that DTS componenets are not included in the current release. I see this as a major hurdle to overcome - yes packages can be run from a 32-bit server, but this would...more >>

Hi, Is it possible to script out replication totally? I know that we can script out msdb jobs... but what about other replication settings thathappen in individual databases? The idea is to use these scripts to reconfigure replication in case of crash recovery......more >>

Is it possible to encrypt a database so that clients may not view the table structure, relationships,triggers, functions, etc.? Objective is to protect the back-end design from being exposed....more >>

I have been trying to get replication to work and have been having nothing but problems. I have a bunch of jobs set up in my EM and they all have red circles with an X through it ( I assume this is because they all failed). I have been trying to set up the publisher and distributer on the ...more >>

...more >>

Is there a way to find out how much virtual memory is used up by SQL server ? ...more >>

Hi I created an account to run MS SQL services and give logon locally and log on as service permission. Installation was successful with this service account. After a few hours later, SQL Agent service hang and cannot restart. Error message is applicaion fail to initialize. Therefore MS...more >>

When using ROUND(104.6146,2) - it comes out 104.61 (???) When using ROUND(104.6146,3) - it comes out 104.615 When using ROUND(104.615,2) - it comes out 104.62 Same behavior in EXCEL with currency formatting and changing decimal values from 2 to 3. This seems inconsistent to me. The first ...more >>

Hi I've installed Sql server 2000 in server station and now I want help me for following quations? 1 - as I studied Microsoft site , I found 3 service pack for it,is that right? 2 - how should I install SP1,SP2,Sp3? (I heared it's neccessary to uninstall SQL Server 2000 and then install i...more >>

Hi Sorry if this seems dumb, i have upgraded to sql 2000 and am having a great time so far, but I have a little problem. In my office only 5 people have email so we are using a simple email server (workgroupmail) is support imap,pop and all the other usuals. my question is how do I se...more >>

Am i right in saying that the updated SP3 Books online is not bundled in the SP3a service pack ? ...more >>

Hi all I have an Sql2k database with SQL Server Sort Order 185 on Code Page 1252 for non-Unicode Data Now customers from latvia needs to use this database concurrently , is it possible to convert the tables to Unicode when it is already running live? Best regards Henrik Hasselblad SYSteam...more >>

Below are the problems I am having with my SQL 7.0 server. The first problem is backup jobs created with the backup wizard and scheduled with the backup wizard fail. The latest problem I discovered is my databases can not be restored. The restore problem is very critical to solve. I ...more >>

Hi All I have 3 datafile & 5 log files for a database, not sure if these LOG files really have any data. I remember somebody saying there is an way to move the data from these 5 LOG files to a single LOG file & deleting the 4. Can somebody help me on how to accomplish this. Thanks ...more >>

In Microsoft Access there is the option to set a field to accept zero length strings. This of course means that an empty text box could be entered into the database without an error occuring. Is there any way I can do this in SQL Server. I know that when developing a front end I could write...more >>

Hi Guys, Do any one of you have any scripts which return the procedure name and number of lines for all procedures in a database. Say I have a server with 1000 stored procedure,I need a script which return: Procedure name Number of lines ------------------- --------...more >>

Is there anyone with some expirience in replicating such large database? Maybe some good link or something like that. I would need trans replication instructions. regards, Dalibor ...more >>

Why do some functions have to have the () and some don't? I understand why you would, if a parameter is necessary. Why do I need the () for user_name, but not for system_user or current_user? As a matter a fact, I would get an error if I used the () for curnent_user and system_user. Wh...more >>

how to change windows 2000 computer name with SQL 2000 Server on it...more >>

Do you know where I can find information on SQL server future sizing method? ...more >>

Yesterday we encountered a problem. Setting a small testmachine (slow disks) filegrowth at 10 % and a databasesize of 1.2 Gbyte. Problem : A simple insert took over 1 minute. Causing a timeout. Took some time, but the growing of the database took some time. Because of the timeout, the exte...more >>

How to migrate all SQL 2000 objects (tables, views, SPs) and users from current SQL server to a new SQL 2000 server in different domain? DO I need to modify DTS packages? Thanks in advance. -Don...more >>

With certain databases on SQL 2000 Servers running SP3 I received an Internet Explorer Script 'unspecified error' on line 307 when attempting to view certain databases's task pad. If anyone knows the cause/resolution to this, could you let me know? Thanks, Dave...more >>

Hi Does anyone know how to go from SQL Server 2000 Enterprise to Standard and restore all of the databases? I've tried restoring the Mater Database, but I am getting the following The backup of the system database on device XXXX cannot be restored because it was created by a different version o...more >>

I am using Microsoft Access to access my database on SQL Server 2000. How to you permanently set ARITHABORT ON forever via the Microsoft Access interface? I am sure this is a very silly question, but I am totally stuck. Regards Neil...more >>

Deos anybody have a rough estimate for how many writes per second a single drive system (hardware mirrored to a second drive) should be able to handle? (ie: Win2000, IIS, apps, SQL, db + log files -- all on one drive) I know that's a slippery question, but I'm just looking for an order of mag...more >>

Hi My company have a huge table (>50M Rows) which is used for OLTP. we want to re-create it into partitioned table and then create a indexed view on partitioned tables. There is no problem to create tables on different filegroup and the view, but fail to create the index on this view. here is th...more >>

I am getting the following error message in the log, event_id 6004. It seems to be coming from vssvx.exe which is something do to do with volume shadow copy although it seems to be some sort of database error, any ideas? Sqllib error: Database IFX is not simple....more >>

I am running on W2K server with Sql Server 7. I am having a lot of problems getting some of my stuff to run. I suspect it has to do with permissions. But in this case I am trying to run the following command from EM as a Job as well as directly from Query Analyzer. BCP pubs..phone_book...more >>

Hi all, My database in mssql2000 sp3a is about 40 GB in size. I want to use filegroups and implement filegroup backup - at the same time - i do not want to compromise on my 'FULL recovery mode' - which means that i would like to have point in time recovery as well. Could any one let me...more >>

hi all, can anybody help me out with a covering index query and say how exactly it helps out in data retreival? thanks, james bond...more >>

Hi all, Could any one of you tell me if there is any difference between dbcc dbreindex and create index with drop_existing option for a table with one clustered index and multiple non clustered indexes..? Also, please let me know what is the best way to reduce fragmentation in tables t...more >>

I'm having a strange problem/bug that I hope you can help me with. (Cross-posting since I'm not sure where exactly this issue belongs) First a little background: - Visual Studio 2003 (Framework version 1.1) and Windows XP on Client PC - Windows 2000 Server with SQL Server 2003 - Solution with...more >>

When I tried to grant a Select permission on a table to a user, it was blocked by any users who were currently reading that table. The grant command in QA issued lock Sch-M (Schema modification) lock. Why is it issued Sch-M lock ? Is it mean I cannot grant permission only any table whil...more >>

Hi is me again, about the deleted data at the SQL table, what if i do not make any backup and i wanna to view the deleted data and if possible i hope there is a way that allow me to recover the data.. can it be done??? It's urgent hope to hear from you thank alot sharon ...more >>

Dear All, I have a problem that I cannot seem to find much info on. I am backing up SQL 2000 Transaction logs onto a network share (NAS). This share is connected to the SQL server by a gigabit switch. When backing up the transactions logs overnight - I find that the SQL server reports errors ...more >>

SAME AS TOPIC,THANKS A LOTS ...more >>

I am getting the following error ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure everytime I try to add a new field to a table in any database on my server. I can do queries, I can add new tables. I just can't edit the structure of an existing one. I am using versio...more >>

Is there a way to change the default faillfactor for a table or its nonclustered indexes without rebuilding it?...more >>

How do you find out the table size for certain patterns in SQL 2K? Through query analyzer? ...more >>

I'm afraid my brain is melting on this one... I've done this before, but cant remember it now... I have three tables: Location, Hotels, PrefHotels Locations: A list of locations that people in my company travel to. Hotels: A list of hotel chains, inc URL etc that we may use PrefHotels: Iden...more >>

We are having response problems. This is on a test machine. But we would still like to examine the problem and prevent the same problem on a production machine. The situation is a simple table (only three columns, which hardly contains data, if the data goes to a few hundred rows the problems s...more >>

Hi there, One of our user had (and still has) the right to post DELETE commands to one of our main tables in the Database. I usually hate when managers has this kind of rights. Generate a lot of trouble. The scene is as following: he deleted some records from a very important table in...more >>

I heva a sproc that looks something like this: CREATE PROCEDURE GetData @Id INT, @Param1 INT OUT, @Param2 INT OUT, @Param3 INT OUT, @Param4 INT OUT, @Param5 INT OUT AS SET @Param1 = (SELECT Value1 FROM MyTable WHERE [Id] = @Id) SET @Param2 = (SELECT Value2 FROM MyTable WHERE [Id] = @Id) ...more >>

hi, I have a T-sql as part of ETL. The code selects all data from table x (with 3 million rows) and populates table y (which already has 1.5 million rows). There are no where conditions no calculations - simple insert into table x (col1,col2,...coln) select col1,col2...coln from table y. ...more >>

hello, I am trying to stick a database in single user mode (SQL7). It says I can't because there is a user in the database. How can I find out who it is, and disconnect them from that that database? Cheers ...more >>

SQLServer 10Client; the number 10 is: - a physical limit of connections (ADODB.Connection)? - a licences limit ? - a PCs limit? - a number of processes limit? - a number of served query and the next queries are queued? Some ideas??? Tnx in advance. Sorry for my bad english... Alfredo. ...more >>