Actually, the very fastest option might be to back it up to locally attached storage, and THEN copy it somewhere once the backup is done. Backup involves a lot...

Related thread over here:

http://www.sqlservercentral.com/Forums/Topic627764-338-1.aspx

Sorry - I just noticed how little info I actually provided on the other thread...:)

Thanks for the assist.

In case you need any of those as attibutes - just throw an...

Aspet Golestanian Namagerdi (12/31/2008)

---

No,My question was that,when you create an identity field in a table,How SQL SERVER handles it?Where does it keep the latest value for that field?Does SQL...

I completely believe it. I still...

Jeff Moden (12/31/2008)

---

Grant Fritchey (12/31/2008)

---

I presented this as a database design at a meeting once.

CREATE TABLE [dbo].[AppTable](

[Id] [int] IDENTITY(1,1) NOT NULL,

[RefId] [int] NOT NULL,

[AppValue] [nvarchar](max) NOT NULL,

CONSTRAINT [PK_AppTable] PRIMARY...

You'd have to create an Office application automation script or Executable, to then open open the Access app and run the macro. Unless your macro is REALLY doing a...

Have you tried simply using SQLXML? Using XQuery for this in SQL is reminiscent of buying a hammer and some nails, but then throwing away the hammer and using...

Not that I don't enjoy automation and all, but I just prefer to set the "auto-refresh on opening" option in the Excel data range......

Peter - your XML got whacked by the SSC markup. If you replace the left and right brackets with their HTML version - it will show up again...

raj acharya (12/31/2008)

---

hi as per you told that if you want to check for this particular column of primary key then right click on table and click on design and...

True, but when you're on the seventh edition of your book, and you're still trying to...

MLM=multi-level marketing.

That's usually...

SYS.TABLES will show them if they're still "around". On well-behaved servers, you may need a WAITFOR to keep the batch "open" long enough to see the table var....