What is the difference between grant and with grant while giving permissions to the user?

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

Are semicolons required at the end of sql statements in sql server 2005?

0 Answers  

---

What is a fill factor?

0 Answers  

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

0 Answers  

---

How can you control the amount of free space in your index pages?

0 Answers  

---

how many triggers you can have on a table? : Sql server database administration

0 Answers  

---

What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers  

---

How to create a stored procedure with a statement block in ms sql server?

0 Answers  

---

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers  

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

0 Answers   Accenture,

---