You should post that as a potential bug to Microsoft's website. They might get it fixed.

Oh, hey....

If you're sending your params back to the DB, you can do the check in your SQL Code. It's a simple WHERE clause statement.

But if you need to...

Question. Do your datasets pull all the data and you use the parameters to filter after the fact or do you send the parameters back to the DB before...

Have you run "master..xp_logininfo" yet?

If so, what's the output?

Try to re-register it. If that doesn't work, remove the .dll (or rename it) and replace it with a copy from a working server, then re-register it.

David,

I hate to say this, but you might want to keep your resume dusted off and well polished. If something serious happens, do you really want to be around...

Since SELECT INTO doesn't usually copy over indexes and modifying the default file group before & after a SELECT INTO could cause major problems later on (what if you forget...

We're always happy to help.

And remember, the only forbidden question on this site is "Why is the sky blue?" ... @=)

Sounds like you got the job then. @=)

Interesting note. In the Microsoft Self Paced Training kit for 70-441, the book says

However, you cannot optimize all types of queries. For example, a query such as...

Enterprise 32 bit (for the servers) and Developer 32 bit (for our local PCs).

If the arabic script has no Roman/English characters in it, you should be able to use the following WHERE clause.

WHERE MyColumn not like '[a-z]%'

And if your collation is set up...

Verify via the SQL Server Surface Area Configuration Tool that you have xp_cmdshell enabled on this server. Usually when something takes that long before returning an error, it's stuck...

You can't downgrade a DB to SQL 2000, but you can script out all the objects, recreate them in SQL 2000, move some of the data (top 1000 or 5000...

I can't give you actual monitoring scripts because I didn't write some of them and I don't have permissions to hand the ones I didn't create. Also, you can...