Viewing 15 posts - 1,981 through 1,995 (of 7,498 total)
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
jcrawf02 (6/9/2011)
Kiara (6/9/2011)
Grant Fritchey (6/9/2011)
Kiara (6/9/2011)
Tom.Thomson (6/9/2011)
Kit G (6/8/2011)
June 9, 2011 at 7:05 am
No, it doesn't
It shows the actual startup time of the instance and just adds the database names at row level.
If you really seek for db startup, you may be able...
June 9, 2011 at 6:29 am
GilaMonster (6/9/2011)
Is this person irritating anyone else, or am I just in low-tolerance mode at the moment?
Are you in desperate need for coffee 😉
You provided the perfect answer for him...
June 9, 2011 at 4:04 am
It was my pleasure to get a first glimps of your article.
This is a lesser known topic, but definately has its place in SQL instance management topics.
Great job !
June 9, 2011 at 1:41 am
Please post the full ddl of your object tcsINVTB00026_AttribAsgn
(i.e. script its create statement including all indexes and constraints )
June 9, 2011 at 1:35 am
Viewing 15 posts - 1,981 through 1,995 (of 7,498 total)