Viewing 15 posts - 1,036 through 1,050 (of 1,064 total)
Try specifying the Database and Owner of the stored procedure e.g.
EXEC pubs.dbo.DRFExportOMC
November 19, 2002 at 2:53 am
Are there any delete triggers on the table?
If so, are they doing something that will degrade performance.
November 14, 2002 at 5:25 am
You have put @strCriteria in quotes, so it is searching for the literal '@strCriteria', not the contents of the variable. Just remove the quotes:-
(SELECT DISTINCT notes_key FROM notescustlog WHERE CONTAINS(notes_text,...
November 11, 2002 at 7:24 am
You can check by executing the system stored procedure sp_helpdb.
I'm sure it will give you the same answer as enterprise manager
November 6, 2002 at 4:23 am
In order for SQL Server to come up with the best way to execute your query, it needs statictical information on the distribution of the data (e.g. if half of...
November 6, 2002 at 2:37 am
Take a look in the FAQ or Download section of http://www.sqldts.com for some possible ways of doing this
October 29, 2002 at 6:15 am
Your update query needs to join the old and new tables similar to this
UPDATE OLDDATA SET olddata.col1 = newdata.col1,....
FROM NEWDATA
INNER JOIN OLDDATA on NEWDATA.ID = OLDDATA.ID
Your append query should...
October 29, 2002 at 6:10 am
RPC's show you the call coming into SQL Server. SP's show you all Stored Procs being executed.
For example, if you have a stored procedure called SP1, and this in turn...
October 29, 2002 at 6:00 am
Correct!
As far as I'm aware, the Optimizer doesn't know what will be cached at the time it compiles the query, and therefore doesn't take this into consideration when compiling a...
October 28, 2002 at 8:36 am
I know this doesn't answer the original question but, if you are trying to tune a query, looking at logical reads should be good enough.
Whether they are physical reads or...
October 28, 2002 at 7:14 am
It doesn't matter whether it's being started by Enterprise Manager or Service Manager, the important bit is how SQL Server itself is starting.
I only have an NT4 workstation in front...
October 28, 2002 at 4:05 am
How is SQL Server being started?
If SQL Server is logging as a particular account (as opposed to the system account), has the password for the account changed recently, or the...
October 28, 2002 at 3:10 am
If you have a multi processor box, sometimes when you do an sp_who2 you will see what appears to be multiple spids per connection.
In fact they are all the...
October 28, 2002 at 3:04 am
The problem is that you have a GO statement at about line 14.
That mean that anything beyone that line isn't treated a part of the procedure, and is instead...
October 28, 2002 at 2:54 am
Your problem is probably on the line:-
Set xmlresponse = New Msxml2.DOMDocument30
You have to use CreateObject in VB Script rather than New
October 23, 2002 at 8:33 am
Viewing 15 posts - 1,036 through 1,050 (of 1,064 total)