Between your Windows Locale, Query Analyzer, and your connection settings, its easy for SQL Server to get the format wrong.

For this reason I always recommend using dates in the format...

Reporting Services should be able to create reports from any OLEDB/ODBC source. If you can manually create the ODBC connection string, with the Excel driver,  Reporting Services should be able to...

Off the top of my head, I'm pretty sure you can create a snapshot of a subscription, and manually copy it to the subscriber.

If the subscriber is on a slow lan, or...

Check your USB drive is formatted with NTFS. Most USB drives come formatted as FAT16 or FAT32. If your not using NTFS, there's a 2GB file limitation, which windows will...

Are you bashing your disk by backing up to the same drive/disks/array that have the database files on it?

It seems to me that there is definately something else happening on...

I dont' believe you can install a second instance of Reporting Services (it is after all only one windows service).

However, try creating two folders, one to represent development, one for...

Under the Optimizations tab in the properties of your database maintenance plan. They should be the first and third tick boxes.

Dave

are you referring to the amount of free RAM memory ? or are you asking about the amount free disk space in a database file ?

Not that I know of. You could change the Object Owner to being someting other dbo, and then only the new owner would be able to see the objects. But...

"Public" permissions are the same as declaring permissions for everyone in the database. When you create a table, no permissions are declared to begin with, you add them as needed....

A hah! the powerpoint slides from the meeting are here:

http://www.sqlserver.com.au/meetings/Melb/2004/11November/SQLServer_HA.ppt

mm password policies are not a built in thing of SQL 2000. Windows password policies are the way to go. Unless you want to keep (potentially insecure) copies of passwords...

Yikers! Don't turn on Allow Cross Database ownership chaining! that thing has nasty security implications. In anycase, it only has an affect you are accessing something in "databaseA" from "databaseB",...

You can use a

INSERT INTO #mytemptable

EXEC myProcedure

type of statement to collect the result set into a temporary table.

Don't know if a cursor   can...

SQL Users group in Melbourne, Australia recently covered all these topics in a SQL Server 2000 vs 2005 High Availability meeting. Though I haven't worked directly on clustering or mirroring, I...