You probably want to take a look at database roles. If it's simply the ability to read and write to tables, you have two built in roles for you:...

You are wanting to create a SQL Server job then through SQL Server Agent. You can have job steps that call stored procedures and the like. Here's the Books...

If you mean pass a parameter to a trigger, no. Triggers are fired automatically by SQL Server and are not called by the user. What are you trying...

Here is SQL Server MVP Narayana Vyas Kondreddi's test on a smaller scale (5 million rows) and some of the performance improvements he saw:

http://vyaskn.tripod.com/federated.htm

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

It's looking for a local drive. If you are using shared storage, such as connecting to a SAN or SCSI drive array, there should be appropriate hardware (and/or software)...

Typically we use RETURN from the stored procedure to signal something unrelated to the data we're looking for. For instance, returning 0 (default) means successful completion of the procedure....

The issue is the difference between local and global temporary tables. When we use a single #, the temporary table only stays around for the duration of your dynamic...

Instead of that you might look at HOST_NAME() which will return the same information. The problem there is you are auditing the computer name and not the user logged...

Our network guys are using MRTG. They like it a lot. We may end up expanding its use since it is fairly straight forward. As for scripting,...

Ouch. If you've got shared logins, the system functions which help you identify users don't work. With respect to passing information to the triggers, if the information isn't...

We're still pretty much using Performance Monitor (Windows 2000 version) for most of what we need to do. However, two of the other tools we have in place are...

In most cases we've built our own backup jobs and scripted names based on hour or on weekday using ActiveX (VBScript) Scripting, so when we go to a restore situation,...

If you can connect from Access, then it sounds like the connection from the help desk software isn't defined correctly. You said you are making an ODBC connection and...

When the database is accessed by this application, does each user have to have permissions to access the database, or is it a shared account?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

In this case, the constraint is: DF__Contacts__Label__0B335E0F. I'm assuming the column was created with a DEFAULT value, because this looks like a SQL Server generated constraint name. However,...