Local means that it is the default instance on your local machine.  The only way to change it would be to re-install SQL Server on that box as a named...

I prefer to backup to disk, then copy to tape or other media.  Having the latest backup on disk will greatly increase your recovery time as you will not have...

"How can one investigate beforehand whether deleting the BUILTIN login off the server for security reasons may cause necessary applications logins to be blocked, etc."

Well, first of all you need...

OK Jan.  The table DDL will help, but can you post a few lines of sample data from each table along with how you want the data to appear in...

Great analogy Joe.  That's an easy way to get set based thinking accross to people.

How about your table DDL?  Can you post some sample data and what your data should look like after a sucessful run of your procedure?

I see no way to do what you are asking.  Since you cannot execute dynamic SQL inside a function, you have no way to return a value based on the...

No function needed.  Even if you decide to put this into a function, you certainly do not need to use a cursor......

declare @name varchar(4000)

set @name = ''

select @Name = @Name...

Just curious, but can you give an example of how you plan to call/use the function?

Check the Windows Firewall on your new workstation.  Disable the firewall and try connecting again.

Look up 'format files' in BOL.  The section 'Using Format Files' will tell you how to set up a format file that tells BCP what the fixed length of each...

UPDATE tbl_leads_queue

SET lead_status_id  = 7

WHERE parent_lead_id = @LeadID

    AND partner_id = 19

    AND lead_status_id = 3

    AND convert(varchar,date_sent,101) = convert(varchar, getdate(),101)

Are you saying that you have nested cursors?  I would say that the best way to avoid this problem is to avoid using cursors.  If you post your code, you...

Sorry to keep bombarding you, but check this out.  You may be able to get back up without repairing/replacing your disk.

http://dis4ea.blogspot.com/2005/07/tempdb-and-missing-device.html

Rebuilding your master database may get you going again.  You may want to look into that option as well.