Viewing 15 posts - 13,456 through 13,470 (of 18,923 total)
I think that you'd have to limit the windows remote access somehow. Other than that I can't offer much help on this topic.
September 7, 2005 at 1:11 pm
How are you querying that table??
Can we see the ddl?
September 7, 2005 at 1:09 pm
I'm sure there's a way, but sql server is mean to give access to multiple users at the same time... I don't see why you'd what to limit this to...
September 7, 2005 at 12:37 pm
Err, why can there be only one person at the time using the system?
September 7, 2005 at 12:23 pm
You can net send on the network and warn everyone that the server is shutting down.
September 7, 2005 at 12:12 pm
Have you checked openrowset/openquery?
September 7, 2005 at 12:05 pm
Actually it's RG, but I see the confusion with the underlining in the forum... problem solved now
.
September 7, 2005 at 12:03 pm
That one I didn't test. You'll have to check it out and report back. I assume that the view can update only one table at the time... ...
September 7, 2005 at 11:50 am
Seems logical... Access usually uses sp_help* to get the tables definition. If this info is not in the view, I don't see how it could use it. Maybe...
September 7, 2005 at 11:45 am
Plese post :
-DDL
-Sample data
-expected results
September 7, 2005 at 11:44 am
Sorry for the unforseen problem, I had never experienced it (using mostly sps here). Anyways I was able to recreate the problem like this.
1 - Create a...
September 7, 2005 at 11:34 am
Sorry I hadn't understood the user defined datatype part. As Noeld said, you have to unlink the UDD, drop it, recreate it and then rebind it the the columns....
September 7, 2005 at 9:19 am
That can't really cause problems... why aren't you just altering the tables?
Also why aren't you using varchar()?
September 7, 2005 at 9:13 am
Viewing 15 posts - 13,456 through 13,470 (of 18,923 total)