Hello to all, I have say two databases A and B. A database has tables a1 and a2. B database has a table b1. My question is Can i write a trigger for the table b1, which access the fields from the table a1 and a2? Simply, can i write a trigger which access data from other databases? ...more >>

Hello all I've got this tricky situation that I would like to solve in SQL, but don't know how to do. This is the table: Id = 3, VId = 2, Time1 = 10:00, Time2 = 14:00 Id = 4, VId = 2, Time1 = 16:00, Time2 = 17:00 Id = 5, VId = 2, Time1 = 18:00, Time2 = 19:00 Id = 6, VId = 2, Time1 = 20:...more >>

Hi All I have just upgraded to SQL2005 and found an annoying problem. Whenever I add a new view or amend an existing one (created in SQL 2000 Enterprise Manager) it inserts TOP 100 Percent into the SQL query. Even if I delete the clause from the SQL query it puts it straight back in again. ...more >>

Hi all, I have the following table to log events as they happen: EventID UserID Event Time ====== ===== ==== ==== 1 User 1 Login 08:00:00 2 User 1 Logout 11:00:00 3 User 1 Login 13:00:00 4 User 1 Logout 1...more >>

I am trying to port a database from SQL Server 2005 Express to SQL Server 2005 Standard. I detached my database from the SQL Sever 2005 Express instance and attached it to the SQL Server 2005 Standard instance. Whenever I do a select on tables in the database I have no problem. However if I att...more >>

Dear Community, We have a problem with null-Bytes in varchar-Columns, which are not handled correctly in our application. Therefor we try to filter them out using the Transact-SQL REPLACE function. The Problem was, that the REPLACE-function didn't behave the way we expected. Following ...more >>

Guys, Hopefully someone can help. We have a monitoring program that has threads which start and stop monitoring at various times. There are two tables: THREADLIFECYCLE unique_id start_time (always populated) end_time (not populated until the thread ends) MONITORRESULTS unique...more >>

Hi all, I have a SQL Server 2000 database that is using the Full recovery model. The database is purely receiving inserts (and plenty of them) with maybe some view/table creation for reporting. In this state I would expect the log to grow ad infinitum but it gets to about 32% used and then ...more >>

Hi I have a character field, varchar(60), and I want to replace only a part of it, a set substring which is always in the same set positions. Does anyone have an Sql statement or algorithm/sp that could do that with one call or run ? Thanks David ...more >>

Okay, given my newness to SQL, and the complexity of this query, I thought I'd run this by you for your opinion: SELECT DISTINCT a.WeekEnding, c.lastdate, c.numlate, b.totaldate FROM Accomplishment a LEFT OUTER JOIN (SELECT weekending, COUNT(weeke...more >>

KR Feb 6, 1:48 pm show options Newsgroups: microsoft.public.access.forms From: "KR" <kra...@bastyr.edu> - Find messages by this author Date: 6 Feb 2006 13:48:00 -0800 Subject: Extract Number from Fields - SQL Reply | Reply to Author | Forward | Print | Individual Message | Show original...more >>

hi, I have a problem asked by one of my senior person and finding the answer . What is the step by step procedure for tune a large sql query. OR how do we tune a large SQL query with somany joins ...more >>

Problem When Remote Desktop to my main office machine, and when trying to connect to SQL Express, I was becoming increasingly frustrated with the following error: Error: 'Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The con...more >>

Question, I have a dedicated SQL Server box, just the OS and SQL Server, and was curious as to where best to setup DB. Drive Size What Drive1 73GB OS & SQL Server Software Drive2 73GB mirror of Drive 2 Drive3 300GB Actual DBs Drive4 300GB mirror of Drive 3 I...more >>

I installed sql server on my PC, and when I look at the Programs I do find sql server, but when I click on that I get "configuration tools". I don't see anything that says "enterprise manager" for instance. How can I find it so I can make a shortcut to it? Thanks ...more >>

Hi. create table joe(c1 integer not null, c2 integer not null) Two sessions: Session 1: BEGIN TRAN insert into joe (c1,c2) values (1,2) Session 2: BEGIN TRAN insert into joe (c1,c2) values (3,4) Session 1: select * from joe Session 2: select * from joe One of the session...more >>

I have a couple of complex stored procedures that work well and quickly once they have compiled. The problem I am running into is that every once in a while they want to refresh thier execution plans, and when that happens it takes about 1 minute and 30 seconds for them to rebuild, well of cour...more >>

Hi. I'm a casual sql user. I have found a situation where I need to convert an oracle statement to tsql, one I can just fire off in any sql tool against an ms sql server database. I studied the exists statement and I think I understand it somewhat, however I was not sure how to get it quite r...more >>

Dear Folks, First time here. Have just installed a 120-day evaluation copy of MSSQL 2000. In the 'blur' and confusion of installing this on my WinXP Laptop, I forgot to record the password. Finally, I got into the 'logins' tab on the Enterprise Manager, and modified the...more >>

What are the significant differences between sql server and access as both are database software ? I'm trying to figure out which one to use in my office. Thanks Rgds Daniel ...more >>

I am quite new to MS SQL, and I want to read rows from a todo table, and when a row has been processed, I want to delete that row. Ages ago in MySQL I would probably have locked the table, select, process a row, delete a row, unlock the table. I have been reading through the documentation ...more >>

Hello: In my SQL Server databases I have complex related tables and views. There is any tool which allow you to see (print) this complex hierarchy of views and tables as hierarchical tree? Thanks, GB ...more >>

hi, Here's the scenario 1) I am running a DTS job to fetch some rows from Oracle 2) The job populates the Table A as step 1 3) Then it fires a update statement which updates the rows in Table B. Here's the statement UPDATE Table B SET time = case when (select median from Table A where s...more >>

Hello, I am writing a function that uses two table variables. The structures of both are shown here: DECLARE @workdates TABLE ( conflict CHAR(1), workdate SMALLDATETIME ) DECLARE @existing TABLE ( workdate SMALLDATETIME ) I need to do an update on the first table: U...more >>

Hi SQL gurus, I have a table structure question. I will have a table 'Models' that has one to many 'incomes' and one to many 'costs'. These 2 entities have exactly the same structure, which is 7 smallmoney and a name. Is it better to create a table 'Incomes' and a table 'Costs', with both t...more >>

Brief background: We are using SQL Server 2000, and one of the tables stores user sessions details (each time our users logs into our system we insert a new record in the session table, and each time user logs out from our system we insert another record in the same table). SESSION_ID is the ...more >>

I have data tables that include ZIP code, as char(5). The values look like integers, but they are padded with leading zeroes to fill out 5 characters, '00234'. There are SPs to look up data, with @Zip char(5) among the parameters. Some users call these with integer values, @Zip = 234, and SQL...more >>

We are looking for strong transactional sql engineers in the dallas area.. anyone have any ideas where we can find folks. The papers & regular job boards weren't working... brian brian@topdog-inc.com ...more >>

Hello, (sorry for my English...) Could you help me please with installing SQL Servera 2005 Express Edition. I downloaded files: SQLEXPR.EXE - Microsoft SQL Server 2005 Express Edition SSEUtilSetup.EXE - SQL Server Express Utility SqlServer2K5_BOL_Dec2005.msi - Books Online December 2005 a...more >>

I'm trying to audit all the database activities using Server-side trace in SQL Server 2000. Basically I need to get the login information (login Id, Login time etc) along with the name of the database.Can some one suggest a way to do that? Thanks in advance. J ...more >>

I need to strip some puntcuation from any field in a given table. I'd rather like to avoid using the replace () for each field in the table. Anyone have a nifty way do this? Is there a special name that I can use in the replace that means the entire row? (other than syntax, something like REPL...more >>

Does Session term exist in SQL Server? If yes, when it creates, how can monitor it. And where does its information store? Thanks alot ...more >>

We currently run an Oracle 8i db for Oracle Applications 10.7. We are considering moving away from this whole infrastructure to Windows 2003 Server and SQL Server 2005 with a new ERP system. Currently, we have an Oracle DBA under contract who performs all of the maintenance required, plus doe...more >>

Hi, whenever the underlying query being called by EXEC in the following has an empty result set I get the following error -- Invalid Data for 'Numeric' when EXEC returns empty row. However if I call the query without using REPLACE (which I'm forced to do, because openquery does not allow variabl...more >>

I have a trigger on UPDATE on a table. I'm running some maintenance UPDATE and DELETE queries which I want the trigger to ignore but at the same time I want other UPDATE queries that other users might be running to keep triggering the trigger. Is there a SET statement perhaps that I could set ...more >>

Hi If i use select * from table...i get the following 10 Energy Energy Energy Equipment & Services Oil & Gas Drilling 10101010 10 Energy Energy Energy Equipment & Services Oil & Gas Equipment & Svcs 10101020 10 Energy Energy Oil & Gas Integrat...more >>

Hi all, My SP looks like: CREATE PROCEDURE dbo.SPRazduznicaZM (@Datum datetime, @Nalog smallint) AS SELECT FCNabavneCijeneZM.RobnoObjekat, dbo.TBLNaloziProizvodnjeOs.NProId, dbo.TBLNaloziProizvodnjeOs.NProZalihe AS Zalihe, dbo.TBLNaloziProizvodnjeOs.NProPT AS P...more >>

how to restrict data insertion upto 50 MB in a table? ...more >>

Build a job that imports a new version of MTL_PARAMETERS at 6pm each day. It should keep trying to import the table until it is successful. Care should be taken to avoid data model downtime. ...more >>