Viewing 15 posts - 6,751 through 6,765 (of 9,244 total)
arie01 (8/24/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2011 at 2:19 am
It depends on lots of factors, for instance what location will be used for the primary server backups, a share on the primary server or a network location?
If you set...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2011 at 2:03 am
its a very popular\stable forum, you just need a webserver with support for active server pages 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 3:53 pm
Dj463 (8/24/2011)
No the server is not a part of windows cluster.
so how do you plan to install a clustered instance of SQL Server if the server is not part of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 3:02 pm
yes, use a database role and grant users access to the role
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 3:00 pm
flora M (8/24/2011)
Thanks for all the responses. I'll look for an option to do this from a stored procedure.
why??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 2:55 pm
Snitz forum is a good way of creating an issues forum\tracker
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 2:52 pm
in truth, to SSRS, they are system databases. They hold metadata and temporary storage (sort of like a TEMPDB) used by the reporting services instance(s)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 2:42 pm
flora M (8/24/2011)
[font="Courier New"]CREATE VIEW...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 2:38 pm
ok the certificate is or at least should be bound to the fully qualified computername which you have changed. Self certs do also seem to be an issue i have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 12:35 pm
This will work
exec sp_configure 'show advanced options', '1'
reconfigure with override
exec sp_configure 'xp_cmdshell', '1'
reconfigure with override
set nocount on
create table #services(stext varchar(128))
insert into #services
exec xp_cmdshell "net start"
If (select * from #services where...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 11:37 am
ananda.murugesan (8/24/2011)
How to re-assign new IPAddress-2 in SQL server 2008.
change the IP address on the server network connections centre and restart the sql server instance. Dont touch anything else!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 11:20 am
is there a firewall between the 2 endpoints?
can the client machine resolve the server name or even ping it?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 11:13 am
you also need to remove the passive node from the possible owners list on the cluster resources in case Murphy's law tries to fail over to that node during the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 11:11 am
where did you get the SSL certificate for the site, is it self generated?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 11:07 am
Viewing 15 posts - 6,751 through 6,765 (of 9,244 total)