navamnk
Last Activity: Jan 5 '07, 02:25 PM
Joined: Jan 3 '07
Location:
-
First use sp_changeobject owner to convert the ownership to dbo from that user and then drop the unwanted user. -
Directly you can do this using SQL JobsLeave a comment:
-
SUSER_NAME is given in SQL 2000 only for backward compatibilityLeave a comment:
-
Refer this SQL Server Book Online article
"How to restore a differential database backup"Leave a comment:
-
Read the SQL Mail documentation and Refer this link also
HOW TO: Troubleshoot SQL Mail with Microsoft Exchange ServerLeave a comment:
-
select category, max(rate)
from table_name
group by categoryLeave a comment:
-
Use DTS Import/Export Wizard and then save it to the SQL Server msdb databaseLeave a comment:
-
CREATE TRIGGER alteredRecord ON [dbo].[tableA]
FOR INSERT, UPDATE, DELETE
AS
BEGIN
...declare lngIns & lngDel
SELECT lngIns=count(co l1)
from inserted
select lngDel=count(co l1)
from deleted
IF lngIns>0 and lngDel=0
....inserted
else if lngIns>0 and lngDel>0
...updated
else if lngIns=0 and lngDel>0
...deleted...Leave a comment:
-
use this statement in your SP
SET DATEFORMAT mdyLeave a comment:
-
use OSQL command line utility to get all the result in a txt file.
open command prompt and type OSQL /? for more optionsLeave a comment:
-
create a view (based on your query + include some more where condition to eliminate zeros & spaces) and then directly insert it to the new table.
like,
insert into ...(finance. table)
select ....
from (new view)Leave a comment:
-
I think, the mdb file is access by some other application or one of the table is opened by you.Leave a comment:
-
FTP the mdb file to Windows at regular intervalLeave a comment:
-
take a full backup and truncate the logLeave a comment:
No activity results to display
Leave a comment: