Programming SQL

Error restoring a mssql database
Hi I'm having this error when I restore a backup on a Windows 2008 64-bit machine that has MsSqlserver 2005 installed on it. "This cache contains no result sets, or the current result set contains no rows" I get this error on the statement pQuryResult->GetColumnString(1,1); The code works perfectly o... 31 Jul 2008 10:19

SMO Default versus DefaultConstraint
In the SQL 2005 SMO object library, what is the difference between the "Default" property of a Column member (of a table), and the "DefaultConstraint" property? I am looking here: ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/smo9mref/html/ee4983e7- b0e2-ab8d-718d-98df3b637443.htm .... and I see the... 29 Jul 2008 11:37

Pivot table in 2005
Here are the two tables I have. Each sponge run has multiple weights associated with it. I need to create a pivot table to list one run per row with weights_# in 1, 2, 3, 4, 6, 9, 10, 19. I started the query below, but I just can't get it to line up on one row. : CREATE TABLE [dbo].[Sponge_Run]( [Run_#... 28 Jul 2008 15:09

Stored Procedure Select and Update ?
Hi, I am trying to write a stored procedure to select a record and update. So far I have : PROCEDURE GetNumber (@NextID Nvarchar(16) OUTPUT) AS UPDATE Table1 SET DateUsed = Getdate() WHERE ID = (SELECT TOP 1 Id FROM Table1 WHERE (DateUsed is Null)) Basically I want to get the next row in the table and ... 28 Jul 2008 11:02

Finding problem with hanging stored procedure
I am working on an insert SP, but now it will not execute. I have given it 4 minutes, although it still doesn't execute. Here is my SP, CREATE PROCEDURE InsertEmployee @PosID varchar(10), @FName varchar(50), @MName varchar(50), @LName varchar(50), @Suffix varchar(8), @SSN varchar(11), @Salary money, @D... 28 Jul 2008 11:02

migrate
Hi How to migrate DTS Packages from SQL 2000 to SSIS in SQL 2005. Please help on this Thanks Raj ... 28 Jul 2008 16:11

Ignore testing forte agent
... 28 Jul 2008 06:55

Create storedprocedures dinamically
Hi all, misters I want to create a stored procedure for create severals stores procedures, using some parameters Any sample about it, please ? Thanks in advance, regards. -- http://www.alhambra-eidos.es/web2005/index.html www.kiquenet.net http://www.setbb.com/putainformatica/viewtopic.php?p=843 www.t... 28 Jul 2008 13:06

Question about transaction
I have a series of read and update activities in a transaction. All of my read activities are of the default isolation level (read committed). If another update (in its own transaction) changes and commits the data after the my transaction starts, is the read in my transaction going to see the updated value? In... 29 Jul 2008 17:50

compare tables
Dear all, If I have two tables with same fields and some data difference only, How can I compare these two tables and show the records which are difference? e.g. with ID as primary key (1) Same ID exists but with different data. (2) Only one ID exists in one side, it may be insert or delete, Then show the Re... 28 Jul 2008 12:04