Viewing 15 posts - 1,051 through 1,065 (of 1,790 total)
Did you read the stuff in BOL? That would be the first step. When / if you have questions following that please post the specific question.
Additionally, Homebrew's point is...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 21, 2008 at 3:38 pm
I'm pretty confident there is no way to restore as you describe.
For removing files, see deleting data files in Books Online and you will have all that you need...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 21, 2008 at 11:08 am
Can you get the full share path from DFS so that you can put that in place? I don't know that SQL Server actually ties into DFS references as it...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 21, 2008 at 10:56 am
Yeah, I was thinking that since it was an install process that was failing but didn't want to get hopes up if it wasn't going to come to pass that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 21, 2008 at 10:53 am
I'm hoping that life wouldn't be related to SQL Server performance but... 😛
To fix this leave the job disabled. 🙂 Sorry, had to do it. Ultimately you are going to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 21, 2008 at 10:51 am
What are you seeing in the application log? Right click on my computer (on the server), manage, application log.... There should be some errors associated with the SQL Server process...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 21, 2008 at 10:47 am
I haven't used this but when you generate scripts for the database, (Right click on the database > Tasks > Generate Scripts) there is an option for "Script Bindings" which...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 14, 2008 at 3:31 pm
There is no cut and dry conversion for PL-SQL to T-SQL. Oracle loves using cursors, or at least all PL-SQL developers that I have been exposed to have loved to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 14, 2008 at 3:14 pm
This is not something I would proudly list in public but....
select 'select * into test.'+name+' from '+name from sysobjects where type = 'U'
Run this in the database and you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 14, 2008 at 2:43 pm
What do you see if you "select * from sysfiles" when connected to the database in question?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 12, 2008 at 1:04 pm
That is a lot to discuss but not really any questions. If the question is "Can SQL Server handle this type of environment?" the answer is yes but as always,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 10, 2008 at 4:03 pm
Jason,
This isn't an answer but just an observation based on some playing around that I have done over the last couple of days. From what I have seen the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 10, 2008 at 3:55 pm
It will create a new snapshot agent for the publication that you are creating and it will create a new log reader agent for that database. Any other publications that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 7, 2008 at 9:59 pm
Do you have the replicate schema changes set to true? That should make sure that they stay in sync with the publisher.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 7, 2008 at 9:53 pm
Rod - After thinking about it, I can't say that about #3. Not certain. So, test that but, you can leave the 2005 tools on there anyway just in case...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 7, 2008 at 3:18 pm
Viewing 15 posts - 1,051 through 1,065 (of 1,790 total)