Viewing 15 posts - 5,521 through 5,535 (of 49,571 total)
sault (6/22/2015)
They never import or write the data into the main database unless a manual backup is done.
Seriously, you need to spend some time reading up on what...
June 23, 2015 at 2:47 am
SQLRNNR (6/22/2015)
GilaMonster (6/22/2015)
Eirikur Eiriksson (6/22/2015)
GilaMonster (6/22/2015)
June 23, 2015 at 2:38 am
Eirikur Eiriksson (6/22/2015)
GilaMonster (6/22/2015)
June 22, 2015 at 1:48 pm
Luis Cazares (6/22/2015)
June 22, 2015 at 1:47 pm
sault (6/22/2015)
I am still back to how do I stop it.
Once more with feeling...
GilaMonster (6/22/2015)
June 22, 2015 at 1:41 pm
How many rows in the temp table?
What does that function do?
June 22, 2015 at 10:08 am
That's not SQL Server code.
This is a Microsoft SQL Server site, we're not going to be much help in writing triggers and functions for Oracle. Maybe try an Oracle-focused...
June 22, 2015 at 9:37 am
Post the information here. Not as an image, as something people who are interested in helping you can copy, run and use to test any code they write.
June 22, 2015 at 9:28 am
Need more information.
Table definitions please, sample data, examples of the data modifications that will fire the triggers and details of what you want the triggers to do to the data.
June 22, 2015 at 9:20 am
sault (6/22/2015)
But I do need to find a fix.
Check the scheduling for the 3rd party backup tool. SQL does not control the frequency of backups, if there are...
June 22, 2015 at 9:19 am
https://www.google.com/?gq=What+is+an+access+violation
First result I get is an MSDN blog post explaining what an access violation is.
And no, nothing to do with resource contention. It's a severe error relating to illegal memory...
June 22, 2015 at 9:14 am
A CTE isn't a temp table, it's visible to the query (singular) that immediately follows it, that's all. Not the rest of the batch.
-- update 1
WITH X_SET_PREOP
...
June 22, 2015 at 9:12 am
Err, there's no such version as SQL 2003.
You mean SQL 2005?
See http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ for saving execution plans.
For the index definitions, you can see them in Management Studio, should be same place...
June 22, 2015 at 8:55 am
No, not 'a large number of log files being backed up', a large number of log backups. Very, very different thing.
Check the scheduling for the 3rd party backup tool. SQL...
June 22, 2015 at 8:52 am
It's starting to look like the replication which keeled over last week did so because the passwords on the distributor were changed. If I've lost my entire Saturday because someone...
June 22, 2015 at 8:39 am
Viewing 15 posts - 5,521 through 5,535 (of 49,571 total)