auto expanding Temp DB to fit large requests

I have run into a glitch in SQL 2000's ability to automatically expand the temp db when temp tables become very large.

In our business it is sometimes required that I alter a customer's configuration data without modifying any of their transaction data. This requires a rather complex procedure that creates a script of insert/update/delete statements that, when run on a customer's database, modifies their configuration to a replica of our in-house test environment.

While creating this script, sometimes a few lines are dropped. The real problem is that we have no error or indication that the script had dropped lines until we attempt to run it (which is usually on-site in a live environment.) Our solution is to manually increase the size of the temp db and it's transaction log. After we do this, the script is always created correctly.

This appears to be a bug in the ability for the temp db to auto expand. Is this fixed in SQL 2005?

Various tempdb defects have been fixed in SQL Server 2005. In addition there is a new feature allowing the "automatic space growth" without zeroing pages (makes auto growth much faster).
Without going into more details I expect that your problem will be fixed
SQL Server CTP15.
Please install the CTP15 release and test it. In addition I suggest to contact
MS-CSS (SQL Server 2000 Customer Service) and report your problem for SQL Server 2000

Please let me know the test results for SQL Server 2005 CTP15
Thanks
Mirek

Authentication Question

Hello,
I want to setup authentication so that if any requests come from a
certain ip address they are automattically accepted. Is there an easy
way to do this or is using some kind of custom extension using forms
the only way?
Thanks,
DavidAccepted or rejected? Rejected can easily be done by configuring IIS to
reject a particular IP address. If you want it to accept then I don't see
any way to do this other than with a custom extension.
Bruce L-C
"David" <davidbjunk@.gmail.com> wrote in message
news:67845027.0409231000.7feb8eb5@.posting.google.com...
> Hello,
> I want to setup authentication so that if any requests come from a
> certain ip address they are automattically accepted. Is there an easy
> way to do this or is using some kind of custom extension using forms
> the only way?
> Thanks,
> Davidsql

Authenticate users, while making Web Service(SOAP) Requests

How can I authorize users to retrieve their own data while making SOAP
Requests?
I don't want to pass usernames as paramaters. I could pass them in
cookies in some encrypted format.
Is there an interface to implement for authentication/authorization
before processing results, in SQLXML 3.0 SP2?
Regards,
Mert SakaryaUnfortunatly no. You could use Integrated Authentication in ISAPI and then
set up the database security to check the user, though I don't think that
would give you row-level security. You'd have to add some logic for that.
Irwin
"Mert Sakarya" <msakarya@.(nospam)e-kolay.com> wrote in message
news:uIA2XPmEFHA.960@.TK2MSFTNGP09.phx.gbl...
> How can I authorize users to retrieve their own data while making SOAP
> Requests?
> I don't want to pass usernames as paramaters. I could pass them in
> cookies in some encrypted format.
> Is there an interface to implement for authentication/authorization
> before processing results, in SQLXML 3.0 SP2?
> Regards,
> Mert Sakarya
>

Authenticate users, while making Web Service(SOAP) Requests

How can I authorize users to retrieve their own data while making SOAP
Requests?
I don't want to pass usernames as paramaters. I could pass them in
cookies in some encrypted format.
Is there an interface to implement for authentication/authorization
before processing results, in SQLXML 3.0 SP2?
Regards,
Mert Sakarya
Unfortunatly no. You could use Integrated Authentication in ISAPI and then
set up the database security to check the user, though I don't think that
would give you row-level security. You'd have to add some logic for that.
Irwin
"Mert Sakarya" <msakarya@.(nospam)e-kolay.com> wrote in message
news:uIA2XPmEFHA.960@.TK2MSFTNGP09.phx.gbl...
> How can I authorize users to retrieve their own data while making SOAP
> Requests?
> I don't want to pass usernames as paramaters. I could pass them in
> cookies in some encrypted format.
> Is there an interface to implement for authentication/authorization
> before processing results, in SQLXML 3.0 SP2?
> Regards,
> Mert Sakarya
>