Viewing 15 posts - 106 through 120 (of 166 total)
I finally figured out that I wasn't seeing the 64 bit files because they hide them if you're on a 32 bit machine. You have to click on the...
June 30, 2011 at 4:36 pm
This might be interesting to look at.
http://kenj.blogspot.com/2009/07/anatomy-of-missing-index-what.html
June 23, 2011 at 2:26 pm
It's really a matter of determining conclusively what works to "tear down" replication before refreshing a development or QA environment with the least effort. I believe that we've determined...
June 23, 2011 at 2:04 pm
I don't believe that you can change this. I think that I looked into it recently and the only option seemed to be dropping and creating the publication.
June 21, 2011 at 1:23 pm
I think that I might re-initialize the subscription and run the snapshot again, unless it's really too big to do that. You should see some message in the distribution...
June 20, 2011 at 3:57 pm
Since you originally said that "I have pakage varibale called "Source_Server" and I want to pass that value to my SQL script.", I posted links to articles about how to...
June 17, 2011 at 11:25 am
Found this.
http://technet.microsoft.com/en-us/library/ms140355.aspx
and this, with pictures.
http://www.sqlis.com/sqlis/post/The-Execute-SQL-Task.aspx
I've also used a script task to build the SQL and you can access the variables there too.
June 16, 2011 at 3:31 pm
June 16, 2011 at 3:27 pm
Is it possible that there are tables from other databases used in any of the views?
June 15, 2011 at 11:38 am
I've always used a dummy file with the correct structure for situations like this.
June 14, 2011 at 4:57 pm
This could be a permission issue on the data that you are querying for the SQL Agent service account. We had a similar issue and that's what it was....
June 14, 2011 at 10:12 am
What's the job do? I'm not sure that's a SQL Server message.
June 2, 2011 at 1:43 pm
I think that the sysalerts table in msdb is updated with the last occurrence, but I don't think there's a history table of all alerts that have occurred.
June 2, 2011 at 1:30 pm
You might want to ask RedGate about that. Are all of the backups that you're restoring using multiple files? Have you tried just restoring that database using the...
June 2, 2011 at 1:15 pm
It appears that Copy Permissions is an article property that may default to false. You can find it under Publication Properties > Articles > Article Properties.
June 2, 2011 at 1:04 pm
Viewing 15 posts - 106 through 120 (of 166 total)