Viewing 15 posts - 4,486 through 4,500 (of 6,105 total)
It would have basically the same effect as a cursor in a stored procedure. The difference is, the trigger fires every time the specified database operation (INSERT, UPDATE, or DELETE)...
February 28, 2003 at 9:19 pm
When you say table, do you mean the system table like sysxlogins or do you mean a user table. If you mean a user table, you'll need to know the...
February 28, 2003 at 2:35 pm
These docs work if you are using a Microsoft Certificate Server. They don't cover the case where you need a 3rd party CA for B2B. After all, if you and...
February 28, 2003 at 10:11 am
IIS Lockdown tool helps greatly, but it isn't the end of it since you have to keep up with the bulletins that have come out since then as well.
As far...
February 28, 2003 at 9:03 am
You can install either SQL 2K MSDE, Personal Edition, or Developer Edition (only available with MSDN) to get a SQL 2K database engine on your laptop.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to...
February 28, 2003 at 8:23 am
Underscores are only supported by DNS for RR records such as identifying where services are. They aren't for A records, which identify hosts.
Since the virtual SQL Server is tied to...
February 28, 2003 at 8:16 am
Do a refresh in EM first, just to make sure you get the latest status. Executing means they are running. Yes, you can stop the jobs, but without knowing the...
February 28, 2003 at 7:37 am
It also probably needs to be said that if you're on Win2K and above (WinXP and 2003) across all machines that will talk in this manner, you also have the...
February 28, 2003 at 7:24 am
No argument on pulling the data back from the databaseand processing it at the middle tier. My only concern from a performance perspective are the decoys. You've indicated that these...
February 28, 2003 at 7:19 am
Keep in mind that until you move the .DLL, someone can always re-add it. However, to be able to move the .DLL, you'll want to drop all stored procedures that...
February 27, 2003 at 1:57 pm
Sure. You still deal with the issues of having an FTP server on your SQL Server and all the security issues that would normally entail. That's usually enough to make...
February 27, 2003 at 11:52 am
I agree. I don't typically run IIS/SQL Server except on my workstations that I use for development/testing. However there I know the performance hit, security concerns, etc. I certainly don't...
February 27, 2003 at 10:35 am
Can you post some basic create (DDL - Data Definition Language) statements on the objects you are using? While your idea looks clear, it'll help with the code. Also, it...
February 27, 2003 at 7:58 am
You always have an option of creating a role and putting the users (Windows groups still map to a database user) in the role and granting permissions to the role....
February 27, 2003 at 7:51 am
It really depends on what's kicking off the backup. If it's being kicked off through SQL Agent, you can query the appropriate tables in msdb. However, if you have an...
February 27, 2003 at 7:37 am
Viewing 15 posts - 4,486 through 4,500 (of 6,105 total)