Viewing 15 posts - 1,561 through 1,575 (of 2,462 total)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 5, 2010 at 11:21 pm
You can also use database mail
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 5, 2010 at 11:18 pm
Not enough details provided by you, I am getting what you are looking for?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 ,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 2, 2010 at 3:15 am
post index defintion of trans_detail and Charges tables .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 1, 2010 at 10:25 pm
Suresh B. (6/30/2010)
Is database property AUTO_CLOSE = On?
NO. it is set FALSE
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 30, 2010 at 6:15 am
Suresh B. (6/30/2010)
Bhuvnesh (6/30/2010)
HiIn one of my sql instance i am not getting records for table/index updation in sys.dm_db_index_usage_stats DMV.
Please post the SQL query you are running.
SELECT OBJECT_NAME(OBJECT_ID),*...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 30, 2010 at 6:11 am
Viewing 15 posts - 1,561 through 1,575 (of 2,462 total)