Agree, majority of DBA's are one man show, a fellow DBA or network guys can take backup restore trouble shoot at SQL server level but the database design and any...

Delete should be based on business logics, as phone book example if you create unique index on phone number column then SQL Server will not allow duplicate phone number. This...

I agree, the demand for database administrators will increase good news for all of us :). The systems i developed 5 to 6 years ago for different companies are contacting...

There is no need to create temporary tables, very helpful when deleting from large tables, you can delete the duplicate records using inner join and setting the rowcout to 1,...

Very fair article, I have seen similar situations many times. Recently a database developer, hired to design dataware house even after technical interview.

80% its staffing agency fault, they sends the...

Try there free trial to see if it shows u those files data and log file exist.

http://www.winrecovery.com

or do a search on Google using recover deleted files, there are softwares which...

There is no developer edition, its a license with term of developer edition. Its just enterprise edition marked lower price.

Tomorrow we will have Education versions and non profit organization versions...

There is a way to get around this space issue.

Open your MSDB database and edit the table sysoperators, increase the size of field (email_address) to 500 from 100 or what ever and...

Renaming SQL Server does not effect any databases or data inside them. All your databases should be there after successful rename of computer.

Create one operator with multiple email addresses seprated by semi colon ";" and select that operator to notify incase of job fails.

You can rename the windows computer directly from My Computer Properties or system from control panel. You will be able to connect after restarting your machine.

To update sysservers system table...

Ayesha,

Try this website connection string.

http://www.connectionstrings.com/

For VB.NET with ASP.NET here is what you need, assuming that you are running IIS on the same machine as SQL Server with mix mode...

Its a lengthy solution of the times, which exact Chinese character you want to insert and work with.

Traditional Chinese character or Simplified Chinese characters ?

Is your operating system installed with...

Use SQL Server 2000 in 21 days from SAMS and practice it on MSDE that will clear all basic things about SQL Server.

Give a try to books online too.

The best...

Use this stored procedure it is using MS OLE DB Provider, assuming you are NOT using host integration server you can alter it as per your requirment

EXEC sp_addlinkedserver

   @server='YOURDB2',

   @srvproduct='Microsoft OLE DB...