Viewing 15 posts - 1,576 through 1,590 (of 2,462 total)
Bhuvnesh (6/30/2010)
ALZDBA (6/30/2010)
Microsoft SQL Server 2005 - 9.00.4053.00 (X64) May 26 2009 14:13:01 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition (64-bit) on Windows NT...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 30, 2010 at 5:43 am
ALZDBA (6/30/2010)
Microsoft SQL Server 2005 - 9.00.4053.00 (X64) May 26 2009 14:13:01 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition (64-bit) on Windows NT 5.2...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 30, 2010 at 5:42 am
i am sql administrator, is that enough for it ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 30, 2010 at 4:29 am
Google Sp_send_dbmail
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 30, 2010 at 4:22 am
why ? what issue you got ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 29, 2010 at 12:21 am
i dont know your exact requirement but you can give them conditional flow of businees flow, if you know that . i guess high level view will work for them.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 29, 2010 at 12:18 am
you mean to say execution plan .. i dont think there is any word like "flow chart " for queries
you can use "include actual exec plan" available in...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 28, 2010 at 6:43 am
sqlcool (6/27/2010)
Any ideas how to automate this? Do i need to write some T-SQL code or is there any setting in SQL-Server 2005 or 2008?
USe sp_send_dbmail including Query parameter.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 27, 2010 at 11:39 pm
Try this
IF EXISTS (SELECT name
FROM sysobjects
WHERE name = N'up_AllProcPermissionsForDB'
AND type = 'P')
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 27, 2010 at 11:37 pm
try this ...some what like your requirement
SELECT '''' + cast(value as varchar(2000)) + '''' FROM ::fn_trace_getinfo(0) where property = 2
SELECT ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 27, 2010 at 11:35 pm
Eric.Johns (6/24/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 25, 2010 at 6:30 am
i have some confusion here , if the column is identity--auto incremented then how duplicates records generated ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 25, 2010 at 6:27 am
Alex Laime (6/22/2010)
I tried creating and running this various ways, using the wizards or manually
Have you tried through scripting ? addtionally is there any mgmt window opened ( using...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 23, 2010 at 5:38 am
Tara-1044200 (6/22/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 23, 2010 at 5:16 am
See of this link can help you.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104090
http://www.eggheadcafe.com/forumarchives/SQLServerserver/Jul2005/post23536458.asp
this error generally comes when there is corruption in data.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 23, 2010 at 5:12 am
Viewing 15 posts - 1,576 through 1,590 (of 2,462 total)