Viewing 15 posts - 7,891 through 7,905 (of 9,244 total)
something like this may work if you need it
declare @command1 nvarchar(2000)
set @command1 = 'backup database ? to disk=''o:\?\?_' +
convert(varchar(20), getdate(), 112) + '.bak'''
exec sp_MSforeachdb @command1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 16, 2010 at 9:25 am
balaji.ganga (6/15/2010)
Hi..You have to check it C:\program files\microsoft sql server\90\eula
Eula --> English Users License Agreement.
Thanks & Regards
Balaji.G
they are licence terms NOT the number...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2010 at 7:58 am
yes you should backup the reportserver database as it holds the reportserver configuration\definitions
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2010 at 5:43 am
it's not cluster aware
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2010 at 4:11 am
track the machine down using its ip address and find out what is trying to authenticate
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2010 at 4:06 am
Joy Smith San (6/15/2010)
Dear All,Where can I find the licence details of SQL server installed.?
ie, Total number of concurrent users allowed..etc.
Thanks in advance.
Hi
on this product licensing is disabled. The following...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2010 at 4:03 am
either use the stored procedure above in a sql 2008 query window or migrate the users not both
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2010 at 11:26 am
Asha
if you haven't migrated the logins then the database will have orphaned users as you have found. use the following to report orphaned users in the database
USE yourdb
exec sp_change_users_login 'report'
this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2010 at 5:33 am
srikumar.karthiknarayanan (1/20/2010)
I have a 2 Node MSSQL 2008(64),
Today when i tried to install SP 1 on the Passive node the SP1 Failed and the Error (detail.txt) shows
Warning:...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2010 at 3:31 pm
Jason, to avoid confusing people (as you have here) please post in the correct forum in future. Saleems advice to you below is correct and valid for SQL Server 2008...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2010 at 3:20 pm
EdVassie (6/9/2010)
expect this learning to take many days to complete.
As Ed has said at the very least!
This is not something you learn and become an expert on in a few...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2010 at 3:38 am
durai nagarajan (6/8/2010)
Is there some other way other than using vm ware Kindly specify with necessary step documents.Thanks in advance.
you could also use Microsoft Virtual Server 2005 R2, but to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2010 at 3:33 am
Oracle_91 (6/8/2010)
I have more number of CPU's on my server. How to enable the multi-processor ?
multiple sockets or cores or both??
Oracle_91 (6/8/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 8, 2010 at 9:12 am
Hi
the documents are fairly large but here they are
Installing Clustered SQL Server 2008 using VMWare Server2
Installing Clustered SQL Server 2005 using VMWare Server2
They allow you to create a ringfenced SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 8, 2010 at 9:03 am
Oracle_91 (6/7/2010)
Am very new to SQL Server Clusttering ?? I have less knowledge in this area nor i got any chance to work on it which involves
resources...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2010 at 3:36 pm
Viewing 15 posts - 7,891 through 7,905 (of 9,244 total)