you can try using the nvarchar(max) it stores large data or else if you use text

NO man

A schema is nothing more than a named, logical container in which you can create database objects. A new schema is created using the CREATE SCHEMA DDL statement.

Properties

...

Thanks For Question

I learned Having Exists ...!

SELECT db_name(dbid) as DatabaseName, count(dbid) as NoOfConnections,

loginame as LoginName FROM sys.sysprocesses

WHERE dbid > 0 GROUP BY dbid, loginame

To Remove Log Shipping

1.On the primary server, execute sp_delete_log_shipping_primary_secondary to delete the information about the secondary database from the primary server.

2. On the secondary server, execute sp_delete_log_shipping_secondary_database...

Great!

Your master database contains metadata about the entire server like the list of databases, list of logins etc.

This database gets regularly updates based on the server activities.

Your msdb database contains...

Use the sysmail_add_account procedure as follows to create a Database Mail account, using mail.dynanet.com as the mail server and dinesh@dynanet.com as the e-mail account:

EXECUTE msdb.dbo.sysmail_add_account_sp

...

hey can you use dts method in sql 2000

or if u want please post in the sql server 2005 filed in the Forums

Type services.msc in Run Command

then Services Opens

Then Select The SQL SERVER AGENET ( SERVERNAME )

then click it then Click Start..

we need to spilt the Varchar and Numeric data

sachin123 it can be splitted into sachin one row 123 in other row..

It is good...but Search Condition withing past 2 days or 1 week, 2 week, 1 month,three months...

i need dates condition to serach for past 1 day or past 1 week...

SELECT something

FROM somewhere

WHERE whenever

BETWEEN Now AND Then

Disclaimer: I am not at my SQL machine, so the syntax may not be perfect and I haven't been able to fully test it...

RESTORE DATABASE UK

FROM DISK = '\\SQLSERVER\Backup\Newfull.bak'

WITH REPLACE,

MOVE 'LIST_New' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\UK.mdf',

MOVE 'LIST_Log' TO

'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\UK_log.mdf'

WHEN I AM EXECUTING THIS COMMAND I AM GETTING ERROR

Msg 3234,...