Viewing 15 posts - 1,951 through 1,965 (of 2,462 total)
First of all, without posting other information like table definition/query, you made your post a bit complicated
so better to put this info to get result/response faster (Refer the link...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 2, 2010 at 4:36 am
am-244616 (4/1/2010)
declare @table_id bigintselect @table_id=table_id from INSERTED
This query only give one value for table_id irrespective of no of rows afftected in main table by inset/update
see this code to get this...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 2, 2010 at 4:16 am
Can you post the result of query you posted above SELECT
db_name(database_id),object_id, index_id, record_count, avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'detailed')
WHERE index_id > 0 and index_level = 0 and avg_fragmentation_in_percent...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 2, 2010 at 3:40 am
First of all NEVER directly patch PROD server. Always do testing on lower regions like testing or staging.
Document the steps to follow, issues encountered and their resolution.
See the attached...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 2, 2010 at 1:01 am
Refer this :
Restore Process
To restore the database you can either do this from a query window or from the SQL Server management tools.
These are the commands to restore the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 2, 2010 at 12:23 am
Paul White NZ (4/1/2010)
If the result surprises you, please look here: http://msmvps.com/blogs/robfarley/archive/2010/01/12/t-sql-tuesday-having-puzzle-answer.aspx[/color][/font]
Paul, Great article:-)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 1, 2010 at 8:13 am
Refer this link http://www.microsoft.com/systemcenter/en/us/operations-manager/om-overview.aspx and attached doc
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 1, 2010 at 6:12 am
mjarsaniya (3/31/2010)
-- now i have update query:update Soft
set name ='MAYANK'
WHERE FileID=1 AND PageID='0200557_00000_00001'
Is it from any Stored proc ? if NO then i think u can incorporate this...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 1, 2010 at 5:47 am
post tables defintions
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 31, 2010 at 8:14 am
From my previous post fetch data into permanant table DBRolePermissions from @DBRolePermissions
and then use SELECT Principal_Name,
CASE WHEN [CONNECT] IS NULL THEN 0 ELSE 1 END [CONNECT],
CASE...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 31, 2010 at 7:54 am
Sasidhar Pulivarthi (3/31/2010)
MDEL sa yes yes...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 31, 2010 at 6:10 am
Sasidhar Pulivarthi (3/31/2010)
tbl1 tst1 Y ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 31, 2010 at 5:36 am
m.John (3/31/2010)
Please could you explain how it works.The data for the 'Uninstallable' is always 0 in the REGISTRY.
i think roust_m made it Uninstallable = 1. then did the uninstallation.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 31, 2010 at 5:10 am
Sasidhar Pulivarthi (3/31/2010)
I need to get the Accssible databases for particular user & his permissions for those DBs.
Seems like unmatured post . give more details
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 31, 2010 at 5:04 am
sudhakara (3/31/2010)
One more thing the sql agent error message is coming still.
what kind of error ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 31, 2010 at 4:53 am
Viewing 15 posts - 1,951 through 1,965 (of 2,462 total)