what are three different authentications to connect linked
Answer / vidhya sagar
|Is This Answer Correct ?||5 Yes||0 No|
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
How to transfer Logins from SQL Server 2000 to 2005
In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2
How do you Implement SSIS Packages in your Project?
what is differencial backup?how to work?Anybody explai it?
what is DTS what are tasks available
What are the types of backup and tell me the difference between full and differential backup?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
what is trigger
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year
where do you use Isolations?give me some exmpale?