see below for detail layout of table followed by question
table1
guid emp_guid client_guid date
1 99999 a1 02/02/2004
2 99999 c1 02/04/2004
3 88888 c1 02/05/2004
4 88888 c1 02/06/2004...
I have a new SQL 2000 user that I want to have only access to a new view I created. The problem is that this new user is inheriting ALL the Public permissions. I could go into permissions f...
How do I change the "timeout"-s for the various components within Microsoft Jet Engine?
I keep getting 'timeout' exceeded error messages - while proceeding to open Sybase ODBC Tables via MS A...
Table A
Registation_key discharge_dt
1001 7/15/07
1002 6/4/07
1003 7/30/071
Table B
REgistration_key ID end_dt value
1001 879 ...
Hi,
I require JAVA Driver (Pure Java - Type 4 ) to connect to A Cube/OLAP (Microsoft analysis services) and execute MDX Queries.
I would like to know the following 1)Is there any J...
Hello.
I have a table that contains the following details about employees work addresses.
WorkCountry
WorkState
WorkCityPostCode
WorkBuilding
Work Level
We have offices in multipl...
Hi,
It's giving me the following error while I am trying to execute the stored procedure.
Msg 5242, Level 22, State 1, Procedure <procudure_name>, Line 11
An inconsistency was detected ...
I have a situation where one table has a list of products. In that list just the product name and a few other fields that describe the product exist in each line. Another table has a list of m...
I have a query that does some calculations from two tables and I want to up date one of the tables valus from the result of that query. now how do i update the stock table field [quanity in s...
If a query in a batch fails, shouldn't the whole batch fails? Here is my scenario I've got hundred of stored procedures running in a batch so
Begin
Execute stored procedure
Execute stored...
Dear all experts,
I've got the following hardware and software:
IBM 3850 (4 x Quad cores CPU)
8GB Ram
Raid 5
Windows 2003 Enterprise (32 Bit) /SP2
SQL Server 2000 Enterprise (32 Bit)...
Hi,
Can someone help me to solve below mention issues!
Background: I'm using SQLCMD tool to extract data from table and output it to .csv file [comma as a column delimiter]
Everything...
On a weekly basis data is uploaded to Table#1 and Table#1b. Before the data upload, a copy is made of Table#1 and table#1b. After the data upload, the original Table#1 and Table#1b are referre...
Hi everyone!
I pass a few time searching to the internet how mssql dealing with space in field, and i found some non official information regarding space in "char" and "vchar". And also t...
--table
CREATE TABLE [dbo].[Table_1](
[ID] [int] NULL,
[A1] [numeric](18, 5) NULL,
[A2] [numeric](18, 5) NULL,
[A3] [numeric](18, 5) NULL,
[A4] [numeric](18, 5) NULL,
[A5] [numeri...
I have had this server up now for several years. Now having a problem with some of my remote servers. The Replication Agent if reporting.
Replication Failed: The merge process could not a...
I have a table containing names of User Defined Functions. I need to run a SELECT statement on this table, which returns the result of each function as one of the columns.
Something like
...
Hi all.
I have a report (front end is access 2003 report, backend is SQL Server 2000)that one of my users is having issues with a specific report stating he does not have the privileges to ...
Hi,
I would like to have a copy of database A, and then restore it to another database B on the same server. I tried to do backup and restore but it gives me error message saying that this ...
I'm in the middle of migrating a server from SBS 2000 to 2003. There's only 8 users and we didin't need to keep domain names so I've done most of it manually and only just found out about Swin...
How do you move a SQL 2005 database back to a SQL 2000 machine?
All we need to do is move the tables and stored procedures, and of course all the indexes & constraints. We don't use any SQL...
I have a SQL db (2000 R4) that periodically under peak usage locks the tables so they can't be written to. It lasts for about 10 to 150 seconds. During this time, the cpu is at low utilizati...
Hi,
My Database is Sql-Server.
To centralize the logic of joins i made up a view. When i am using this view my sp. is taking much more time.
It seems the where condition on view is getti...
I've been researching this situation for about a week, so any help that anyone could provide would be very much appreciated because I am beyond frustrated. Before last week I knew absolutely ...
I am installing a product that uses MSDE SQL 2000 desktop engine on Win2K Server, terminal server edition. The first install failed due to lack of harddrive space on C: drive. I corrected it w...
