Viewing 15 posts - 1,981 through 1,995 (of 7,504 total)
When using a witness, and configuring auto failover, your principal needs a quorum with the mirror OR with the witness. If none of both quorums can be established the principal...
June 13, 2011 at 4:49 am
I just reread your original question and need to revise my answer a bit.
You cannot mirror sqlserver master database !
June 13, 2011 at 4:38 am
Good and valid replies so far.
Actually it is YOU who needs to elaborate on data loss for your business clients !
You would need to suppose they have no knowledge what...
June 13, 2011 at 4:18 am
at least your breakfast goes well with your popeye / goofy / ISV-promotion T-shirt :hehe::w00t::-D
-edited-
currently 45 years old kid
June 13, 2011 at 4:12 am
If you need the details, you'll have to use profiler to capture it all.
Maybe have a look at my little article on how we performed it for our usage gathering:
June 13, 2011 at 4:05 am
A regular sql backup doesn't break mirroring !
backup database [xyz] to ...
See books online :http://msdn.microsoft.com/en-us/library/ms191304.aspx
backup using SSMS : http://msdn.microsoft.com/en-us/library/ms187510.aspx
June 13, 2011 at 2:17 am
So you mirrored db from a clustered sqlserver instance ?
Did you check the mirroring events ?
(see attachments)
June 13, 2011 at 2:13 am
In your query you are only checking on itemnumber.
The index is on three columns, including sequencenumber, the other two are the same columns a with the PK except itemnumber.
You should...
June 11, 2011 at 9:46 am
can you check your default trace content for occurences of rows for this account ?
June 10, 2011 at 2:17 pm
SKYBVI (6/9/2011)
ALZDBA (6/9/2011)
Please post the full ddl of your object tcsINVTB00026_AttribAsgn(i.e. script its create statement including all indexes and constraints )
USE [RTW]
GO
/****** Object: Table [dbo].[tcsINVTB00026_AttribAsgn] Script...
June 10, 2011 at 2:01 pm
No.
Just perform the grant as you used to
grant execute on dbo.sproc to youruser ;
June 10, 2011 at 6:42 am
Puja Shah (6/10/2011)
ALZDBA, Thanks for help.Following command worked:
GRANT EXECUTE ON SCHEMA::[dbo] TO user_name
-Puja
DO NOT grant to schema DBO !
This may be opening doors that shouldn't be.
The dbo schema contains more...
June 10, 2011 at 6:06 am
By default, every execute permission needs to be granted explicitely ( unless the calling user is member of dbowner group or sproc owner ).
Since MS implemented Schema ( sql2005 )...
June 10, 2011 at 4:02 am
- What's the exact error message ?
- Can you post your (new) sproc ddl ?
- can you post the ddl of a working sproc (by the same calling application)
June 10, 2011 at 1:43 am
Congrats Gail.
Thanks at least that number of times for saving our ***. :kiss:
June 9, 2011 at 10:31 am
Viewing 15 posts - 1,981 through 1,995 (of 7,504 total)