Viewing 15 posts - 481 through 495 (of 644 total)
manju3606 (12/15/2011)
i wanted to find all relationship of specified tables(for example i am speciying Table ‘A’
Table ‘A’ has child relationship with Table ‘B’ and Table ‘C’ and Table...
December 15, 2011 at 11:59 pm
So there seems like nothing much can be done besides granting the user SysAdmin rights, is that correct?
I think, you don't need to grant SysAdmin rights.
You can try...
December 15, 2011 at 11:30 pm
Tava (12/15/2011)
I don't get any errors, the script executes as a Scheduled task and then no backup gets created i have to make the user a SYS_ADMIN role...
December 15, 2011 at 9:58 pm
pallavi.unde (12/15/2011)
can you please tell me how to recreate the database users on server...
Ninja's_RGR'us (12/15/2011)
Google not working??
Nice one Ninja 😀
However, if you are still not able to find it...
December 15, 2011 at 6:59 am
GilaMonster (12/15/2011)
Divine Flame (12/15/2011)
I suggested him to put this SQL script inside a SQL Agent Job rather than windows scheduled task.On SQL Express edition?
Ah!!! wasn't aware that Express Edition...
December 15, 2011 at 3:32 am
GilaMonster (12/15/2011)
Divine Flame (12/15/2011)
GilaMonster (12/15/2011)
Divine Flame (12/15/2011)
December 15, 2011 at 2:18 am
*Take a full backup monthly 1 once.
* Take a file group backup of latest file group daily
* Take a differential backup daily
* Take hourly transaction log backup.
If you are...
December 15, 2011 at 1:08 am
GilaMonster (12/15/2011)
Divine Flame (12/15/2011)
December 15, 2011 at 1:02 am
By the way, the T-SQL script you provided was not a stored procedure. It was a batch only. So you may need to wrap this script under a stored procedure.
It...
December 15, 2011 at 12:12 am
Now I have to have the User who is assigned the Backup task as a "SysAdmin" inside security which i don't want to do. I thought if i assign the...
December 14, 2011 at 11:41 pm
engrshafiq4 (12/14/2011)
i am using ACE provider to insert bulk data from my web application to sqlserver.and the server do not support ACE provider.
Everybody has suggested you to use SSIS. If...
December 14, 2011 at 11:10 pm
Yes, Please post the backup script here so that we can analyze the requirement.
December 14, 2011 at 10:24 pm
Lynn Pettis (12/14/2011)
Divine Flame (12/14/2011)
Everybody is going insane here 😀 Reading the posts of this thread is fun & crazy 😎
Have to agree with Gus, going?
Actually, if you do take...
December 14, 2011 at 10:17 pm
Koen Verbeeck (12/14/2011)
Divine Flame (12/14/2011)
Everybody is going insane here 😀 Reading the posts of this thread is fun & crazy 😎
I hope you didn't start at the beginning of the...
December 14, 2011 at 6:50 am
Everybody is going insane here 😀 Reading the posts of this thread is fun & crazy 😎
December 14, 2011 at 6:40 am
Viewing 15 posts - 481 through 495 (of 644 total)