I had my interview in similar kind of company with same question. His question was, we have Really big size databases and sizes are becoming bigger day by day. So...

As long as you have SQL client tools installed and enabled protocols(TCP/IP, Named Pipes) on other computers to connect to your SQL server. you can

Have u tried reading dirty transactions in ServerB (i.e. uncommited) by setting query hint (nolock) or for a connection setting transaction isolation level READ UNCOMMITED

By Acessing you mean r they just Selecting(DDL Statements) or modifying it too(DML statements)?

Could you post the error too?Thanks

For SQL Programming/Analytical questions Some of the standard ones are:

1) How to Find top 3 maximum values in a column (ANS using TOP clause with ASC)

2) Reverse the characters of...

use sp_attach_db

Nope, as far as I know.

I think it puts a shared lock on the table. As an example. Select query in my source table takes about 13 secs but when I used import/export wizard to...

u can use DBCC SHRINKFILE to truncate log, if just log truncation is the mission

Below is my attempt - wrong!!

alter PROCEDURE sp_GetCounter(@ccnt int) as

declare @counter int

set @counter = @counter+@ccnt

return @ccnt

-------------------------------------------

Just a thought, why r u returning @ccnt when ur incrementing @counter in ur...

Yes,

I had a friend with the same problem. She had not installed SSME management studio but had installed the server in express edition.

All these responses r so helpful and indeed good topic.

I agree with Mark. I dont think there will be much change in SSIS too.

so how high can the pay go for Sr. most SQL DBA