Viewing 15 posts - 16 through 30 (of 97 total)
i found out the root cause of my problem. But need little help on this
ex:
declare @userid int,@username nvarchar(300),@companyname varchar(300),@job varchar(30)
select * from jobspec where userId=coalesce(@userid,userid) and...
May 18, 2010 at 9:40 am
Hi Paul,
its not the matter of reading the links. i already gone through those links. after that only i...
May 18, 2010 at 5:24 am
i tried with different scenario
ex:
declare @userid int,@username nvarchar(300),@companyname varchar(300),@job varchar(30)
select * from jobspec where userId=coalesce(@userid,userid) and username like coalesce(@username,username)+'%' and job=coalesce(@job,job),companyname like coalesce(companyname,@companyname)+'%'
.
.
.
.
it is working properly.But i have...
May 7, 2010 at 8:03 am
Yeah definitely i will take backups of all databases. then i will work..
Thank you very much
Regards,
Rock..
March 24, 2010 at 1:42 am
finally, which one is the best way to work around
1. script the file name,location and change the location with alter statement.
2.script to backup and restore in new location.
3.manually moving the...
March 24, 2010 at 12:29 am
nope. But i have mdf and ldf files of distribution database.
March 12, 2010 at 11:46 am
some times mistakes will happen. try to figure out the solution.
March 12, 2010 at 6:47 am
yes it is sqlsever 2008, i deleted the distribution database. and i created a new distibuted database i.e distribution1, i tried with one thing, i click on configure distribution setting...
March 12, 2010 at 2:26 am
its a work env-server, since yesterday i ahve been struggling for this. no other publication and scubscription is available. i just want to create a new distribution dataabse and a...
March 11, 2010 at 7:38 pm
yes i understand the problem, i googled and some of teh people saying that, if we remove the distribution database,publication,subscription then it will work fine. unfortunately i removed distribute
use...
March 11, 2010 at 6:36 pm
i got a huge error like "The concurrent snapshot for publication 'BetaDB01' is not available because it has not been fully generated or the Log Reader Agent is not running...
March 11, 2010 at 3:59 pm
Viewing 15 posts - 16 through 30 (of 97 total)