Viewing 15 posts - 5,731 through 5,745 (of 6,105 total)
You might want to look at getting the SQL Server 2000 Administrator's Companion (http://www.microsoft.com/mspress/books/4519.asp) or the Pocket Consultant (http://www.microsoft.com/mspress/books/4660.asp) from MS Press. Those are both a little easier to...
February 3, 2002 at 6:09 pm
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:...
February 2, 2002 at 10:49 am
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...
February 2, 2002 at 8:47 am
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...
February 2, 2002 at 8:34 am
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
February 2, 2002 at 8:15 am
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)...
February 2, 2002 at 8:01 am
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....
February 2, 2002 at 7:49 am
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...
February 2, 2002 at 7:35 am
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...
February 1, 2002 at 9:33 pm
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,...
February 1, 2002 at 3:23 pm
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...
February 1, 2002 at 2:56 pm
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...
February 1, 2002 at 2:36 pm
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,...
February 1, 2002 at 2:29 pm
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...
February 1, 2002 at 2:23 pm
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
February 1, 2002 at 2:14 pm
Viewing 15 posts - 5,731 through 5,745 (of 6,105 total)