Viewing 15 posts - 1,846 through 1,860 (of 2,462 total)
acebalajadia (4/20/2010)
I've added the Ip address PC Name on the host file of the SQL Server
Are you sure :w00t: ? Sql server doesnt have any HOST file , where...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 20, 2010 at 3:39 am
Have you updatedd statistics ?
Did you see the execution plan for that poor queries?
If possible post them .then only i can suggest something
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 20, 2010 at 3:23 am
What login credentials you are using to connect with linked server ?
and During linked server setup in securty tab which options you are using ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 20, 2010 at 2:06 am
First of all use windows authentication and then use the Sql code i posted in my last reply ( loginname) that can help you.
if still have any problem,post it.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 20, 2010 at 12:07 am
Whats the output for this in DDL trigger?
declare @data xml
set @data = EVENTDATA()
SELECT @data.value('(/EVENT_INSTANCE/LoginName)[1]', 'varchar(256)')
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 11:56 pm
i dont really remember the exact cause but i think it happened because of network connection failure.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 11:40 pm
dakshinamurthy-655138 (4/19/2010)
Here i am trying to log the changes done for Database Objects from which system and which login the changes have been made.
For this you can only use triggers...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 11:37 pm
Difference between suser_sname() and suser_name() ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 8:16 am
Prithvi(4/18/2010)
what I did was to copy the Database from Mgmt Studio on the same server with a new DB name (oldname_new)and took a back of the new copied database.
Did...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 8:13 am
dakshinamurthy-655138 (4/19/2010)
but for the issys320 the loginname which i use to login is dakshina i need to track the login dakshina.
whats your sql windows login ?
can you see...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 8:08 am
kevin77 (4/17/2010)
Is there any way to put in a TOP 1 clause for the track points?
Can you explain it ? i got confused with it
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 7:54 am
Location id i generated by cursor...
this should have been mentioned earlier.i was only working with "state" column
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 7:04 am
Refer these links
Auditing with SQL Profiler[/url]
Mastering SQL Server Profiler - Introduction[/url]
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 5:42 am
you saw 2 earlier years back.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 5:30 am
Check following things:
1. did see any new entries in msdb.sysmail_allitems ?
2. Check Database Mail log
3. What service pack you have ?
4. What result you got...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 19, 2010 at 4:55 am
Viewing 15 posts - 1,846 through 1,860 (of 2,462 total)