Worked like a charm!!

Thanks!

Be careful with the sp_sdidebug. It seems to have some side effects. Some of my tempdb objects had denied access to them after running this.

Flipping back (legacy_off) does not fix...

got it:

check out

http://support.microsoft.com/default.aspx?scid=kb;en-us;328173

and

http://support.microsoft.com/default.aspx?scid=kb;en-us;328151

I guess this is a side effect of "Trustworthy Computing"

What is the command to run an SP on server startup, again

Jakub

...

I have the same problem. The Debug used to work, then I installed the SP3 and the .NET framework and it does not work anymore.

Please post here if you find...

I found my answer, where else but in BOL

Posting here so others can benefit

BOL:

When setting up a push subscription using the Push Subscription Wizard in SQL Server Enterprise Manager or...

Also,

there is nothing in any of the logs about this, except that xprepl.dll being used

any help would be appreciated. I need to get this on-line

Thanks

Jakub

The linked server works fine on Publisher.

There is no linked server set up on subscriber. Does there need to be one for replication?

Jakub

Edited by - lof on 01/15/2003 4:24:25...

I even hardcoded the @DOB in the statement to check it.

DaveT

you are correct. I found this in BOL when digging around.

'Built-in nondeterministic functions are not allowed in the body...

What limitations are there to table variables? I thought that they are a preferred way to temp tables.

Jakub

That's what I was looking for.

Thanks,

I am using table variable instead the Temp table.

Thanks again,

Jakub

Yeah,

I saw it. that's why we are converting to the decimal. It will work fine for us at a small price in the size of the fields. But at least...

Thanks for your answers. But, the way I read BOL, float has precision of 15 digits, while the decimal format can have up to 38 digits, at the price of...

Thanks guys.

That should do the job for me.

Jakub

Thanks David,

I guess our posts have just crossed. The dynamic task works for me as I can set the global variable from the web page.

Jakub

Thanks,

That should work. Actually I found a solution which works for me. There is a DynamicProperties Task in DTS, that alowsme to assign a Global Variable to the filename.

Thanks for...