Enterprise 64-bit

How often do you need to refresh the destination database? Does it need to be close to real time...

The vendor has its own replication to set in place but as of the moment it is not yet ready to implement. As an interim solution to create a DB...

Is there a way to verify if that is the issue? like where can I get the log/or specific error that causing it? I need to show to higher people...

hmmm... maybe there are... i'll verify once I've got back to office tomorrow.. it is a...

SSIS package "c:\users\<user>\documents\visual studio 2010\Projects\Solution SSIS\Project SSIS\Copy DB.dtsx" starting.

Error: 0xC0024104 at Copy DB: The...

Hi guys, we just put the job to WIndows scheduler instead of the SQL agent. the job is OK. I am no linger with that project but thats the work...

Is there a known issue on scheduling SQL job in SQL 2000 in Windows server 2003? I tried to use bat file to execute the vbs script as CmdExec instead...

its because you restore the full backup with NORECOVERY option... do you have additional backup like transaction log backup to restore?

check the syntax of RESTORE DATABASE in BOL.

have you refreshed your view in Enterprise manager?

kill / terminate all connections to your database being restored.

I guess if you don't want to have the user access to other objects, better let your user create or alter the SP in his/her local server, say MSDE or...

ok... I will try that... thanks.

by the way...

my SQL instance here has only SA and Builtin\Admin in the logins... but if there are other logins without server roles, it will just be included in the...

Here you go...

[font="Courier New"]QUERY:

SELECT DISTINCT(sxl.name) AS MemberName,

CASE

WHEN

spv.number & sxl.xstatus = spv.number THEN spv.name

ELSE ' -- '

END AS ServerRole

FROM master..spt_values spv JOIN master..sysxlogins sxl

ON spv.low = -1

AND...

I have tried that. but didn't give me the desired result.