Viewing 15 posts - 35,791 through 35,805 (of 39,720 total)
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...
September 29, 2003 at 9:53 am
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...
September 29, 2003 at 9:45 am
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...
September 29, 2003 at 9:43 am
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...
September 24, 2003 at 5:09 pm
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/
September 24, 2003 at 4:52 pm
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...
September 24, 2003 at 4:50 pm
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/
September 24, 2003 at 10:26 am
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...
September 24, 2003 at 10:25 am
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/
September 24, 2003 at 10:22 am
I'll say that Patrol works, but it can be configured indefinitely. For example, we setup space holders, 1GB files on disks. When the disk space drops below some value, Patrol...
September 24, 2003 at 10:20 am
Check for triggers as well.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 24, 2003 at 10:16 am
You can introduce NT auth, but this is Per connection. Each connection can be set to connect with different access. How are you connecting with the IDE. Are you using...
September 24, 2003 at 10:15 am
Patrol can do this, but I'm not sure you really want this in "one console". Sounds good, doesn't work. You need to be able to distribute work from multiple consoles....
September 24, 2003 at 10:12 am
Why use a temp table? Could you not use a perm table? What does the sproc do?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 24, 2003 at 10:11 am
Backup and restore is the best way. If it's a template db, this is easy to script in T-SQL.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 24, 2003 at 10:09 am
Viewing 15 posts - 35,791 through 35,805 (of 39,720 total)