Viewing 15 posts - 36,796 through 36,810 (of 39,720 total)
Set dkrConnection = Server.CreateObject("ADODB.Connection")
Set dkrResult = Server.CreateObject("ADODB.Recordset")
dkrConnString = Application("driver=SQL Server;server=db1\steve;database=northwind")
dkrConnection.Open dkrConnString
dkrQuery = "select * from orders"
' Execute the query
dkrResult.Open dkrQuery, dkrConnection
if not dkrResult.EOF then
response.write(dkrResult.fields("customerid").value)
dkrResult.movenext
end if
set dkrResult =...
November 26, 2002 at 5:30 pm
Check the connections in the package. I think these are login errors. When you run in design mode, the package is running form your workstation. When you run it from...
November 26, 2002 at 5:26 pm
Agree with Anatares. I think LogExplorer will attach to your log and work, but without regular backups, you may be stuck.
Steve Jones
November 26, 2002 at 5:22 pm
Someone likely messed with the system tables.
I'd detach the databases and then reattach them again. Should repopulate the system tables.
Steve Jones
November 26, 2002 at 5:15 pm
What do you mean see? in SP_WHO? Enterprise Manager?
Steve Jones
November 26, 2002 at 5:08 pm
In working with MS Support and Tuning groups, they do not really look at the % costs. The reason is that these are so fluid and can change. The bigger...
November 26, 2002 at 2:04 pm
Is the cache hit ratio taking a hit? Have you checked to see if there are lots of physical reads? You can run the queries in QA at the same...
November 26, 2002 at 1:51 pm
If you are tight on disk space, what about a remove disk backup? Preferred to tapes.
Also, look at SQL Litespeed (www.sqllitespeed.com). It compresses the backups and runs faster than...
November 26, 2002 at 1:35 pm
What do you mean? Limited set of data?
It really depends. There are some generators for data, but they tend to be a little pricey and they work for certain scenarios...
November 26, 2002 at 1:33 pm
Can they just take a differential backup? Replication will work, but that may be overkill.
If it's a few tables, you could just create an audit table and use triggers, then...
November 26, 2002 at 1:22 pm
What does the insert trigger do? Does it update the table? Might cause a 2nd trigger to fire there.
Steve Jones
November 25, 2002 at 2:54 pm
No. I asked this question of MS last year for the same reasons. You must license each proc.
Licensing is per physical CPU, however, not logical. The new hyperthreading CPUs appears...
November 25, 2002 at 10:29 am
select * is built at view compile time. You should really specify the columns so you know to add them to the view (with Alter View).
Steve Jones
November 25, 2002 at 10:06 am
November 25, 2002 at 9:45 am
Viewing 15 posts - 36,796 through 36,810 (of 39,720 total)