Hi

Check out the below link

http://msdn2.microsoft.com/en-us/library/aa933154(SQL.80).aspx

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

You can have DECIMAL or INT datatypes but this is not the right way to do it. The best thing would be declare this column as CHAR(1) to store the...

Hi

1) It depends on the requirement. Most of the people uses ASP/Microsof technologies.

2) http://support.microsoft.com/kb/169377

3) I dont think there are any websites for these kind of templates.

Thanks -- Vj

Hi,

You can go for linked servers.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

In many instances you can accomplish the same task using either a stored procedure or a function. Both functions and stored procedures can be custom defined and part of any...

Hi,

Check out the below link

http://forums.devarticles.com/microsoft-sql-server-5/data-source-name-not-found-and-no-default-driver-specified-8346.html

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

You can even use DTS/SSIS.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

check out the below code this give you the exact error.

EXEC @hr = sp_OAMethod @object, 'Connect', NULL, 'my_server',

'my_login', 'my_password'

IF @hr <> 0

BEGIN

EXEC sp_OAGetErrorInfo...

Hi,

Check out this link

http://technet.microsoft.com/en-us/library/ms179491.aspx

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

Certainly you can restrict the no. of records using TOP, but this is performnace issue. It would be better to use to some WHERE condition to restrict the records.

Thanks --...

Hi,

It depends on what is your target database? I have used OWB and it is good.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

There are two steps.

1) Sending out an email from SQL Server. Use the below link

http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html

2) Schedule this activity at 3:00PM everyday. For this you need to SQL...

Hi,

The query is exactly same. Is this kind of one time behavior? or you are always getting like this?

It would be better if you give us the data also, so...

Hi,

in Nutshell use the below query to find out the duplicate records.

SELECT

list_of_all_columns

FROM

tablename

GROUP BY

list_of_all_columns

HAVING

count(*) > 1

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

I would say no coz hibernate adds more complexi ty the whole architecture.

Thanks -- Vj

http://dotnetvj.blogspot.com