Viewing 15 posts - 1 through 15 (of 58 total)
That hadn`t crossed my mind and you are absolutely right. Its a recipe for disaster. How to kill every database in one easy step.
I think I`ll either a. investigate...
July 9, 2010 at 6:36 am
A master table with views in each db may well be the way forward.
The user will always sit in each db. I`ll need to double check to ensure they all...
July 9, 2010 at 6:16 am
I can easily isolate just the databases that I am interested in via sysdatabase to ensure the trigger ran.
What I have is an old third party application that is no...
July 9, 2010 at 5:43 am
I thought that might be the answer but I was hoping there was a more elegant way to do it. It means that I`ll have to amend the trigger as...
July 9, 2010 at 5:31 am
We are looking at using 64bit.
Database size is not a major concern, 2Tb (including 2 years growth). So looking at around 12 million documents. I am concerned by the speed...
April 8, 2010 at 6:43 am
I know. I can think of several reasons why it gives me the shivers.
1. Contamination of data.
2. Hard to DR, backup individual data sets.
3. Users updating the wrong data.
4. Security...
February 16, 2010 at 9:43 am
Same client processID, as I`m sure you guessed.
The spanners !
November 30, 2009 at 8:41 am
I`ve passed through the vale of afraid and I`m firmly in the dark forest of dismayed.
November 30, 2009 at 8:13 am
Yep endtime of the first call, is 10 milliseconds sooner than the starttime of the second call. Nothing happens inbetween the two calls.
Same result set from both. Why on earth...
November 30, 2009 at 7:56 am
The application was written is FoxPro, initially using a Fox backend. However they moved to a SQL backend with very little recoding. We are finding performance is shocking though.
October 15, 2009 at 1:55 am
Have you double checked on the second server to ensure there are no issues with the database. Offline, corrupt etc ?
October 14, 2009 at 7:18 am
Or to create a temp table pre populated with data from existing table
select col1, col2
into #temp
from table1
October 14, 2009 at 7:15 am
You need to expand your table. Having a identity column which contains a key. Plus a column to store who updates the record.
Table
IdentityCol - 1,2,3 etc
ValueCol - the value you...
October 14, 2009 at 7:14 am
When you created the linked server what login method did you define. If you are using a specific login does that have the correct rights ?
And the obvious - is...
October 14, 2009 at 7:10 am
Viewing 15 posts - 1 through 15 (of 58 total)