Browsing articles tagged with "sqlserver - 6/164 - Admins Goodies"
Apr 29, 2012
tom

SQL Server 2012 not visible on local network

Currently I have SQL Server running on a local machine and it is working. However I would like to connect to it with my other machines on the network. The other machines do not see this SQL Server. Do I need to configure the sever to allow remote connections? If so how can I do ths and where. Thank you. Asked by Brandon Wilson It should be listening by default I believe, but I suspect […]

Continue Reading »
Apr 27, 2012
tom

Windows Server 2008R2 Enterprise for Web Server. Any Benefits?

Hi I’ve looked at the comparison charts between editions of Windows Server 2008 R2 but I don’t see a definitive answer to my question. We have licenses for Windows Server R2 Web as well as R2 Enterprise. Our asp.net MVC3 server will run on a dedicated server with the following specs: Dual Quad Core Xeon e5620 2.4GHz (w H/T) 12 gb ram 3Ware 9650-4LPML raid card 4 – 500 GB SATA drives The server will […]

Continue Reading »
Apr 26, 2012
tom

How Do I Configure SQL Server 2005 Backend?

I am trying to develop an inventory/payroll system for a factory. The information will be stored on a server, Windows Server 2008 R2, and SQL Server 2005. I’m going to store the records on the server, but will develop several front-end client forms in MS Access 2010. The information is currently in an MS Access 2010 database(local), and I’ll eventually need to get this data on the server. I currently have a remote desktop access […]

Continue Reading »
Apr 25, 2012
tom

Deriving the SQL query from sys.syslockinfo

With the following query I can find processes on the dataserver select *,db_name(rsc_dbid) as db_name from sys.syslockinfo (nolock) Can I derive the SQL query from processes that are blocked? Specifically, we get orphaned, blocking processes (with a req_spid of -2) but we don’t know why. Asked by Synesso Have a look at sp_WhoIsActive from Adam Machanic. It tells you what’s running, what’s blocking, and it derives the SQL text from those queries. Answered by Randolph […]

Continue Reading »
Apr 25, 2012
tom

SQL Server Browser: Why is it disabled?

I am attempting to start SQL Server Browser through the SQL Server Configuration Manager. However, not only is the “state” of SQL Server Browser stopped, but the options to Start, Stop, Pause, Resume, and Restart are all disabled (both in the right-click context menu, and through the Properties dialog). (Also, in the Properties dialog, I have attempted all 3 options for “built-in account”: Local System, Local Service, and Network Service. I have also attempted “This […]

Continue Reading »
Apr 23, 2012
tom

How to set up SQL Server to offer high availability during windows updates

We have a load-balanced web farm talking to a single SQL server instance. It is easy to demote web servers, install Windows updates, reboot, and then bring them back into the fold. However, we have to schedule downtime to service the SQL Server machine. What options are available to avoid such downtime? Asked by Michael Teper SQL Clustering will give you the high availability that you’re looking for, as you’ll be able to apply updates […]

Continue Reading »
Apr 21, 2012
tom

SQL Server Log Databases Starting Up Every Hour

I have been doing an audit of my SQL Server log, as I ‘thought’ it was locked down but appeared to be open and we were getting a lot of password attempts on the SA account. After sorting that, I have noticed throughout the day in the ErrorLog I have entries like this 2012-04-20 09:45:13.08 spid81 Starting up database ‘DatabaseNameOne’. 2012-04-20 09:48:45.23 spid65 Starting up database ‘DatabaseNameTwo’. 2012-04-20 09:53:58.16 spid143 Starting up database ‘DatabaseNameFour’. 2012-04-20 […]

Continue Reading »
Apr 20, 2012
tom

How to upgrade sql server express 2005 to 2008R2

Im using EF 4.1 in visual studio 2010, and I would like my sql server db on the server to be 2008R2 (because I want to use the migration tool from MS for EF in VS). Tool : http://visualstudiogallery.msdn.microsoft.com/df3541c3-d833-4b65-b942-989e7ec74c87/ Problem is, the migration tool complains the version of the db is too old (90) .. so I figured for 2008R2 it wants it to be 100. I have installed (somehow) sql server 2005, 2008, 2008r2 […]

Continue Reading »
Apr 18, 2012
tom

Export SSMS database connections to a new version

I just installed SSMS 2012 and realized it didn’t copy my database list (the one that appears on the ‘Connect to Server’ dialog). I have a ton of entries there, is there any way I can export them to the new version of SSMS? Asked by Joe Behymer In the registered servers window open “Database Engine” and right click on Local Server Groups. Select Tasks, then “Previously Registered Servers”. This should import them. Answered by […]

Continue Reading »
Apr 18, 2012
tom

Sql Server 2005 navarchar to IN

I have a nvarchar value something like ‘1,3,5,6’, in my database table But I want to use this in a where condition, something like this where event_id IN (1,3,5,6) How do I achieve that, How can I convert it and use in the IN of a query Asked by Tripz This must be done via dynamic SQL. Something like this. DECLARE @val nvarchar(20), @sql nvarchar(100)set @val = (select SomeColumn from SomeTable)SET @sql = ‘SELECT * […]

Continue Reading »
Pages:«123456789...164»