If you can ping the server by name, then DNS is resolving the name, but SQL Server might be configured to allow connections only on a specific port. If...

Some time ago, we had problems with memory pressure that seemed to come from CLR assemblies. After quite a bit of reading, we installed SP3 and the problem magically...

The application is configured somehow to connect to the database. This could be a dialog or somewhere else, but it will eventually boil down to a connection string. ...

I'm not familiar with the Web Edition at all, but when I have to migrate a database from one server to another I prefer to backup the database, copy the...

I completely agree with the 14 step approach Lowell suggested. I've used this approach myself to address a similar situation and it has worked very well. Each step...

And restore. http://msdn.microsoft.com/en-us/library/ms176014%28v=SQL.90%29.aspx

Another difference is that SQL logins tied to Windows accounts also require the Windows account to be active in order to login - another layer of security. I prefer...

Excellent. I'm glad you got it. So the wrong code page was being used in the conversion. With the new NLS setting, it works. Good job.

The RAISERROR simply throws the error. To terminate processing in a stored procedure, you should fire a RETURN.

I use RAISERROR myself and it works pretty well. I usually use this approach.

IF NOT EXISTS (SELECT (a.VoucherNo) FROM GV_Voucher a WHERE a.TransactionID = @TransactionID AND a.VoucherNo = @LastVoucherNo)

BEGIN...

Okay, please forgive me for this, but I don't have access to an Oracle database. That was quite a few years ago and I'm trying to dust off memory...

A word of warning, venkidesaik: One you move over to the tally table, you won't ever want to come back. 😀 It is an absolutely beautiful thing.

The Oracle Varchar2 data type supports Unicode and the SQL Server Varchar data type does not. That completely explains the '???' in the fields. You can change your...

If you are the DBA, you should ensure that you are running regular backups. Don't rely on the .mdf and .ldf files being copied somewhere else. Take a...

It looks to me like you're trying to insert a GUID data type into a Varchar or Varchar2 data type without doing a data type conversion. Start by checking...