Viewing 15 posts - 5,056 through 5,070 (of 7,429 total)
A good way to get code that best suits your needs, especially if you are in a specific line of business is to use code or examples based that you...
August 24, 2002 at 5:29 pm
First check Event Viewer if you have not already done and see if anything may be reporting issues. Also check the SQL Server logs for similar issues. Finally, if this...
August 24, 2002 at 4:59 pm
Did you run witrh existing connections to make sure you just didn't miss it. Also, if pooling is properly working and you have occasionally connections that keep it open then...
August 24, 2002 at 4:54 pm
Again profiler should pinpoint where they originated from exactly.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 24, 2002 at 4:46 pm
In 7 the items start xp_trace... and can be found in BOL. Also you can turn on security auditing in SQL in general. This can be found by right clicking...
August 24, 2002 at 4:45 pm
Yes post the data from the dump file and also if not already done so check Event Viewer applications and system to see if any other details there.
"Don't roll your...
August 24, 2002 at 4:40 pm
For every orginazatio you work for this will be different. But a DBA is primarily the person(s) responsible for maintainence and upkeep of the server. They should handle authentication and...
August 23, 2002 at 8:31 am
Logging means have it write a record to a table that the SP was used and at what time.
"Don't roll your eyes at me. I will tape them in place."...
August 23, 2002 at 7:18 am
Try SYSTEM_USER.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 23, 2002 at 7:16 am
To the best of my knowledge the start time is the only thing you can get, not the run time total.
"Don't roll your eyes at me. I will tape them...
August 23, 2002 at 7:10 am
Do you use a Specific Username and ID to connect to the ISP machine? How do you defien the connection in the DTS package? Do you have the ISP server...
August 23, 2002 at 5:42 am
What version of SQL?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 23, 2002 at 5:35 am
Installing and running is done for the most part. Not really to many issues from a Service Pack with hardware unless they change drive support in SQL. Generally they give...
August 23, 2002 at 5:28 am
Sorry, if you are trying to pass characters into a stored procedure via variable you can use a variable of text type for input and output in an SP. If...
August 23, 2002 at 5:11 am
Steve is correct. 7 stored the data always as a pointer on the table to a location elsewhere in the file. 2000 can store in the table from 24 to...
August 23, 2002 at 5:00 am
Viewing 15 posts - 5,056 through 5,070 (of 7,429 total)