Viewing 15 posts - 46,216 through 46,230 (of 49,571 total)
tmbasha (6/16/2008)
This is the table which stores an Order of 93 columns
Still... I'd be quite willing to bet that SQL is only using a small % of those indexes. Check...
June 17, 2008 at 12:23 am
ALTER AUTHORIZATION On <Object name> TO <New Owner>
There are a lot of different options for ALTER AUTHORIZATION, so check what Books online has to say on the subject
That's if...
June 16, 2008 at 2:05 pm
control (6/16/2008)
How can I do an update or change the value of one or some of the Column/s?
You don't. The system tables aren't updatable in SQL 2005. They aren't even...
June 16, 2008 at 1:41 pm
Can you post the VB code please?
Is it possible that you have implicit transactions and are reusing a connection that has an ope transaction?
Second the suggestion of profiler. It will...
June 16, 2008 at 1:28 pm
GSquared (6/16/2008)
Say an airplane's navigation system. That must not give an incorrect result.
It depends on "incorrect". If, for example, precision exceedes accuracy, that's wasted effort.
Naturally. I probably should have...
June 16, 2008 at 1:22 pm
No. Use sysprocesses on SQL 2000.
June 16, 2008 at 10:53 am
travis.whitley (6/16/2008)
was supposed to be funny. i guess cultural references dont work on forums;)
I think we all missed the joke.
June 16, 2008 at 10:51 am
IDENTIFIED BY is not part of SQL Server's create role statement. The form of create role is
CREATE ROLE role_name [ AUTHORIZATION owner_name ]
so, as an example,
CREATE ROLE buyers AUTHORIZATION...
June 16, 2008 at 10:23 am
Is it a domain account? If so, most likely it's a scheduled job that's using a domain account to connect to your server, and that account has expired within Active...
June 16, 2008 at 10:09 am
noeld (6/16/2008)
tmbasha (6/15/2008)
S.No.TableData Size(GB)Index Size(GB)Total No of Indexes3.X33753
... 53 indexes in one table? ... 🙁
Ouch. 3 GB data and 7GB indexes. I hope it's a read-only table
June 16, 2008 at 10:01 am
samuel_yanzu (6/16/2008)
June 16, 2008 at 9:40 am
You can decrypt them. Both SQL 2000 and SQL 2005, though the methods are different.
A google search should dig up more information for you.
June 16, 2008 at 9:23 am
Steve Jones - Editor (6/16/2008)
Functionality has to be 100%. Or what the client needs the software to...
June 16, 2008 at 9:12 am
Tomorrow. You're leaving things a bit to the last minute, aren't you?
Write up a high-level summary on what you need to say. Include major points and some rough notes on...
June 16, 2008 at 9:09 am
jcb (6/16/2008)
I guess the better way do do it is create TWO SPs and let the app chose one or another...but the developer don't want to change some VB6 dlls...
June 16, 2008 at 8:49 am
Viewing 15 posts - 46,216 through 46,230 (of 49,571 total)