Viewing 15 posts - 1,951 through 1,965 (of 6,216 total)
I think so - we dont have final shipping costs yet to know if it makes sense, but we'll try to get a copy to anyone that wants one.
Andy
July 7, 2003 at 2:59 am
If you just need a copy, why not go with snapshot replication? It handles all the details for you and keeps it simple, more so than writing your own code...
July 4, 2003 at 5:07 pm
Insert a row into a table, have your job poll that table, when it finds a row, run the job you need to run.
Andy
July 4, 2003 at 7:26 am
July 3, 2003 at 1:52 pm
Well, not so much approles as the idea that applications should authenticate rather than users (to the db). SQL logins work as good as approles without the ugly side affects.
Andy
July 3, 2003 at 1:51 pm
Either using a view, maybe run sp_refreshview? I think SQL caches some meta data about the objects as far as the linked server too.
Andy
July 3, 2003 at 10:20 am
I dont understand - are you trying to archive data or create a second reporting server?
Andy
July 3, 2003 at 10:19 am
I dont see any errors. Do you have the log reader set to continuous (-continuous), it's the default setting?
Andy
July 3, 2003 at 10:16 am
An application role would work, but it means modifying all your other apps. You could put a trigger on some of the main objects to roll back any change where...
July 3, 2003 at 10:14 am
July 3, 2003 at 10:12 am
Im not an Excel developer but I think you're going to have to write code to do it. Far as I know there is no data binding, that would be...
July 3, 2003 at 4:50 am
Im using the same setup, no problems. Turn logging on for the snapshot job, use -outputverboselevel 2 -output c:\snapshot.txt (I think, double check BOL), see what you get.
Andy
July 3, 2003 at 4:48 am
July 3, 2003 at 4:29 am
Changed what? Data in a table, schema, the mdf itself?
Andy
July 3, 2003 at 4:20 am
Need to turn on logging. Add -outputverboselevel 2 - output c:\replinfo.txt to the job step for the log reader and try again. Then you can see why.
Andy
July 2, 2003 at 2:56 pm
Viewing 15 posts - 1,951 through 1,965 (of 6,216 total)