Forum Replies Created
Viewing 15 posts - 39,016 through 39,030 (of 39,466 total)
-
RE: I dont trust my client
Yikes!!!!
this is scary to even contemplate as a developer unless the client is someone your trust.
Some thoughts:
1) Convert ASP application into a DLL so that my source code remains safe(Helps...
-
RE: Active/Passive Cluster & Reporting Server?
What would that do in a clustered scneario? Probably still work.
In that scenario, if you have SQL 2000, you might even want to investigate a 3 or 4 server cluster....
-
RE: Comapring table and other things
No good way natively. Check out the product from RedGate (ad at the bottom of the page). This is exactly what that product will do.
Steve Jones
-
RE: Active/Passive Cluster & Reporting Server?
It seems like you are trying to do two things. If you want to load balance, then you would do that by directing some queries to one server instead of...
-
RE: SQL*Agent jobs in a cluster
So I assume that msdb is included and SQL Agent is picked up by the second server?
Is this correct? Brian? Anyone tested it?
Steve Jones
-
RE: Worst Practices - Assigning Users Rights
In native mode this is probably true (Andy?).
This does, though, meet the division of roles. You should create the roles and hopefully they map to the network groups. If not,...
-
RE: Moving a database from one server to another
switch to master in Query Analyzer. Your QA connection is a connection (and lock) in the db.
Steve Jones
-
RE: Multiple users working on (owning) a DTS
VB is fine, but then you can't bring it back to the designer. This is fine if your people know VB.
Steve Jones
-
RE: What are certification benefits???
Interesting. Never had anyone yell at me like that, but I'm 6', 200, so that may be part of it.
I got offered both jobs, took the first at the time....
-
RE: Binding to addresses
If you add the second address to the NIC in NT, then you need to reboot the box and SQL should listen on all NICs/addresses.
I have multi=homed boxes and this...
-
RE: Delete Files & Folders
I have a "trim BAckup files" script on this site the you may be able to adapt. You would need to add a connector to the SQL Server to get...
-
RE: Perform index analysis
Don't have any v7 servers here. Try running profiler with the sa logon and see what happens.
Steve Jones
Viewing 15 posts - 39,016 through 39,030 (of 39,466 total)