Hello All We intend to replicate a database in order to have it as a near immediate standby in case of the failure of the main server. Is this the best solution for disaster recovery? We are currently testing our replication plan. When we set up the subscriber, a snapshot of the publis...more >>

Hi all, I've got a question concerning synchronization of multiple database clients. Consider a database, accessed by two clients. Is it guarantted, that if client 1 succefully commits a transaction, client 2 _instantly_ sees the changes made by client 1? thx and regards, Stephan P.S....more >>

Is there a function that compares two columns in a row and will return the highest of the two values? Something like: Acct Total_Dollars Collected Total_Dollars_Due 11233 900.00 1000.00 Declare @Value as money set @Value=GetHighest(Total_Dollars_Collected,...more >>

Just curious if anyone has a script to find and delete all indexes created by index tuning wizard, leaving the original indexes untouched. All of the original indexes in this particular database are preceded with IX_, whereas those created by ITW are the table name followed by a number. I...more >>

I am trying to come up with a stored procedure to grant all users db_owner role (rather than have to manually check the users each time) Thanks in advance for your help TY...more >>

Hello All, I can't seem to find an answer to this anywhere else: I need to convert a datestamp to the following format: MMDDYYYY. I've found solutions to convert it to many different kids of formats, but not one that allows me to enter the positions of the month, day and year. Anyone have a...more >>

Is there a way to use PreparedStatements (or bind variables) with SQL statements that have a variable number of arguments. For example, I have an array of IDs for employees of a certain type and I want to have a PreparedStatement retrieve all of them in a single SQL call. SELECT FROM employees...more >>

Question 1 3 GHZ CPU (Intel pentium 4) single cpu + 2 GB Memory + SCSI HDD Database size 10 GB - How long will full database backup take if the backup is writing a file to the hard disk (separate hard disk) Question 2 during this full backup are users and application able to access the...more >>

Hi All, Have come across something weird and am after some help. Say i run this query where rec_id is a column of table arlhrl, select * from arlhrl where rec_id >= 14260 This returns to me 2 records with rec_id's of 14260 and 14261 Then I run this query select * from arlhrl wh...more >>

I am using http to access my cube (MS Analysis Server) and there are users who are getting "Query could not be processed. Access is forbidden" intermittently. Can someone help out and let me know what is causing this issue? Some users are not getting this error. ...more >>

I am doing some replication setup in test environment. Will it be possible to use the transaction log from a production server to update the test server? Any reference to any document will also be appreciated. I know I have to restore most recent backup from the production server to the test s...more >>

there are two types of indexes in microsoft sql server a) clustered b) non clustered Question can u create a primary key which is non clustered ? If yes what is the syntax ? Question can u create a compound primary key and if yes what is the syntax ? Please excuse me from asking...more >>

Am MS Access 2000 DB To an SQL SERVER 2000? (without Enterprise manager)...more >>

Can someone please help me write a stored procedure? I run a query (see below) for 50 tables and for every day of the month. I would like a SP which can provide data with results as follows: Srv_Name, DB_Name, Table_Name, Date_Of_Records, Total_Records, Min_SerNumber, Max_SerNumber, Should_Be...more >>

I need to decided between Standard and Enterprise Edition (Cost is a criteria - but its secondary to performance - <!--and I am not paying for it myself-->) The server spec under consideration: Dual Xeon, 1GB RAM, 36GB - RAID 1 (Dell PowerEdge 1850). Application: Windows 2003 Std Serv...more >>

I use datetime condition in sql-query. For example: select something from sometable where date between '06/15/04 00:00:00' and '06/15/04 23:59:59' and result on two synchronized servers is different. In USA server result contains where date equal '06/14/04' only, but Russian server gives...more >>

Since DBlib is no longer the suggested method for connecting back to sql server from an Extended Stored Procedure, has anyone built any extended stored procedures that use other connection methods like OLEDB? Has anyone seen links to any sample extended stored procedures that use something othe...more >>

I am in the process of importing data that is in a text format to the sql server, I want to add couple of fields and insert general data in the fields added, this data is going to be similar to all the records imported. Your help in this regard will be greatly appreciated....more >>

Sorry if this seems a little basic, but I'm putting together an application where large amounts of text will be required in a single record - way more than 8000 characters. What's the normal way of coping with this? Splitting into multiple records each with a max of 8000 chars? Thanks, ...more >>

I am just beginning development of a new app and I need a little advice on the best way to go about doing something. The app is a project management tool for a construction company. Users in the field will need to do remote updates both receiving and submitting data back to the main office. I ...more >>

I am looking for information, books, websites, etc that will help me figure out the following things in MSSQL and Oracle: 1. Optimizing the database configuration itself. 2. Optimal table and index design. 3. Optimizing SQL statement lookups. 4. Anything else that might help to speed up our d...more >>

I have ... CREATE PROC InvoiceDeleteExample2 ( @InvoiceList1 VARCHAR(255), @InvoiceList2 VARCHAR(255) = '', ... @InvoiceListN VARCHAR(255) = '' ) AS .... GO I would like.... CREATE PROC InvoiceDeleteExample2 ( SELECT * FROM table; ) AS .... GO I hope help... thx ...more >>

If i create a new SQL login and give that login db ownership for a test db. When that user adds my SQL Server through his own SQL EM, why does he/she also see all other objects (databases, sql security logins, DTS, ...)? Is there a way for the user to open SQL EM but only see his/her db and no...more >>

I need to change the name of the SQL Server on my development machine. My client's server name is "Server1". My development server name is "MachineName1\ServerTest". I am writing a Visual Basic application. Everything is working great on my development system, but I have to go in a change t...more >>

Can a new field be added to a table that already exists. Thanks in advance. ...more >>

I did some search and didn't find anything about whether Yokon will support sequence object. Appreciate it if you can reply with some resources. Thanks, James...more >>

Hello, In my MS SQL SERVER database i have an column with datatype image. Some records do have data in this column, some others don't. When i look at this table in Enterprise Manager then i see in every field '<image>' so no way to see directly wheter a filed has data or not. Is there a way to...more >>

Hi, I have an Access application with linked tables via ODBC to MSSQL server 2000. Having a weird problem, probably something i've done while not being aware of (kinda newbie). the last 20 records (and growing)of a specific table are locked - cant change them - ("another user is editing th...more >>

Hi, I just installed mySQL on MS NT 4.0 workstation and applied Service Pack 6a. When trying to add a new user using the Control Center I get an info message that say that user was added but this is followed by an error message that says: There is no such grant defined for user 'usernam...more >>

I'm working on a project that is being built piece by piece. The first part is in place. I will occasionally need to either change thing within a table (only adding fields) or add stored procedures etc. What is the best way of making these changes to the production database without interfering...more >>

Hello, I'm looking for a little input on this situation. I'm working on an inventory system and was thinking that I'd like to build it similiar to the way a bank keeps track of your funds. If you look at at bank statement, for each line item, you'll normally see at least date/time, descripti...more >>

I am trying to setup replication between 2 databases on the same/one sql server 2000. i like to know if this is possible. i also want to filter out some of the records that are replicating. i know its possible to replicate to another server but i like to know if i can replicate to the same ser...more >>

We have a need to retrieve Sybase data within a MS SQL Server application. We are using SQL Server's linked database feature with the Sybase 12.0 OLE DB driver. It takes 5 minutes to run a query that takes 2 seconds from isql. Any suggestions? Thanks...more >>

As our customers demand that we tighten our IT security in the company, I've been asked to prepare a report quarterly showing, for each user in Active directory, what his effective permissions are for every table in every database that he has permission for on our SQL Server 2000 server. I sear...more >>

Hopeing this is something I can accomplish. I use MS-SQL for close to 100 CMS web servers. Everytime I create a new website I have to create a new database and then use the export from SQL to SQL option and copy all data / SP's / etc... Just no security information. My question is can I automate...more >>

visual studio.net seems to default to single batch mode when running sql scripts. does anyone know how to change this behavior? typical batches will include object existence, drop, and create batches prior to processing. i have attempted removing the graphical plan, using batch separator 'go', a...more >>

Can any one give me brief useful explanations or guide me to a useful resource of what Development Tools component and Profiler are? Is there anything I should be aware of if I want to install Client Connectivity component (don't want to overwrite anything)? Thank you in advance. ...more >>

Hi all, Any advice on writing to MS SQLSERVER from a php page? I have no idea how to even start this! Thanks in advance! Mike...more >>

This is a simple question compared to some of the stuff that gets asked (and answered) here, but sometimes its easy to over look the simpler things. I've been working with databases for a few years now, but have no formal training, so some times you just get on and if it works dont worry about ...more >>

How can I change procedure cache values. Is it possible to change them only for one procedure. If I have a huge procedure and small one I would like to allocate values for both of them accordingly....more >>

We are looking for an ETL library or callable application that would allow us to transfer and transform data between platforms but mainly into a SQL server database. We would be calling this tool from javascript programs. Is there something out there in the midrange price-wise? So far I am fin...more >>

Hi , I have been trying to connect to access database from SQL Server 7.0. This machine is having 7.0 as a default instance and 2000 as a named instance. Also the machine doesn't have access installed and Microsoft.Jet.4.0 is of version SP8 for Windows 2000 The access database is password pr...more >>

Help, I am running a pass through query to oracle from SQL server 2000 as follows; select * from openquery(nbsp, 'select * from FND_FLEX_VALUES') I have run this query through both DTS and the query analyzer and get the foloowing error; Server: Msg 7357, Level 16, State 2, Line 3 Coul...more >>

I'm upsizing an Access database. Got the data converted, working on the front end, converting queries to views, but having trouble converting queries that use logical expressions like the following: SELECT OrderId, Sum((BackOrderQtyAvailable>0)*-1) AS ReadyBackOrderItems FROM OrderDetails ...more >>