Viewing 15 posts - 541 through 555 (of 1,248 total)
I got it. A user needs to be a member of sysadmin to create and manage the maintenance plans.
March 13, 2008 at 3:06 pm
After creating your publisher, related jobs are created. Check msdb..sysjobs and see whether or not the job exists.
If not, it may be renamed, removed, modified, ...
If you cannot restore it,...
March 13, 2008 at 12:07 pm
UserDev has dbo right. It should be able to do it.
While running DTS package, what account did you use?
March 13, 2008 at 9:50 am
Right-click the database your table belongs to;
...
You cannot miss it.
March 13, 2008 at 9:29 am
Is it the full error message?
Do you use JAVA?
Does your server have a limit in concurrent users?
The following link may help a little bit.
March 13, 2008 at 9:18 am
The size of your backup file is smaller than the sum of your data and log files. It is reasonable. From your data, log file takes about 60 GB in...
March 13, 2008 at 9:08 am
1 GB RAM is small. You may need more.
If you are talking about SAN drive, it is better but more expensive.
March 13, 2008 at 8:57 am
I do not think you can get it directly. DTS packages are saved in binary code.
You may set a profiler, or trigger to see what processes are running when you...
March 13, 2008 at 8:53 am
sp_msforeachdb "exec mydb..myProc"
March 13, 2008 at 8:46 am
Go to your registered server;
Right-click it and choose Properties;
Select Memory folder;
...
You would not miss it.
March 13, 2008 at 8:40 am
More redunant? Money burning? I never see a company have them at the same time.
March 13, 2008 at 8:37 am
What version of SQL do you use? In my memory, the Developer version has a limit for concurrent users.
March 12, 2008 at 8:02 pm
Drop the subscribers, then drop the table.
March 12, 2008 at 7:58 pm
You need to have a domain account if the database needs to talk with other database servers.
I saw people use NT Authority account to start SQL Server, but I...
March 12, 2008 at 7:54 pm
I was saying you could not. I mean that you may take a look at your resolver settings what actions will take when a conflict occurs.
March 12, 2008 at 10:38 am
Viewing 15 posts - 541 through 555 (of 1,248 total)