Viewing 15 posts - 901 through 915 (of 2,898 total)
You could rename the table to something more useful.
And next time you import from Excel, you get an opportunity in the wizard to give the table a proper name.
May 24, 2011 at 11:01 am
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
Viewing 15 posts - 901 through 915 (of 2,898 total)