Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?1251
Which institute is best for SQL Server 2005 Training?6 2968
How do we rollback the table data in SQL Server3 13690
where do you use Isolations?give me some exmpale?1 3160
In which year relase the 7.0& 2000 & 2005?1 1883
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply1 4145
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..4 4105
select empid empname from employee What is the result for the about query?4 3369
What is Lock table in SQL?
what is checksum in sql server.........???
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
where the connection string store in the database
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
how can you attach more than 20 ldf files in sql server
SQL Server Architecture ?
If we delete pack Spec what will be the status of pack Body ?
Why we need to use secondry database file? though, we can do same work using primary database file also.
how to take backup bcp out for a column in table in sql server?
what is package and it uses and how can u call a package
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Scalability, Availability, Integration with internet, etc.)?
what are the Prerequisites for Replication?