Reinstall the SP2 the get solved. Thank you for your co-operations.
Yes. It's SP2 only.
Hi, I’m using Standard Edition with clustered environment. Newly I had created a Daily Maintenance Plan for Full DB Backup.While I’m saving the...
Some buddy told me, if u use while loop in sp.. the sp's performance getting low..-<img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br...
Hi every buddy!! can anybody tell me, the stored procedure performance is getting down when we using WHILE loop in the same.. is it true? thanks...
Thank u.. but my quetion is.. Is it possible to import the data from excel without installing MS Office package? Regards, Shiva (+91-98948-45445)...
Hi dear buddies!! I want to import some excel data into sql sevrer 2k5 through Data Transfermation wizard ... The Server doesn't...
quote:Originally posted by MohammedU 1. Run the SQL trace while inserting the data...If you have trigger on the table to roll backup the transaction...
Thank you Respectable responders... I may got it.. The following script may help me to create a alert And also execute a job.. Though this job...
Hi, I told for an example only... Here my query is to, How'll I configure like that? Is it feasible? Did u get me? Please reply me!! Regards,...
i want to execute stored procedure name called "Sp_checkDriveSpace" at the moment of user login.. is it possible? Regards, Shiva (+91-98948-45445)...
Dear Performers, I wish to execute some stored procedures when the time of user login. Is it practicable[?] Regards, Shiva (+91-98948-45445)...
quote:Originally posted by satya ...try to reindex that specified index too in this case. Satya SKJ Microsoft SQL Server MVP Contributing Editor &...
So your suggestion is to, Create 3 login names for a single user.. Am i right? But i asked for a single login.. Regards, Shiva (+91-98948-45445)...
quote:Originally posted by MohammedU No.. You can't create triggers on system tables. You have to handle this through sql security... Create one...
You aren't able to insert a value through Using Create Table Statement.. Better U Use following query select eno, ename into temptable from emp...
quote:Originally posted by ghemant Hi, Earlier we have created trigger that is fired on updation/deletion/insertion and check for the hostname and...
Yeah Nice.. I Already enabled that "C2 auditing mode".. If a User has access more than 3 Application in same database.. Those application name...
I able to Hear All Languages [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />But Speaking...<br /><br />Tamil & English...
Thanks for Your Kind Reply.. I'm asked Application Based Security.. Not Database... But If I'll Use more than one Application to a Same Database.....
Separate names with a comma.
