hi,

Look into the following link for the function mentioned above

http://www.sqlservercentral.com/Forums/Topic900359-338-1.aspx#bm900398

hi,

The @rid is taking the multi values by comma seperated....

ex: 12,45,24,3,78 ..

So the datatype int only takes single value of int only...it doesnot allow the above value...

For that change the...

hi,

Use DBCC SHRINK command....

http://support.microsoft.com/kb/873235

regards,

Sasidhar Chowdary

Recognition is the greatest motivator.

For the above scenario...U should use the loop [Cursor /Temp table/tbl variable] take the each row individually insert into new table if the SUM is below the Variable amount u...

Select Cust,MAX(OrderDate) Maxdate,MAX(SeqNo) MaxSQno

from tblname group by Cust

hi,

Why dont you write scrpts or Packages for importing data into Ur local machine....

or

Go for replication.....

U r looking into LInked servers only....

sp_addlinkedserver

http://msdn.microsoft.com/en-us/library/ms188279.aspx

http://msdn.microsoft.com/en-us/library/ms190479.aspx

http://www.quackit.com/sql_server/sql_server_2008/tutorial/linked_servers.cfm

cheers!

Sasidhar Chowdary

I have to do it from SSMS only.....

Creating new job in SQL jobs....The job should send mail that error log info...or successfull info....as attachment

hi,

SELECT owname,CASE WHEN age>4 Then PetCount else 0 END as PtCoun from

( SELECT O.owname,O.owner_id,age, COUNT(Pet_id) PetCOunt from owners O LEFT JOIN pets P on O.owner_id=P.owner_id

GROUP BY O.owname,O.owner_id,age)A

or...

hi,

Use msdb.dbo.sp_send_dbmail...

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

or

see the link given below...

http://www.sqlservercentral.com/Forums/Topic282252-5-1.aspx

We can execute from SQLCMD

try with links given below...

http://www.sqlservercentral.com/Forums/Topic411075-145-1.aspx

http://www.databasejournal.com/features/mssql/article.php/3660226/SQL-Server-2005-Command-Line-Tool-SQLCMD--Part-II.htm

hi,

Is it possible to run from CMD prompt.....

if possible we can execute the commands...the authentication mode is set to Mixed mode....

& Then restart the server.....

Correct me if i am wrong......:discuss:

SET IDENTITY_INSERT [ database. [ owner. ] ] { table } { ON | OFF }

SET IDENTITY_INSERT tablename ON

SET IDENTITY_INSERT tablename OFF

🙂

hi,

I think the following will give help u .....

http://www.sqlservercentral.com/articles/Administration/listofdatabaseuserswithdatabaseroles/1545/

cheers!:-)

Sasidhar Chowdary

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE function [dbo].[Test_GetOrderTable] (@string varchar(max))

returns @tblOrder Table(id int identity(1,1),strings varchar(100))

AS

begin

declare @LocalVar varchar(100)

declare @pos int

set @pos=1

set @LocalVar=''

set @string = ltrim(rtrim(@string))

while (@pos <=len(@string))

...

(billtoaddress1, 'PTE I', 'PT')

replace(billtoaddress1, 'POINTE', 'PT')

replace(billtoaddress1, 'PT #I', 'PT')

replace(billtoaddress1, 'PTE II', 'PT')

replace(billtoaddress1, 'PT # II', 'PT')

replace(billtoaddress1, 'PTE III', 'PT')

replace(billtoaddress1, 'PT #...