New answers tagged sql-server-2005
Eduardo Molteni asked this in 2012 for running on Windows 8 (not 8.1) and came back a few days later with his solution. You might give it a try. http://stackoverflow.com/questions/13520551/how-to-install-sql-server-2005-express-in-windows-8 The secret sauce, according to Eduardo is: After you run the install file SQLExpr.exe look for a hidden folder ...
As per Microsoft Official document SQL Server 2005 (the release version and service packs) and earlier versions of SQL Server are not supported on Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8. You will receive a warning in the Action Center if Windows 8.1 or Windows 8 detects an instance of SQL Server 2005. To resolve this issue, ...
That hexadecimal job name must have come from job_id column which is present in both msdb.dbo.sysjobhistory table and msdb.dbo.sysjobs table. What does below query returns for the hex job ID select sj.name, sj.description, sjh.step_name from dbo.sysjobhistory sjh join dbo.sysjobs sj on sj.job_id=sjh.job_id where sjh.job_id=''--hex value
Using an intermediate table is the proper way to do this. With proper indexes and good maintenance it won't hurt performance much at all. Avoid the multi-column solution (refid1, refid2 etc.) - that's repeating groups and not properly normalised. Plus your queries will degenerate into a dog's breakfast of OR clauses and CASE statements, which will hurt ...
One way to do it - have a varchar column with a delimited list of additional references if they exist (123,458,658,587 etc). Then create a UDF to split that data if it exists, which you can use in SELECT queries. Should be easy to design the UDF to extract the data. Since it is rare it shouldn't hurt resources much. A varchar column should also mean minimum ...
Yes it is possible to achieve what you are asking with sql server database replication. The target server must be the same version or higher than the source. Replication can be run at regular intervals or continuously if you need updates "up to the minute".
I'm lead to believe that TLS is only appropriate/supported across the same versions of SQL Server. Let me tell you transaction log shipping is nothing but trasfer of log records from one server to another its quite light and you can create your own 'logshipping' by creating backup,copy and restore jobs. What you are trying to do is one way possible may ...
If the issue you are having is Truncation you can use this XML approach that gets around most of the issues with XML entitisation. declare @VeryLongText nvarchar(max) = ''; SELECT top 100 @VeryLongText = @VeryLongText + ' ' + OBJECT_DEFINITION(object_id) FROM sys.all_objects WHERE type='P' and is_ms_shipped=1 SELECT LEN(@VeryLongText) SELECT ...
As far as SQL Server is concerned, whenever results are going out the door, it's ASYNC_NETWORK_IO whether it's shared memory or TCP/IP.
Can you please look at SQL Server errorlog and see if you could find some relevant information on both Principal and mirror. Generally if SQL Server CPU utilization goes high above 50 % there can be failover. This is specifically caused by heavy load on SQL Server this is documented in Below Microsoft Web resource See 'recommendation for Configuring partner ...
My employer wants to keep the data, but not in a database, and wants to be able to restore it to that database if the need arises. If you want the data to be restored later, then best is to Script out schema of the tables that you wish to drop and save it as a sql script. BCP out the data (without using -n switch as -n is for native format which is ...
Not sure why your boss doesn't want to keep a backup of the DB on hand in the case of need of future restore, but I guess he has his reasons. The nice thing about exporting this data out to text files is that you could always import them back into databases that aren't necessarily SQL Server in the future - as well as read them with text editors in a pinch. ...
I would save the tables that you don't need as an SQL script - to be zipped afterwards. There's a freebie tool which does this here.
I finnaly found something : Reboot the server ! I absolutely have no idea why. Thanks @wBob for your help.
Top 50 recent answers are included