Viewing 15 posts - 1,141 through 1,155 (of 2,462 total)
e1785 (12/13/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 13, 2010 at 10:50 pm
dankwart menor (12/13/2010)
Sounds good. Pardon my ignorance - How do I do that?
http://blog.sqlauthority.com/2009/08/03/sql-server-introduction-to-sql-server-2008-profiler-2/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 13, 2010 at 10:34 pm
daveriya (12/13/2010)
Can anybody provide me the actual real time project example.
for example,in company how many databases r there,how many reports r generated per day,
and how the front end application r...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 13, 2010 at 10:16 pm
you can use sql profiler trace use "sp:stmtcompleted" event class
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 13, 2010 at 10:11 pm
brindaam (12/13/2010)
I have two queries, say for example
Select distinct 0 parent_id, ROW_NUMBER() OVER(
ORDER BY Column2_Desc ) AS 'ID', Column2_Desc
From table1
Union
Select distinct 0 parent_id, ROW_NUMBER() OVER(
ORDER BY Column2_Desc ) AS 'ID',...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 13, 2010 at 6:43 am
How did you resolve ? Always post resolution so that other can get the benefits.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 13, 2010 at 12:49 am
use sp_lock then find the spid associated with concerned DB and kill them ( but first you can check them whats running behind them by DBCC inputbuffer(spid))
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 13, 2010 at 12:22 am
Heavy DML operation/migration ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 13, 2010 at 12:09 am
Helpful links
http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic23785.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 13, 2010 at 12:08 am
Richard Ray-222778 (12/8/2010)
If the job executes sp code that performs data operations on tables in a specific database it appears that the job's permissions handle that. Is that correct?
You need...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 9, 2010 at 12:12 am
steve.treloar (12/7/2010)
Now I'm getting two messages/emails for every data change that meets the criteria. Dunno why. I can live with that for now though.
Post your complete trigger script
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 8, 2010 at 6:40 am
declare @t table ( ID int , TERM varchar(20), CLASS nvarchar(20))
insert into @t
select 304 ,20103, 'EE2'
union select 156 ,20104, 'CS3'
union select 167,20144,'MC1'
union select 167 ,20144,'SE3'
select distinct final.id,final.TERM,substring(final.results,2,len(final.results))
from...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 8, 2010 at 6:35 am
edwina derrick (12/2/2010)
I want to take a backup of msdb on server A and restore it to server B. Has anyone done this in SQL Server 2008
You can simply restore...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 8, 2010 at 6:22 am
create a user with databaseRole :SQLAgentOperatorRole
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 8, 2010 at 5:49 am
When you use the detach/attach method, you'll have to detach you source
database which means that at that point you haven't even got your source
in a safe condition any longer.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 8, 2010 at 5:09 am
Viewing 15 posts - 1,141 through 1,155 (of 2,462 total)