Viewing 15 posts - 1 through 15 (of 33 total)
anthony.green (1/11/2013)
What edition of SQL are you running Enterprise, Standard?
Enterprise 64-bit
How often do you need to refresh the destination database? Does it need to be close to real time...
:-):cool:
January 13, 2013 at 5:19 pm
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...
:-):cool:
January 10, 2013 at 4:06 pm
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...
:-):cool:
January 9, 2013 at 4:50 pm
anthony.green (1/9/2013)
Do you have any columns in tables called Error or ErrorCode or something similar?
hmmm... maybe there are... i'll verify once I've got back to office tomorrow.. it is a...
:-):cool:
January 9, 2013 at 7:15 am
anthony.green (1/8/2013)
Can you run the package in SSDT and post the entire copy of the output screen?
SSIS package "c:\users\<user>\documents\visual studio 2010\Projects\Solution SSIS\Project SSIS\Copy DB.dtsx" starting.
Error: 0xC0024104 at Copy DB: The...
:-):cool:
January 8, 2013 at 4:08 pm
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...
:-):cool:
August 28, 2009 at 1:33 pm
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...
:-):cool:
October 9, 2008 at 1:43 am
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.
:-):cool:
August 1, 2008 at 2:51 am
have you refreshed your view in Enterprise manager?
:-):cool:
August 1, 2008 at 1:19 am
kill / terminate all connections to your database being restored.
:-):cool:
August 1, 2008 at 12:40 am
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...
:-):cool:
July 3, 2008 at 2:46 am
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...
:-):cool:
May 8, 2008 at 6:03 am
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...
:-):cool:
May 8, 2008 at 4:11 am
I have tried that. but didn't give me the desired result.
:-):cool:
May 8, 2008 at 3:51 am
Viewing 15 posts - 1 through 15 (of 33 total)