The original question was asked about 2000, but I tried 2000,2005,2008 and they all gave me the same error. Now the article that was referenced did mention that it...

I ran this statement against a SQL Server 2000 database and got this message:

Msg 5058, Level 16, State 5, Line 1

Option 'READ_ONLY' cannot be set in database 'MASTER'.

I think the...

I executed the code (in SQL 2008) and the message I got refered to it as a.size, etc instead of the previous error. It maybe a version dependent thing?...

I assume that Mail ID is a column you are trying to reference. If the table has a space in it you can use braces to denote it. Generally...

Towards the end of your stored procedure there is a statement:

"select @@servername as 'InstName', sum(a.size) as 'Space Aloc (mb)', sum(a.used) as 'Space Used (mb)', sum(a.size)-sum(a.used) as 'Free Space (mb)'

from AuxSpaceTable"

somehow...

SELECT SUM(UnitPrice)

FROM Description d INNER JOIN PriceGroup pg

ON d.DescriptionID = pg.DescriptionID

INNER JOIN Price p ON pg.PriceID = p.PriceID

WHERE d.Code IN ('Cu','Fe','Y')

Are there certain combinations you are needing? ...

I assume you are trying to connect on the same machine that is hosting the SQL Server since it is complaining about SharedMemory.

If not,

Go under Surface...

select ID,braut count(*) as Qty from Brautirnemar_V where skID = "&Request("SkID") &" group by ID,braut order by braut

As long as you have a field your grabbing that's not...

A full database backup is different than a full file group backup. Yes, a full backup does get all of the filegroups (because the database is spread across them)....

If you run "osql -L" from the command line (in the [sql]\tools\binn directory) this will return a list of SQL Servers that were discovered. Using this: "osql -L >...

To run that code you will need a SQL Task in the Control Flow view. You probably should save the table name to a global SSIS variable so you...

After running the script, try adding this line: insert into #test values(NULL,1); This one will fail because the first column does not allow nulls to be added (testField ...

Bit late in the game, but trying to catch up. The question did mention they were setup with "best practices". Best practices would indicate that you would delete...

Yes to both questions. Order of operation does matter. As you learn more about the specific operations (sometimes more than you care to know!) you'll catch on. ...

This sounds like a bit of a complex problem. The issue will be that each table has a different column that will identifiy it as being duplicated. Is...