Viewing 15 posts - 5,086 through 5,100 (of 6,486 total)
While you may be able to do away with some amount of redundancy in your code, blind refactoring to wring all of that out will usually be done at the...
January 23, 2008 at 2:23 pm
Midan -
You shouldn't need to change the assignment process if you simply change the clustered index order. Really. It should assign the numbers correctly one way or...
January 23, 2008 at 2:05 pm
Greg Charles (1/23/2008)
I don't know why the client won't install, but the server components are grayed out because Standard Edition requires a server level operating system.
Actually - the standard edition...
January 23, 2008 at 1:55 pm
Also - if you've installed the "original" Team suite, you probably don't have access to the nice new database projects which unlock so much more than the "default" database template....
January 23, 2008 at 1:33 pm
also - while I would definitely take this information with a grain of salt - you might care to peruse
select * sys.dm_db_missing_indexes
To see if SQL 2005 thinks it would...
January 23, 2008 at 12:44 pm
In that case - you might care to double-check that you have no nullable bit/boolean fields, which will cause much confusion to Access (it's allowable in SQL Server, but Access...
January 23, 2008 at 11:02 am
Assuming that's the only growth you have in mind - that's actually not all that much.
What you're describing is actually LINEAR growth (you'd be doubling the number of...
January 23, 2008 at 10:58 am
As long as you're not allowing SA access to folks, then you should be able to use DENY EXECUTE
against all users. even if the users had DBOwner access to...
January 23, 2008 at 10:39 am
I'm not sure how you're running the inserts versus deletes, nor whether you're using an Access Data Project or the "regular" access with linked tables, so I'll just throw this...
January 23, 2008 at 10:18 am
Vista Error 5120 is the old DOS error 5 (access denied).
Most common fix to that I've heard is to either turn off UAC (user access control, which is a bit...
January 23, 2008 at 10:03 am
The message is pretty clear in itself - it's trying to use the above listed user to log into the database server, and cannot due to a login failure. ...
January 23, 2008 at 9:25 am
While the TRUNCATE_ONLY idea was a nice touch, the truncation itself doesn't make the transaction log any smaller. You need to also shrink the log file after that....
January 23, 2008 at 9:21 am
You're not giving us enough info to help you. The rest of the code is needed.
I'm assuming you know you should by far and large be avoiding cursors, since...
January 23, 2008 at 9:11 am
You might care to save your big manager from himself, and leave yourself a back door.
Just be sure to SAVE A COPY of these. In particular - keep a...
January 23, 2008 at 8:50 am
Jacob - it seems the actual article got "et" (southern for "eaten") by SSC. There's nothing other than the title, then the footer links...
January 23, 2008 at 8:37 am
Viewing 15 posts - 5,086 through 5,100 (of 6,486 total)