Float is not an exact data type. If is an approximate data type. This means that it might have some mistakes but it should be few digits after...

You can do it with the openrowset function and the provider bulk.

Here is an example:

create table #XmlTable (XmlCol xml)

go

insert into #XmlTable (xmlCol)

select BulkColumn

from openrowset(bulk 'c:\FileName.xml', single_blob) as dt

You can...

There is one difference that I remember. The definition of the network namefor the location to copy the backup files on the secondary server should be added as a...

Maybe there is a better way but I think that you’ll have to use dynamic SQL with Xquery. The Xquery part will get the values of the attributes and...

This has nothing to do with dropping the database. If you have only...

You can use the...

Johann Montfort (11/28/2008)

---

Hi All,

I am doing the following

SELECT BuildID AS [@BuildID]

FROM Builds_LIVE

WHERE BranchID = @BranchID

AND ProductID = @ProductID

--if found

IF @@ROWCOUNT > 0

BEGIN

DELETE FROM Builds_LIVE

WHERE BuildID = @BuildID

AND BranchID...

Might be wrong here but it seems that those 2 statements caused the deadlock:

UPDATE SS.SECTIONS WITH(ROWLOCK) SET SECTNO=160 WHERE ROOMNO=401

UPDATE SS.SECTIONS WITH(ROWLOCK) SET SECTNO=101 WHERE ROOMNO=601

Do you have an...

chris (11/27/2008)

---

UPDATE SS.SECTIONS WITH(ROWLOCK,HOLDLOCK) SET SECTNO=101 WHERE ROOMNO=601

This will indicate to the SQL engine that it must hold the lock on the rows it is updating till it has completed...

GilaMonster (11/27/2008)

---

Traceflag 1222 is preferred over 1204 on SQL 2005 as it provides a lot more info. 3605 is not required for logging deadlock info to the error log.

To get...

krayknot (11/26/2008)

---

TNV (11/26/2008)

---

Hi Kumar,

Basically I am new to this SQL Server stuff...

I am using MSSQL Server 2005 Express. I turned on trace by using DBCC TRACEON (1024). But in the...

Paresh Prajapati (11/26/2008)

---

So, as per ur side, we need to restore full backup first then restore all trn log backups up to point of time witch we have required up...

TNV (11/26/2008)

---

Hi Kumar,

Basically I am new to this SQL Server stuff...

I am using MSSQL Server 2005 Express. I turned on trace by using DBCC TRACEON (1024). But in the errorlog,...

2 Tim 3:16 (11/25/2008)

---

generate a script from the backup file? not sure how to do that. The reason I want to do this in the first place is...

Your are getting the error because you have a database with a different name then the database that you are restoring that has the same files' name and path as...