Viewing 15 posts - 1,981 through 1,995 (of 7,502 total)
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
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
Viewing 15 posts - 1,981 through 1,995 (of 7,502 total)