Viewing 15 posts - 496 through 510 (of 1,166 total)
I Agree Andy, better to change permissions...
MohammedU
Microsoft SQL Server MVP
January 22, 2007 at 7:04 pm
You can use transactional replication and change the snapshot shot option "Keep the existing data unchanged"
MohammedU
Microsoft SQL Server MVP
January 22, 2007 at 7:01 pm
check sp_dropuser and sp_adduser commands...
In 2005 you can do this using ALTER USER command..
MohammedU
Microsoft SQL Server MVP
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..
MohammedU
Microsoft SQL Server MVP
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?
MohammedU
Microsoft SQL Server MVP
January 22, 2007 at 6:33 pm
Based on my testing it is different and you can test too using 2005 profiler...
MohammedU
Microsoft SQL Server MVP
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...
MohammedU
Microsoft SQL Server MVP
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...
MohammedU
Microsoft SQL Server MVP
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...
MohammedU
Microsoft SQL Server MVP
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
MohammedU
Microsoft SQL Server MVP
January 22, 2007 at 12:42 pm
Server should be in single user mode...If you are modifying system tables...
MohammedU
Microsoft SQL Server MVP
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.
MohammedU
Microsoft SQL Server MVP
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...
MohammedU
Microsoft SQL Server MVP
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...
MohammedU
Microsoft SQL Server MVP
January 22, 2007 at 12:08 pm
If you are restoring database for QA/test better to use 64bit...
MohammedU
Microsoft SQL Server MVP
January 22, 2007 at 12:06 pm
Viewing 15 posts - 496 through 510 (of 1,166 total)