Using MS SQL Server

Insert/Update with dynamic database name
Hi My problem is as follows: I need to transmit data between two databases on the same server, but I have to use dynamic database names (they must be configurable). For example I need to achive sth like that: insert into [database1].[dbo].[table1] (select columns from [table2]) when database1 is not kn... 25 Jan 2006 17:27

Joining tables in different databases
Hi I'm working on an ASP project where the clients want to be able to effectively perform SELECT queries joining tables from two different databases (located on the same SQL-Server). Does this involve creating virtual tables that link to another database, or am I completely on the wrong track? Any hints as ... 26 Jan 2006 17:31

Help
I have a database whose transaction log has swelled to 70 Gig Overnight. Disk space free is only 30 gig therefore it won't let me back it up. Any advice gratefully received. ... 7 Jan 2006 15:01

Deadlock on Update using temp table
I sometimes get the following error from an update statement in a stored procedure: Transaction (Process ID 62) was deadlocked on thread | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. The isolation level is READ UNCOMMITTED and there are... 30 Dec 2005 02:37

How to schedule a stored procedure
I'm new to sql server programing. Please help me to scedule a stored procedure to run every hour. Thnak you all. ... 22 Dec 2005 10:28

operand type clash
I have a stored procedure that works fine on SQL Server 2000 or 2005, but when run on an machine running MSDE, I get the Operand type clash, int is incompatible with text data type error. The data type is actually text and text is the type of data being passed. Any parameters not being used are defaulted to null.... 21 Dec 2005 18:19

PAGEIOLATCH is a lead blocker
Hi Guru, After spening quite sometimes to watch my box, I've seen PAGEIOLATCH is a lead blocker in my SQL Server 2000 server. Below is the detailed: SPID lastwaittype waitresource blocked status cmd 57 LCK_M_S KEY: 7:963690681:8 65 sleeping execute 65 PAGEIOLATCH_SH 7:1:217904 0 sleeping select I thought,... 30 Nov 2005 07:15

Using the copy database wizard
Hi to all, I'm trying to use the copy database wizard to copy a database from the 2000 version to the 2005 version of sql server. I choose not to copy logins so I expect to find a database with only an administrative login o none at all. When I start the created package it throws an error saying: errorCode=-107... 24 Nov 2005 17:57

Requirement : IBM Process Choreographer
One of our Direct Client is looking for following consultant please find the requirement details as follows. IBM Process Choreographer Location : Jersy City,NJ Duration : Longterm Startdate : ASAP. Required Skills: IBM Process Choreographer experience, websphere and java programming. Project is underway a... 18 Nov 2005 17:52

OpenDataSource trouble with Advantage SQL
Hi folks. I'm trying to connect to a Medisoft Advantage SQL db through SQL Server using OpenDataSource or OpenRowSet. I have general connections to the db working fine, but not with OpenDataSource or OpenRowSet. I've tried variations on: select * from OpenDataSource( 'Advantage OLE DB Provider', 'Data Sou... 5 Nov 2005 19:52