Viewing 15 posts - 1,561 through 1,575 (of 2,463 total)
select object_name(constid),object_name(id),* from sys.sysconstraints
July 6, 2010 at 10:28 pm
Lowell (6/30/2010)
why not use a VIEW that is nothing more than a UNION ALL of the three tables in question?
or you might need to use JOINs to get related...
July 6, 2010 at 4:22 am
Obviuosly a Sql code
http://technet.microsoft.com/en-us/library/ms173839.aspx
Google it to get more details
July 6, 2010 at 12:09 am
These link might help you
http://www.sqlserverclub.com/articles/how-to-set-up-database-mail-on-sql-server-2005.aspx
http://www.sqlserverclub.com/articles/how-to-set-up-database-mail-on-sql-server-2005-part-2.aspx
July 5, 2010 at 11:27 pm
You posted some confusing stuffs
chrisph (7/5/2010)
The particular table we are testing this on has no foreign keys
chrisph (7/5/2010)
July 5, 2010 at 11:21 pm
Not enough details provided by you, I am getting what you are looking for?
July 5, 2010 at 12:50 am
jobs should be run by either job creator or service account. i dont think we can set permissions as per your requirement at job level.
July 5, 2010 at 12:45 am
In my company, we just developed a structure to do some admin tasks like setting up mirroring, log shipping, Backup and restore DB etc. we maintain all data path ,...
July 5, 2010 at 12:42 am
i got the resolution
From DBCC tracestatus
i was getting 2330 flag on
so i eanbled it by DBCC traceoff(2330,-1)
July 2, 2010 at 3:15 am
post index defintion of trans_detail and Charges tables .
July 2, 2010 at 2:02 am
athinkerfootball (7/1/2010)
Did the reindex finish or stop when it encountered this error? I can't find detailed log files.
Give a manual run to the script which you are using...
July 1, 2010 at 10:25 pm
Suresh B. (6/30/2010)
Is database property AUTO_CLOSE = On?
NO. it is set FALSE
June 30, 2010 at 6:23 am
No
But in case it got restarted and we have some index seeks or scan then we must have some entries in this view. i am right ?
June 30, 2010 at 6:22 am
Suresh B. (6/30/2010)
Do you get any error when you run sys.dm_db_index_usage_stats?
NO
Is the database compatibility level = 90?
Yes
Do you have any index (which is used) on...
June 30, 2010 at 6:15 am
Viewing 15 posts - 1,561 through 1,575 (of 2,463 total)