Yes. When you create a login in SQL, it should validate through a script whether it is valid windows login.

Any one have faced the same issue ?

Hi

Thanks for responding. The login is not disabled and password is correct one. It works on local machine. Issue is while connecting from SQL 2008 client and Client tools...

It has been told that issue had been fixed in 5.0.0.1068 but we are using 5.0.0.3, Still the issue Persists.? But while we do manually ,it is running fine.

--------------------------------------------------

LiteSpeed...

Hi

I would like to get the SSIS Meta data like what are the Tasks it contains, Connection managers, variables inside for a SSIS Package. Will your Vb.net code can help...

Ofcourse,,

This syste view would return information about all the data pages that are currently in the SQL Server buffer pool

Just try this

select distinct d.name

from sys.dm_os_buffer_descriptors b with(nolock)

join sys.databases d with(nolock)

on b.database_id = d.database_id

Hi

U can follow the below link.

http://deepakrangarajan.blogspot.com/2008/11/moving-system-databases-in-sql-server.html

Hi

Resource Database is a hidden and Read-only DB available in SQL Server 2005 onwards

All the System objects are stored in this database only

No Changes can be made on this...

Hi,

as said if you have full backup and transaction log backup.. then.. find the below syntax

restore database mydb from disk = ‘c:\mydb_full.bak’ with norecovery

restore log mydb from disk =...

Run the jobs related to transaction Replication again ( synchrnozie via replication monitor) in sql agent jobs but do not reinitialize.

ssuresh rajan.

Logshipping is DB Based . Logins are SQL Server related. Logshipping would do transfer all transactions using transaction logs but to access the data in Secondary, Logins have to...

Hi this is SPN related issue and has to be registered properly. Please refer the following link

http://support.microsoft.com/?id=811889

[font="Tahoma"]Thanks everyone.

I would like to know what data is available in TLog .

Scenario, I have set the Recovery model in bulk-logged . I have taken the transaction log backup and...

I hope, if there was any bulk-logged activities happened , point in time restore will be failing.

"

If a log backup taken under the bulk-logged recovery model contains bulk-logged changes, point-in-time...