Viewing 15 posts - 27,226 through 27,240 (of 39,793 total)
Multiserver administration means that the services running SQLAgent must actually connect to other instances. LocalSystem isn't an account that can connect to other servers. You will need to change the...
September 1, 2008 at 8:43 am
you could call a VBScript/Powershell file to do this, calculate the date and delete the file. That might be easier.
Or use an SSIS package to do this. Maintenance plans have...
September 1, 2008 at 8:42 am
Can you translate the error?
Does the Add linked server section work? Does this appear in SQL Server?
September 1, 2008 at 8:41 am
If these need to always happen, why not add Profile to the first table, give it a default value of a space?
You could use a trigger to ensure a...
September 1, 2008 at 8:40 am
Please watch the forum title and post in the appropriate forum. Moved to T-SQL forum.
I'm not sure what you're calculating there, but it's not a percentage.
Percentage is (valuea/valueb) * 100.
September 1, 2008 at 7:48 am
What about a fast triangular join? Maybe it will flatten out to a linear algorithm :hehe:
August 31, 2008 at 11:29 am
If you get something to work, I'd be interested to see what happened here.
And good luck
August 31, 2008 at 9:35 am
You should probably read the security sections in Books Online to understand this. Not to beat on you, and I know you just want to get something working, but not...
August 31, 2008 at 9:35 am
You can also see the code in the master database. I thought that 'domain\user' would work, but perhaps it's user in the database and not login.
August 31, 2008 at 9:29 am
You can always call Microsoft PSS and perhaps they can help you with getting some data, but we can't do anything with had header files.
August 31, 2008 at 9:25 am
And please make an attempt to do the work. This almost sounds like a homework or exam question.
Hint: Use UPDATE for the SQL side.
August 31, 2008 at 9:24 am
I haven't seen this before. My guess is that you didn't complete something on the first instance that was installed. Did you install any hotfixes or patches on that first...
August 31, 2008 at 9:23 am
The paths from EM are paths that the SQL Server service account sees, not what your account sees. Don't forget this is a server service, it is not running under...
August 31, 2008 at 9:18 am
It sounds like a tool corruption issue or perhaps memory on the workstation. Are you opening SSMS from the console or your workstation?
August 31, 2008 at 9:14 am
I have used MOM briefly and What's Up Gold, but not Idera. You can download an eval and give it a try. See what you think. Most of these package...
August 30, 2008 at 9:08 am
Viewing 15 posts - 27,226 through 27,240 (of 39,793 total)