Viewing 15 posts - 616 through 630 (of 824 total)
What makes you say that adding a Player1 and player2 columns to the teams table is a serious normalization violation? If a team can have 2 and only 2 players,...
March 30, 2005 at 10:53 am
Aaron is correct, just use the sp_changedbowner proc. Then you should be able to drop User1.
User1 is probably being shown as the database owner because that login was used to...
March 30, 2005 at 9:55 am
"Tim O'Reilly wrote last year "We're entering a new world in which data may be more important than software.""
Welcome to the real world Tim! That statement betrays a deep...
March 30, 2005 at 9:11 am
As far as I know the only way you can do this is if you use dump devices. Define the device using sp_addumpdevice then do your backups (full and t-log)...
March 29, 2005 at 4:15 pm
The problem is that granting execute on a stored procedure does not necessarily grant all the required permissions for all operations that the procedure might attempt to perform. This is...
March 29, 2005 at 2:08 pm
Almost anything is possible, but it would get ugly pretty fast. Just off the top of my head, I think you would have to declare a cursor to loop through...
March 29, 2005 at 1:57 pm
This type of thing is really best handled by a report generator, but you can do it with SQL.
CREATE
TABLE table1
March 29, 2005 at 12:39 pm
A couple of comments: First off why don't you remove the table creation statement from the sp. Then the sp can populate the table (and truncate it when you are...
March 29, 2005 at 11:53 am
Many people seem to think that clustered indexes are "more expensive" to maintain than non-clustered indexes because they need to "rearrange" or reorganize the data frequently. This is not the...
March 29, 2005 at 11:31 am
I agree with Rudy that there might be more appropriate ways to approach this particular situation. From my experience, the most likely scenario is that someone switched the recovery model...
March 29, 2005 at 11:01 am
I don't know what you consider to be expensive, but Lumigent's Log Explorer was less than $1,000 per server last time I checked. They offer an eval download too, so...
March 28, 2005 at 9:44 am
Oops, I missed that. Have you tried setting up an alias in the client network utility? You might try setting up one to use named pipes...
I remember having a similar...
March 25, 2005 at 3:24 pm
Try using the ip address.
March 25, 2005 at 2:38 pm
My rule of thumb is one login per user/application. Even if you have to create two logins with identical effective permissions this prevents ambiguity and in the long run simplifies...
March 25, 2005 at 1:27 pm
The type of network use is a relatively minor factor in this equation. The more important factors are the average size of the requests being sent to the server and...
March 23, 2005 at 3:17 pm
Viewing 15 posts - 616 through 630 (of 824 total)