Viewing 15 posts - 9,061 through 9,075 (of 9,715 total)
jwhite,
It's probably a global policy or local policy object that's grabbing this information. The Application Log audits stuff based on what the OS / Domain Security Policies are set...
January 25, 2008 at 8:18 am
Use Patindex() to locate your angle brackets. Then once you know those positions, you should be able to search between them with Substring() for the text you're looking for.
Check...
January 25, 2008 at 8:10 am
To see Line Numbers in SSMS, go to Tools -> Options -> Text Editor -> All Languages -> General and Plain Text -> General. To the right and near...
January 25, 2008 at 8:07 am
If these tables are that temporary, why are you even worried about what filegroup they end up on?
If it's a space or processing issue, here's another possibility. Create a...
January 25, 2008 at 8:00 am
SELECT INTO is much faster on FULL Recovery too. I've never profiled it to see if it works like TRUNCATE (minimally logged) or if it just works like Bulk...
January 25, 2008 at 7:58 am
Avoid Image, NText and Text datatypes where you can. They will soon no longer be with us. Not sure if it's SQL 2k8 that's taking them away or...
January 25, 2008 at 6:46 am
What is an ofdm and why is this thread in the "Discuss Content posted by Leo" forum?
January 25, 2008 at 6:37 am
Nilesh,
Please start new threads when asking additional questions. I almost answered the original poster when I saw that he had posted back in 2006 and his question was probably...
January 25, 2008 at 6:35 am
You should post that as a potential bug to Microsoft's website. They might get it fixed.
January 25, 2008 at 6:27 am
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...
January 25, 2008 at 6:22 am
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
Viewing 15 posts - 9,061 through 9,075 (of 9,715 total)