Viewing 15 posts - 901 through 915 (of 2,897 total)
Is every single record wrong ?
If not, how will you identify which ones need fixing ?
May 20, 2011 at 12:37 pm
I also like to keep a distinction between system stored procedures and non-system stored procedures. I have a few utility stored procedures that are in the master database, and I...
May 20, 2011 at 12:35 pm
I think that whatever account is running SQL Services would also need permissions to the folder .... It's been a while since I've set up replication though.
May 19, 2011 at 12:34 pm
Do a test with a smaller amount of data to see what happens
May 19, 2011 at 11:52 am
If you use snapshot replication, then I don't think identity columns matter becuase all the data at the subscriber gets dropped & repopulated.
Yes, the folder contains actual data during replication.
May 19, 2011 at 11:22 am
You could set up a server side trace to log the information you want.
May 19, 2011 at 4:13 am
I was getting strange results with filters, and found it more reliable to export the trace file to a SQL table, then run selects with WHERE
May 18, 2011 at 5:02 pm
Edited to remove wrong answer.
May 18, 2011 at 8:00 am
I use this for character string searches. It will bring back 1 row for each sp. Then open the SP to search for all the uses. You can easily tweak...
May 17, 2011 at 3:47 pm
INTOX (5/17/2011)
Hmmm, dunno, maybe those stored procedures is correct :ermm:btw I uploaded that backup http://www.mediafire.com/?jzefzg0s0c7mr1z
so you can see how its look like, maybe the situation isn't so complicated?
Have you...
May 17, 2011 at 12:49 pm
sqluser_8119 (5/16/2011)
If it is a matter of shrinking the database, can I shrink it while it is in use? What are the ramifications?
Shrinking causes fragmentation and uses resources, then it...
May 17, 2011 at 12:16 pm
This is how I did it, although there's probably a better way.
- Put the column names into a sql table with pipe delimiters as 1 long string.
- BCP the columns...
May 17, 2011 at 11:57 am
As I recall, you can right-click on the publishers and subscribers and choose "script as ..."
May 16, 2011 at 6:56 pm
I don't think compatibility level would affect it. It should work .... give it a try.
If you are running on a SQL 2000 instance, then you would need to find...
May 16, 2011 at 12:39 pm
Viewing 15 posts - 901 through 915 (of 2,897 total)