Congrats Gail. Even if I answer all the question for the day, I will never hit anywhere near 20K.. 🙂

That is strange, NTFS has no limit other than the hard limit of the HDD. Fat32, there is a limit of 4GB and and for FAT16 a limit of 2...

winash gave you all the info. It will work but it is quite a lengthy process. Isnt it better to to just reinitialize the subscription?

I would just reinitialize just...

First run sp_dropsubscriber in the publisher database and then run sp_dropdistributor at the distributor.

You can find the option for running these commands in Books On Line.

250GB of Data and you chose Snapshot replication? For a DB if that size, Snapshot is not the way to go. You will encounter quite a few issues.

1. The...

Is it the log reader agent that is throwing the error? Did you change the Account from which the SQL Server Agent was running? Does the Distributor and subscriber run...

Did you check the error log to find out for definite what exactly is the problem. It could be that you have ran out of Disk space.

bitbucket-25253 (10/28/2010)

Roy Ernest (10/28/2010)

Grant Fritchey (10/28/2010)

Oh, that was you? Sorry I didn't wave back. Man,...

I have couple of suggestions, but you have to take the first step on that. Put the Table structure here. We could help you with the indexing.

You also said that...

Check the execution plan and see if there is any difference when executing as RAW SQL statements and when executing as TVF.

Temp tables can be used depending on the...

Ah.. I see the Threadizens to the rescue. Cool job all of you..:-)

I am no expert in T-SQL but here are couple of things I noticed.

1. Your variable table can cause performance issues. This is basically because variable table does not...

Ouch... Steve, this guy might be good but he is going to scare away OPs. Better have a talk with him. That...

Grant Fritchey (10/28/2010)

Oh, that was you? Sorry I didn't wave back. Man, I need to...

Jack Corbett (10/28/2010)

Nope not me. Hopefully your OC will be contacting you. ...