Forum Replies Created
Viewing 15 posts - 35,836 through 35,850 (of 39,771 total)
-
RE: SQL 6.5 trace log
Anytime. Good luck and come back and let us know what you find. Or better yet, write it up and send us a short article
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The...
-
RE: SQL mail
Either get an account that can authenticate or change to SMTP.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Active Directory Group Membership
I'm not that great at this, but I think you'd need to query the ADSI provider using LDAP and get a collection of the group's members.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
-
RE: Victim Resource Owner
What's the exact error? Is this because of a deadlock?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Test/Production/QC Environments
I haven't tried this, but youmight be able to use the Red Gate tools (see the bottom banner ad) to move the strucutre and then a subset of data over.
Steve...
-
RE: Randomize
??
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Backup Compression: SQLZip vs SQLLiteSpeed
I use SQL Litespeed at work and love it. Minimal load on the system, good compression. I run it on the level2, there is a level 3 and I believe...
-
RE: SQL 6.5 trace log
Wow, don't remember, but I'd guess there is. Search for any files that have a last timestamp in the time frame and start looking through them.
steve
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL...
-
RE: Just kidding
That's cool. Not sure I want to hack and fix this Snitz code. We're looking at upgrading though, so maybe some of your cool ones will be included in the...
-
RE: Stop/Start Server
I think they can also be server admins to stop. Of course, if your DBAs are admins on the box or domain admins, they can do this as well. The...
-
RE: Calling an ASP page using xp_cmdShell
It's possible. xp_cmdshell runs under the SQLAgent context. run this as an account and then try it.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Permissions to run extended procedures sp_OACreate
I might be tempted to build some app or job that will read the msg from a table and then send it to MSMQ. Slightly delayed from immedate send, but...
-
RE: Backing out Upgrade to Service Pack 3a
uninstall SQL and reinstall, apply sp2.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Mixing NT security with SQL
That's the server side. You add your users as NT Auth, include rights for the databases/objects. These should match which rights you need for access. If you are having issues...
-
RE: DB Maintenance Plan not running
I'd drop and rebuild the plan.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 15 posts - 35,836 through 35,850 (of 39,771 total)