70-450 MCITP is DBA certification.

Dumps are illegal and immoral....

Try this

select @val = count(*) from cte1

It should be RETURNS varbinary(MAX)

CREATE FUNCTION EncryptPwds (@pwd varchar(20))

RETURNS varbinary(MAX)

AS

BEGIN

DECLARE @DBAPassphrase varchar(128);

DECLARE @cryptPWD varbinary(max);

SET @DBAPassphrase = 'The DBAs wield the power!';

SET @cryptPWD = EncryptByPassphrase(@DBAPassphrase, CAST(@pwd AS VARBINARY(MAX)))

RETURN(@cryptPWD)

END

I think something else caused the log file growth, not log shipping.

Check the % space used in the log file. If it is very small, you can shrink it....

mohitdahiya2 (11/15/2010)

---

My question is - If where condition is false and value don't save in table so why I got a (1 row(s) affected) message. what is meaning of this...

If the blocking is caused by replication jobs, you can...

Is the table replicated?

Any foreign key reference?

Try to alter the table using SQL command.

I think someone has made the database online with following command

RESTORE <database> WITH RECOVERY

Check the SQL Server log for following message:

Restore is complete on database 'database'. The database is...

If you are trying to connect to a named instance, SQL Server Browser service should be running.

If you are trying to connect from a different machine, you need to...

To bring the database online use following syntax (this also works when .tuf file is missing):

RESTORE <database> WITH RECOVERY

SQL Server client software is not part of OS. It needs to be installed separately. Service Pack is applicable to client tools also.

Regards

Hi Dave,

Above utility belongs to SQL Server 2000 version.

SQL Server Configuration Manager utility is used for SQL Server 2008 version.

Without enabling any protocol communication is not possible.

Regards,

Suresh

It is a collation.

BOL (SQL Server Books online) has very detailed explanation about collations. Please refer BOL.

I did not understand your question correctly.

Please try this query and reply....

SELECT * FROM sys.tables WHERE name LIKE '%xyz%' AND create_date >= '20101102'

Try this:

Select cast(Msg as varchar(max)) from Table1 where id =3I am not sure whether this will handle RTF text.