Viewing 15 posts - 496 through 510 (of 1,166 total)
I Agree Andy, better to change permissions...
January 22, 2007 at 7:04 pm
You can use transactional replication and change the snapshot shot option "Keep the existing data unchanged"
January 22, 2007 at 7:01 pm
check sp_dropuser and sp_adduser commands...
In 2005 you can do this using ALTER USER command..
January 22, 2007 at 6:56 pm
I think so... but to modify any system tables your server should be in single user mode with DAC..
January 22, 2007 at 6:34 pm
Can you be more specific...
I didn't get your question...domain account is sql service account or user account?
January 22, 2007 at 6:33 pm
Based on my testing it is different and you can test too using 2005 profiler...
January 22, 2007 at 6:30 pm
You can modify the script as needed...
CREATE PROCEDURE sp_JobSchedule_rpt
AS
declare @x int, @y int, @z int
declare @counter smallint
declare @days varchar(100), @day varchar(10)
declare @Jname sysname, @freq_interval int, @JID varchar(50)
SET NOCOUNT ON
create table...
January 22, 2007 at 1:19 pm
Logon to your sql server and open the outlook cleanup items from Inbox, sent items, deleted items etc..
or ask your exchange admin to cleanup the mail box of that server...
January 22, 2007 at 1:11 pm
I don't think it will corrupt/delete your cubes but if your cubes are accessing the data from the uninstalled sql then cube refresh will fail...
Make sure you have the backup of...
January 22, 2007 at 12:45 pm
I don't think it allows more than five at a give time to the servers...
Check the following articles/docs...
http://www.developer.com/db/article.php/3502746
January 22, 2007 at 12:42 pm
Server should be in single user mode...If you are modifying system tables...
January 22, 2007 at 12:32 pm
I don't think there is any built in procedure which does this. You need to write your own script or check for any third party tools for this.
January 22, 2007 at 12:27 pm
I don't think you required when you install RS on IIS box but you do need licence if you install RS on a non-sql server box.
All components (AS,RS,SSIS) of sql...
January 22, 2007 at 12:12 pm
May be it is by desing for security reasons so why don't you grant to dbo to use in tempdb...
January 22, 2007 at 12:08 pm
If you are restoring database for QA/test better to use 64bit...
January 22, 2007 at 12:06 pm
Viewing 15 posts - 496 through 510 (of 1,166 total)