Viewing 15 posts - 616 through 630 (of 2,863 total)
As far as I am aware, and if I am understanding what you are saying, you can't do that. I am PRETTY sure that SSDT would push across all of...
February 1, 2022 at 7:39 pm
I am 99.999% sure that an INSERT failure is going to be different than a failed login error. The INSERT failure sounds like you are modifying a maintenance plan with...
January 31, 2022 at 8:04 pm
Something to note - installing an unsupported application (SQL 2000) on an unsupported OS (any that would support SQL 2000) will result in an unsupported scenario.
That being said, a quick...
January 31, 2022 at 3:01 pm
My opinion - check the logs. The message "the login failed" makes me think that the account was locked out or otherwise disabled. If it is an AD account, if...
January 31, 2022 at 2:49 pm
Is it always failing on the same file? If so, then it is likely something with that file and the restore. If it is sometimes failing on that file and...
January 28, 2022 at 10:17 pm
My approach is to design the database with restrictions in place to begin with. Use roles to restrict what data a user is allowed to access. I expect (ie hope)...
January 28, 2022 at 10:12 pm
Might not hurt to check out the Exchange error logs and see what those say. Could be something that is easily corrected by reviewing the logs on the other side...
January 28, 2022 at 10:00 pm
SSRS Standard, as far as I am aware, doesn't support clustering and only allows you to host it on 1 server.
I believe you would need to upgrade to Enterprise to...
January 28, 2022 at 9:47 pm
You could use ISNUMERIC.
Personally, if I COULD I would be changing the application that puts the data into the system to validate it and refuse to store invalid data.
Failing that,...
January 28, 2022 at 9:43 pm
I've been noticing this too. Hopefully it gets fixed soon.
I DO get notifications to new private messages, but not to replies to forum posts...
January 28, 2022 at 9:36 pm
Alternately, if you don't have a VS subscription, you could reach out to the company you purchased SQL Server 2012 from and they should be able to provide you with...
January 28, 2022 at 9:36 pm
My opinion - I would do whatever works best for the tool you are using. BUT I would also be careful about using a tool to monitor SQL error logs. ...
January 27, 2022 at 2:25 pm
My advice - review the error and check the logs.
The error should tell you what is wrong, and in the event it doesn't, the logs should tell you what is...
January 26, 2022 at 7:26 pm
Things that I would check are:
1 - does the service account have permissions to the folder AND file?
2 - does any other application or service have the file open at...
January 26, 2022 at 3:44 pm
Viewing 15 posts - 616 through 630 (of 2,863 total)