Viewing 15 posts - 1,816 through 1,830 (of 6,216 total)
I agree having the timestamp is worth something. Same reason I don't use devices for backup. I'd rather backup an entire folder than a specific file, that way when I...
August 4, 2003 at 4:33 pm
UDL's are ok, as are DSN's for that matter, both exist to let you easily edit connection strings. The downside is that they aren't secure if you're using a sql...
August 4, 2003 at 4:17 pm
I didnt think you needed datareader/write, but I work in an environment small enough that I make all the changes and haven't needed to delegate. If you trust them enough...
August 4, 2003 at 12:47 pm
It should be possible, have not experimented with it so far. You need a SAN to do it since a snapshot is really a copy over of the file allocation...
August 4, 2003 at 12:41 pm
I'll have to admit to having never set up a maintenance plan on an MSDE instance. Didnt even know you could! Have to add it to my list of things...
August 4, 2003 at 12:38 pm
Do you mean to script out the objects? You can do that easily in Enterprise Manager, just right click the object.
Andy
August 4, 2003 at 12:34 pm
Totally agree that the Access SQL was a wrong step. I see in Access 2003 (and maybe earlier) there is a setting to generate ANSI SQL. I think there are...
August 4, 2003 at 4:45 am
Not a bad idea, though you still risk (no worse than before of course) the affect they can have on your server.
One thing we talked about but have not done...
August 3, 2003 at 4:16 pm
Is the select back in a proc? How about adding with recompile to force it to build a new plan each time, see what happens?
Andy
August 3, 2003 at 7:43 am
The other, messier way is to write the value out somewhere, either to a global temp table or a permanent table, then retrieve it from the calling session.
Andy
August 2, 2003 at 4:36 pm
Does it happen the first time every time, or the first time per session? If the later it could be the time to build your query plan.
Why would you insert...
August 2, 2003 at 4:35 pm
I think what you're seeing is standard logging by SQL and not a result of the job. To test this theory, just run a backup from QA, you'll see it...
August 2, 2003 at 10:06 am
I'd be surprised, but it doesn't hurt to try. Considered going back to SP2? By remote transaction you mean one from another SQL Server, or a distributed transaction, both?
Andy
August 2, 2003 at 10:01 am
I also have a group that does their own queries. I'd love to get them into QA to avoid some of the blocking issues, but Access not only has the...
August 2, 2003 at 9:56 am
Havent tried it. I'd have to experiment with the semi synch thing, could be dicey - depends I suppose on what the overall latency is and whether you can afford...
August 2, 2003 at 9:49 am
Viewing 15 posts - 1,816 through 1,830 (of 6,216 total)