Viewing 15 posts - 6,421 through 6,435 (of 7,429 total)
Sorry no you cannot turn off using a transaction log.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 12, 2002 at 10:41 am
As long as it works I say use it, then evaluate it later to make better. The only major thing I see is the use of a cursor which I...
April 12, 2002 at 10:40 am
What settings are you referring to?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 12, 2002 at 10:07 am
Ok this file looks fine. However does he have OLAP server items installed for SQL. If so then take a look here at MS KB Article
April 12, 2002 at 10:01 am
Something like this should do the job. Basically this is based on a table (tblEmployees) where the person has an IDENTITY field INDEX and the ReportingMgr field is the reporting...
April 12, 2002 at 9:47 am
Not sure of a number by I would look at all events under Locks except
Acquired and Released
Starting items for Stored Procedures and TSQL to see what items happen before the...
April 12, 2002 at 9:10 am
DO not find anyway this is possible. However you may be able to enforce with a trigger.
"Don't roll your eyes at me. I will tape them in place." (Teacher on...
April 12, 2002 at 8:56 am
DO you also need to get the childrens children in this process?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 12, 2002 at 8:53 am
Ok so the concern is that the clients other apps connecting to the same server may be adversly affected. But if I understand correctly, if all your clients are Windows...
April 12, 2002 at 8:47 am
Ok watch the locks being held with Profiler and see if one is holding a lock for long period of time. This should pinpoint the issue since you should be...
April 12, 2002 at 8:42 am
Sorry forgot about the fact text can be a varibale type for an input parameter. Any other way will not work.
"Don't roll your eyes at me. I will tape them...
April 12, 2002 at 8:11 am
There should be two files left behind by the install I cannot rememeber their names but they are something like sql(something).log and cnfg but they should have been created on...
April 12, 2002 at 6:25 am
Haven't found anything but this should not be an issue as long as the drive and path are available to the cluster. You should be able to set the path...
April 12, 2002 at 6:11 am
You could store the file in a varbinary column but I don't have code for that. This would be the best way though since it should retain the files formatting...
April 12, 2002 at 6:05 am
Several things can cause this, primary being the query takes to long to return. If the timeout comes immediately then do you have the site to expire immeditely? Any more...
April 12, 2002 at 5:58 am
Viewing 15 posts - 6,421 through 6,435 (of 7,429 total)