Sorry, there waqs a typo in my initial message:

For the second example it should read:

"with no SQL Server 2005 or higher installed on the machine I get the error...

Yes, the parameters accept NULL value and the report works fine. The only thing I need is how should I say NULL in the subscription TABLE.

Another thing: I do not have any indexes )yet) on the table, so DBCC DBREINDEX won't work.

And what is even more strange:I restarted SQL Server and everything is back to...

UPDATEUSAGE doesn't make much of a difference, the unused space is still huge. The question was why does it happen, because it didn't happen before...

Thanks. I think that is just an exemple of bad practice! I can use SCHEMABINDING here too, once I get rid of that SELECT *! At least with schemabinding I...

Can you be more specific?

Must be

MSSQLSvc/SS2K2/1433 or/and MSSQLSvc/SS2K2.mydomain.com/1433

or

MSSQLSvc/SSK1/1433or/and MSSQLSvc/SS2K1.mydomain.com/1433

(assuming that I use for all of them the default port 1433)

And something else: do you use it this way and...

Any idea who may execute them?

I can see that by default PUBLIC has execute permission on xp_regread but what about the rest? When executed from SQL Server what account...

I think that i have to copy the input parameters in some internal variables, I agree with this. I still need to make some more tests, but it seems that...

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

create   Procedure dbo._RPT_x

        @i_FROM datetime, 

        @i_TO datetime 

As 

BEGIN 

SET NOCOUNT ON 

SET ANSI_WARNINGS OFF 

declare @TableName varchar(255) 

declare @SQL...

Sorry, Yelena, I mean Performance Tool, as in Windows 2003.

I tried to use both SQL account and Windows login for the ODBC DSN. Is not working etiher way. Anyways, the...

Thanks, the schema.ini works fine. The only thing I don't like is that I have to change the name of the file any time I want to read a different...

http://www.elitecertify.com/

Good luck

Gabriela

If the constraints were disabled with NOCHECK, you have no clue if the data are still clean. While the constraint were disabled, dirty data could have been inserted in the...

If you want to actually check the validity of data against the constraints use DBCC CHECKCONSTRAINTS ; This will check the constraints and will report the violations.

Check BOL for usage.

Gabriela

It seems that my problem was the presence of distributed transactions. Unfortunately, I restarted the server before trying to restart the MSDTC, so for now I cannot confirm that restarting...