I have cleared MS 70-431. Pls guide which one should I take up next to pursue my careeer as a developer.

I need to insert into a table , and define the type of each reocrd depending on some conditions ( These conditions are specified in join / where clause), so...

May I know , if you are using a shared folder or you have a network drive mapped on your server ?

If its a network drive mapped, then pls use...

Hi !

Thank you every one for all you replies and suggetsions,

The problem had been resolved , I could not post it here on the forum.

I used the command net use...

I am trying to restore a database on SQL Server 2005, using the backup placed on a different server ( in same domain). I have shared the folder and tried...

Hi Gail ,

Thanks for guidance !

Can u pls tell about how and when to run the sp_trace * , and which are those infrequent events , which we should trace...

The code has been changed, we got to know.. later. Is there any way out , now...??

Profiler tracing would have helped in case it had been enabled to sav...

Thanks for the prompt response.

I wanted to ask if the view would hold data for respective group , depending on the login. i.e. if the concurrent sesisons are active ,...

Hi

Thanks for the URLs. The information is really impressive but being a beginner, one would need some introductory material or a step by step course. These sites would be...

I am soory , I forgot to mention that I am working on SQL Server 2000.

so .. no option for 'Peer to Peer Replication'

Please advise.

I support all production servers of a particular client. There are about 40 servers. All of them are being used in different timings , i.e. round the clock.

The other thing...

Thanks for all your inputs !

This copying of back up and then restore on the other server is being carried out manually as a daily activity. Export / Copy database...

Or Else We can use back up task followed by FTP tasks to send/Recieve compressed back up files .

What is the cmdshell syntax to compress backup files ?

Yes , It does.

Thanks a lot , everyone !

I need one more suggestion. The earlier DBA has 'sa' password as it needed for application. Also , he is not ready to share the...