We did end up working around it (temp table/join), but I was just wondering if there was a limit.

Thanks all.

Someone is running a query from coldfusion that is creating a flat file based on a column in

a table of 4300 rows matching a "pseudo-column"  in a "pseudo-table" .csv...

Ummmm. I did get that far.  Why I'm asking about the IN limit is because the only way the sql would run without this error is to chop up the...

As someone in the same boat (oracle DBA learning SQL Server) I found the book

Oracle8i and Microsoft SQL Server 2000 Integration by Stephen Chelack very helpful.  Outlines the differences very...

I guess what is confusing me is that the documentation I have for reporting services installing says there are different editions of REPORTING SERVICES:standard, enterprise, developer, and evaluation.  There are...

I was meaning in regards to licensing....we are licensed for only standard edition sqlserver2k... is the reporting services edition somehow connected or independent of that? 

Do you know what would happen if the server went down? Do I lose everthing? Does it overwrite the file?

I'm required to keep audit trail for a year....

Does no one have a hint for me on this?

The problem most likely is that your query is

taking too long to run. Oracle is trying to give you a "point in time" result set. If there are updates...

I'm not sure I understand what you want me to do. The backup directory is e:\mssql\backups

my backups don't even go in e:\mssql\data or any subdirectory under it. This...

if i try to remove the MSSQL\backup subdirectory (which is empty) and then do a restore, I get this i/o error looking for that subdirectory..., if i create the directory...