This error normally happens if you have striped the backup over several backup devices, and then try to restore from only one or not all of them.

quote:

---

Approach every issue with the idea that every resource is solid gold, and in a year or so, you'll still have your...

Number of rows and data size is not limited for table. Only width of rows which is delved into a bit here.

http://www.sqlservercentral.com/columnists/sjones/pagesize.asp

A table go go well into terrabytes. However, if...

Now a scheduled chat session might actually be fun. May set a topic for the discussion early on and see who is interested. I would just say have a test...

I right off see several table scans. Now the fact that the size of the query doesn't match the output means this is a view right? Can you post the...

There are many factors that can effect performance and speed of a query besides memory.

Look at the query execution plan and see if anything that is bad for performance is...

I believe it means SELECT..INTO..FROM

like so.

SELECT tbl1.Col1,

tbl1.Col2,

tbl1.Col3,

tbl2.Col1,

IDENTITY(int, 1, 1) As SortOrder

INTO DestinationTable

FROM tbl1

CROSS JOIN tbl2

WHERE tbl1.tbl1id = 1

Hey Scorpion, I couldn't help but laugh too. I wonder if anyone else...

I cannot remember and I do not have a way to test here nor can I find the article off hand. But I believe you have to have MSDTC running...

Just change where David made it varchar back to

declare @tmpuid uniqueidentifier

should do the trick.

This is one of those gotchas many people miss.

In QA pres CTRL+SHIFT+O or select Tools/Options on the menu bar.

Now on the new dialog select the "Connections Properties" tab. When you...

I don't think it will take even that long. But as always backup your DBs beforehand for safety in case the unforseen occurrs.

See this

http://www.sqlservercentral.com/columnists/glarsen/collate_part1.asp

and this (which has options on this)

http://www.sqlservercentral.com/columnists/glarsen/collate_part2_1.asp

See if this helps

from BOL

quote:

---

How To Disable Publishing and Distribution (Transact-SQL)

To disable a Distributor (Transact-SQL)

Execute sp_dropdistpublisher to drop a Publisher...

What specifically are you trying to accomplish? Can you describe why each needs it's own local SQL? Laptop or desktop?

Some I know of right off the top that are pluses (at least to some).

1) New table variable data type. Usefull for small temp tables, avoiding some tempdb stuff and...