Forum Replies Created
Viewing 15 posts - 35,581 through 35,595 (of 39,803 total)
-
RE: Effective permissions
Don't grant to users, use roles.
That being said, the permissions matrix is by user/role by object, so you'd probably want to query for a specific object to see the permissions....
-
RE: Stars
Some good points brought up above. Overall, we kind of see the points as a contribution thing, shows us who's contributing to the community and we have tried to reward...
-
RE: Script database objects to file automatically
you can do it with DMO (I think Andy has an article on this) and then run the script from a job.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 -...
-
RE: .
@##^%$$#%$#%#
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Do Hints Work Anymore?
1. I've seen this as well and I have no idea. Some piece of code in the Optimizer is not working as expected.
2.
. send to sqlwish@microsoft.com3....
-
RE: Copying backup causes periodic failure
Most likely the file is in use by some process, either the backup process or some tape process.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: SQL Recommendations
I use ASP to query the db and pull stuff out. Visual Studio will help here. I'm sure there are some commercial utilites (http://www.mylittletools.net/scripts/en/home/) and others that can help.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The...
-
RE: Recovery of database...
it should be rolling back the transaction and you will have to wait until it completes.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: DB application off of a DVD
You could, but the host server would still need sql installed and running. I suppose you could script a startup, but you'd still need the registry entries. SQL, however, can...
-
RE: DB last updated
You can add a field and set a default of "getdate()" for inserts, but for updates you'd have to set a trigger.
Lumigent's Log Explorer or any of the log reader...
-
RE: Virtual briefcase
longer than your arm :D.
Actually I'm not sure at this point. we all three get so many things.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Stars
Not a bad suggestion, we just went with what came from the Snitz code. I'd guess it goes to the number of posts somehow correlating to contributions to the community.
We're...
-
RE: Is the Schema Still Needed?
Interesting idea. I hadn't considered that.
Thanks for the info.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: ACCESS_VIOLATION restarts SQLServer Service
Honestly Robert, I'm not sure what happened, but I wouldn't mess with this. Call PSS.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: How to migrate ALL Jobs to another server at one ?
I'd script from EM.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
. send to Viewing 15 posts - 35,581 through 35,595 (of 39,803 total)