Viewing 15 posts - 1,846 through 1,860 (of 2,463 total)
Gianluca Sartori (4/20/2010)
(2) Too many indexes
HOw indexes put sudden effect on indexes. i am confused with it
April 20, 2010 at 4:33 am
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...
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
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 ?
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.
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)')
April 19, 2010 at 11:56 pm
i dont really remember the exact cause but i think it happened because of network connection failure.
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...
April 19, 2010 at 11:37 pm
Difference between suser_sname() and suser_name() ?
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...
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...
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
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
April 19, 2010 at 7:04 am
April 19, 2010 at 5:42 am
Viewing 15 posts - 1,846 through 1,860 (of 2,463 total)