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
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...
June 15, 2010 at 7:58 am
yes you should backup the reportserver database as it holds the reportserver configuration\definitions
June 15, 2010 at 5:43 am
track the machine down using its ip address and find out what is trying to authenticate
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...
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
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...
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:...
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...
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...
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...
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)
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...
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...
June 7, 2010 at 3:36 pm
Viewing 15 posts - 7,891 through 7,905 (of 9,244 total)