Viewing 15 posts - 26,746 through 26,760 (of 39,792 total)
You need to be sure you haven't set the server to not use parallel queries or the threshold is too high. If so, you might see one CPU working hard...
October 10, 2008 at 3:14 pm
It's used in full-text indexing, and contains the indexes' data from that system.
October 10, 2008 at 3:12 pm
select * gets expanded to all columns. If you do not want all columns, you must specifically name the columns in the query.
October 10, 2008 at 3:03 pm
Identity has nothing to do with primary key. They can be the same, but don't have to be.
What's an occurence? Not sure what you mean here.
October 10, 2008 at 12:23 pm
No easy way, you'd need to decode the information and look for patterns.
October 10, 2008 at 12:22 pm
Hmmm, not a lot of responses. Guess lots of people don't do this, don't care, or are watching the markets.
Fisher-Price interfaces are good for management. Big buttons, lots of color.
October 10, 2008 at 10:40 am
Windows are fun. Cabinet doors are better with the trim. Need to replace one of those this weekend.
October 10, 2008 at 10:38 am
My pleasure, thanks for the update.
Security can be a pain when people are a member multiple groups. Not a bad reason to watch which groups you give SQL access.
October 10, 2008 at 10:03 am
Why can't anyone write to the db? Not to question your idea, but I'm wondering if there is something else we can come up with.
October 10, 2008 at 9:36 am
sysdepends doesn't "fix" things created out of order. What are you trying to do, update it? There might be some things that can do this, but why do you need...
October 10, 2008 at 9:04 am
It's bitmapped. Meaning the 512 is the bit (#9) that determines if the database is offline. So you OR it with 512 to check the status of the bitmap.
http://www.sqlservercentral.com/articles/Miscellaneous/2748/
October 10, 2008 at 9:01 am
Start | Programs | SQL Server | Profiler (I think that's the path on a 2000 server).
Connect to your SQL Server, start a new trace, choose the defaults. It will...
October 10, 2008 at 8:59 am
A few things.
1. If there is a guest user in the database, then the login will get mapped to there, can access the database, but they have the rights of...
October 10, 2008 at 8:56 am
What's the stored procedure doing? It's what it says, the proc is trying to reference those objects and they either don't exist or the user can't see them.
October 10, 2008 at 8:53 am
Viewing 15 posts - 26,746 through 26,760 (of 39,792 total)