1. Your login doesn't have rights to this database for some reason. Do you have an sa/sysadmin level login? How are you doing the detach?

2. no. There should be some...

As a hint, the structure is:

from inner join on [condition] inner join on [condition]

The table naming is:

server.database.schema.table

Server, database, schema are optional, but are used to differentiate from...

Do you mean SSMS?

Can you show an example? Are you asking for a line number in the code or in the results?

GSquared (11/10/2010)

---

I agree with a previous post that it doesn't have to be perfect, it just has to be better than the current system, which is more lethal than any...

http://www.sqlservercentral.com/Briefcase

Briefcase is under most article headers.

Do I start Moss? Over Finnegan from Atlanta? Been a rough year for me. Marshall not showing up, Sanchez/Palmer playing great when I don't start them. Grrrrr

Lots of Yankee infield in there.

I know people complain about Jeter, but I think we're splitting hairs. I've seen him make some amazing plays from short. Maybe he doesn't have...

Snow, first one of the season.

2:30pm yesterday

4:00pm yesterday

blandry (11/10/2010)

---

...

I think automated roads are unlikely to ever happen, let alone work. Its like smoking... We all know its bad, but there are still tons of smokers...

The only way that you can store multiple values in a variable like this is to store them in a string

DECLARE @State varchar(30)

SET @State = '''VIC''', '''QLD'''

Where do the values...

The main thing is that you probably have a VLF at the end of the log file. What you need to try to move the log. I'd think that your...

7, or 32,768

How hard do you think...

See Gilamonster's post earlier. You should not be regularly shrinking the log.

Actually I think a big problem is so many business people running technology companies, and the pride of doing something well being slipped in favor of making a ship date....

Very true, Alvin, but I'd argue that I've come across lots of stuff that I "shouldn't" install on an MS device. And with Apple having hundreds of thousands of apps,...