Viewing 10 posts - 106 through 115 (of 115 total)
Hi,
I have not used OPENROWSET ever, so have no idea. But for the same requirement, I think you can try using DTS. A data transformation task with source as ".xls".
Renuka__
[font="Verdana"]Renuka__[/font]
December 13, 2007 at 7:05 am
Hi,
Or may be you can try this:
exec sp_configure 'affinity mask', 0x0000FFFF
GO
reconfigure with override
go
Renuka__
[font="Verdana"]Renuka__[/font]
December 13, 2007 at 6:42 am
Hi,
May be you check the table: msdb..restorehisory. It holds the information like the date of restoration, which login was it done from, destination databases etc.,
Renuka__
[font="Verdana"]Renuka__[/font]
December 13, 2007 at 4:51 am
Hi,
After you restore the database from one server(Production) to another(Development), on the development server, under the restored database, run the query:
sp_change_users_login 'report'
This gives the list of orphaned entries. Map these...
[font="Verdana"]Renuka__[/font]
November 2, 2007 at 8:05 am
Hi,
May be you can try running a profiler with minimum required events and if you already have some databases in mind (unused) , use the DBID for filtering.
Renuka__
[font="Verdana"]Renuka__[/font]
October 24, 2007 at 2:26 am
Hi,
I think you can try either "select @@version()" or "xp_msver"....
Renuka__
[font="Verdana"]Renuka__[/font]
October 22, 2007 at 10:30 am
Hi,
If you want the updates on publisher should be replicated to Subscriber, you can use either Snapshot or Transactional Replication (Depending on your requirement). Only if you require the updates...
[font="Verdana"]Renuka__[/font]
October 19, 2007 at 7:56 am
Hi,
One of the possible reasons is "Overlapping Schedules". May be you can check if there is any other job running at the same time, when this job runs....
Renuka__
[font="Verdana"]Renuka__[/font]
October 19, 2007 at 6:13 am
Hi,
Actually as you mentioned, creating a role on Database B with the required access on required objects should be fine. (Im not sure if there is any other way). Later,...
[font="Verdana"]Renuka__[/font]
October 18, 2007 at 7:40 am
I think you can as well use --SELECT SERVERPROPERTY('ProductLevel')-- to get the sevice pack applied.....
Renuka__
[font="Verdana"]Renuka__[/font]
October 16, 2007 at 9:20 am
Viewing 10 posts - 106 through 115 (of 115 total)