Tag Info

New answers tagged

0

If you lost your database files, then only a restore will help. If you did not lose your database files, and only the built-in files are missing, try to restore only those and then go with the repair.


1

As previously stated, UTC does not observe daylight savings. Hence it's "universal" nature. However, if your application is telling MySQL to change timezones when it connects with SET TIMEZONE = 'Europe/London'; for instance, then your RDS's NOW() and other time related functions WILL observe daylight savings. If you (or your application) does not set the ...


0

UTC does not have daylight savings time. See also http://en.wikipedia.org/wiki/Coordinated_Universal_Time#Daylight_saving_time: UTC does not change with a change of seasons, but local time or civil time may change if a time zone jurisdiction observes daylight saving time (summer time). For example, local time on the east coast of the United States ...


0

I do something similar with our MSSQL box in VBScript. (Quiet all of you that know this is the wrong way to do this..it works dammit). But I only do this dump once a year. It works, it is simple and does what I need it to do. Though honestly this is a SO question like mfinni said. (sorry) ' VBS to read a BLOB (actually Image) column in SQL Server and ...


4

I don't think there's anything you can do to change SQL server's behavior regarding password sensitivity. I think you first would want to be sure you've exhausted all efforts to locate the source code for those modules. Otherwise, Here are a couple of ideas: Use a hex editor to edit the binary executable files to change the password to the correct case. ...


2

Yes and no... The server is capable of running the applications and Windows Server 2008/2012 from a CPU and RAM perspective. However, there is a fairly large limitation in the storage array controller for that particular server line. HP ProLiant servers are available in "e" (essential) and "p" (performance) variants. If you can afford the initial cost, the ...


0

Check the below link, likely a security issue, the user that runs the job needs access on the other server... http://www.sqlserverblogforum.com/2012/06/login-failed-for-sqlstate-28000-error-18456-the-step-failed/


0

You can block the sql with a firewall, it does not need internet connection, it is communicating with apache witch has all the internet connection it needs, i suggest you install netlimiter, and you might want to back up your files and do a virus scan. pref with avast boot scan. Good luck. PS i dont recommend any build in OS firewall windows apple or ...


1

I had similar problems working with SQLCMD in Bash and as of now this question is ranked third when searching for sqlcmd cygwin on Google. I too thought that it was due to line endings because of the error, Sqlcmd: Error: Internal error at ReadTextLine (Reason: Unspecified error). I tried various trickery such as process substitution but that didn't work. ...


0

It took a while digging through the tables (i was also out of town for a couple weeks) but here is how i ended up doing this. run sql select count(typeproduct.name) as Count, typelicensedresource.name as LicenseType, dp.name AS Site from typeproduct, typelicensedresource, typelicensedresourceproductmap, devicepool as dp, device as d where ...



Top 50 recent answers are included