Viewing 15 posts - 526 through 540 (of 1,069 total)
Looks like the SQL Server service is running under your account.
Check the Windows Event Log for more information.
Run SQL Server Configuration Manager and enter the new password.
June 10, 2011 at 1:39 am
asritha_v (6/9/2011)
1. Source and Destination Tables are different Name2. Source and Destination Filed names are different
I don't think Replication works if table and field names are different.
May be use have...
June 9, 2011 at 10:18 pm
After uninstalling SQL Server successfully, MSSQLSERVER folder remains in the Program Files folder.
This is normal. You can delete it.
June 9, 2011 at 10:05 pm
sp_addrolemember [ @rolename = ] 'role',
[ @membername = ] 'security_account'
June 9, 2011 at 1:13 am
Change is Required (6/8/2011)
Can we access Secondary Server in Logshiipingif yes explain
Yes, in Standby mode
... Can we mirror server in mirroring .?
Mirroring works in database level. Not in server...
June 8, 2011 at 2:58 am
Denesh Naidoo (6/8/2011)
The only solution would be to drop the index...
June 8, 2011 at 2:50 am
USE <DatabaseName>
GO
GRANT SELECT ON <TableName> TO <UserName>
GO
June 7, 2011 at 5:14 am
Bhuvnesh (6/6/2011)
I use the dbcc checkdb and there is no errors.
DBCC CHECKDB is not enough. It checks only the database. Not the backup.
Run RESTORE VERIFYONLY.
June 7, 2011 at 2:07 am
Because Model database is used as template to create other user databases (including business critical OLTP).
Model database, by itself does not need point-in-time recovery. But, the user databases created based...
June 7, 2011 at 1:59 am
In my huble openion:
Because you don't need point in time recovery of msdb database.
It does not contain OLTP data.
June 7, 2011 at 1:15 am
BOL:
You can use the Transact-SQL ALTER TABLE...SWITCH statement to quickly and efficiently transfer subsets of your data in the following ways:
Assigning a table as a partition to an already existing...
June 6, 2011 at 10:23 pm
cino (6/5/2011)
Is this a common good practice? Or is there other specific good reasons we are using these...
June 6, 2011 at 5:31 am
shiv-356842 (6/4/2011)
i have created Transaction Replication. publisher to subscribers data is not transfering i am trying to pinging to though UNC
How can i ping .. ?...
June 5, 2011 at 11:16 pm
JWIDM76 (6/3/2011)
June 3, 2011 at 5:53 am
Viewing 15 posts - 526 through 540 (of 1,069 total)