Hi Jeff,

I think pande wants the output in the following way

CREATE TABLE Qualification

(

QId int identity(1,1),

QName varchar(100)

)

go

CREATE TABLE Candidate

(

CId int identity(1,1),

CName...

Hi Venu,

It seems to be a network connectivity problem. Ask your sysadmin to check out for any connectivity issues in the...

Sourav (8/2/2009)

---

Hello SQL Experts

Could you please explain the below scenarios..if this is possible...?

For the first time when we install SQL Server we will have the default instance, i.e. the computer...

Hi Binko,

Thanks for the correction. I had missed the servername in dropserver.

Hi,

Backups:

In order to take backup user must be sysadmin or db_owner or db_backupoperator. I prefer giving db_backupoperator permissions.

Restoration:

If the database being restored does not...

Hi

Instead of dbcc inputbuffer(@spid) use below query or refer to http://www.sqlservercentral.com/redirect/articles/67645/

for more information.

SELECT DEST.TEXT

FROM sys.[dm_exec_connections] SDEC

CROSS APPLY sys.[dm_exec_sql_text](SDEC.[most_recent_sql_handle]) AS DEST

WHERE SDEC.[most_recent_session_id]...

Hi,

Whenever a system in renamed at the o/s it has to be renamed at the sql server level also. Try following steps. Login into the sql server system...

Check out @@NESTLEVEL in BOL

Hi,

markwnorsoft solution should work fine. Previously when I had configured replication for the first time over internet I too faced the same problem and adding entry to host...

Hi,

What is the recovery model of your database. Are you taking log backups regularly if it is in full recovery model

Congrats:-)

Did you disable replication or removed replication...

Hi,

Try any one of this. First one should work.

1. select * from table with (index(myidxname)) where thecolumn is not null

or

2.

declare @thecolvalue integer

set @thecolvalue=null

select * from...

Hi,

Please post complete erorr messages. As this will help to find out any other issues also.

Hi,

Please post complete erorr messages. As this will help to find out any other issues also.