Viewing 15 posts - 9,076 through 9,090 (of 9,720 total)
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...
January 25, 2008 at 6:20 am
Have you run "master..xp_logininfo" yet?
If so, what's the output?
January 25, 2008 at 6:18 am
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.
January 25, 2008 at 6:16 am
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...
January 25, 2008 at 6:15 am
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...
January 25, 2008 at 5:55 am
We're always happy to help.
And remember, the only forbidden question on this site is "Why is the sky blue?" ... @=)
January 25, 2008 at 5:20 am
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...
January 24, 2008 at 5:14 am
Enterprise 32 bit (for the servers) and Developer 32 bit (for our local PCs).
January 24, 2008 at 4:38 am
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...
January 24, 2008 at 4:34 am
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...
January 24, 2008 at 4:28 am
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...
January 24, 2008 at 4:24 am
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...
January 24, 2008 at 4:22 am
BOL also has some good tutorials. And if you don't have access to SQL Server at the moment, you can either download the eval version of 2k5 or (recommended)...
January 24, 2008 at 3:59 am
And save all your T-SQL scripts! You'd be amazed at how handy that comes in 6 months down the road when you need to replicate that "one time" job.
January 23, 2008 at 11:25 am
Viewing 15 posts - 9,076 through 9,090 (of 9,720 total)