New answers tagged

0

I found that the distribution and publication wasn't correctly disabled. When I tried to run the disable the publishing and Distribution (as seen in my image above) I was getting an error that the process couldn't complete because the distribution database was still in use. so I used SELECT spid FROM sys.sysprocesses WHERE dbid = db_id('distribution') to ...


1

You could try a "script the script" approach by using the SQLCMD :out command to redirect output, with :connect and optionally :r to read the output, something like this: SET NOCOUNT ON DECLARE @tbl TABLE (Id int IDENTITY (1, 1),ServerName sysname, DbName sysname, IsDone BIT DEFAULT(0)) INSERT INTO @tbl (ServerName,DbName) VALUES (N'CZASQL-001', ...


1

I too was experiencing a 5 to 10 second delay when right-clicking a table to pull up the context menu. My situation might be a little different than some however because I use local databases only. My solution: After reading the answer from imran about disabling antivirus, I took that concept a step further since I do not want to disable my antivirus ...


8

If you are asking whether it is possible to enforce the database defaults for every connection that ever happens on the server, then no. Those defaults only take effect if something contradictory isn't set at the connection level. In any individual batch in SSMS you can use statements like SET ANSI_NULLS ON, SET ANSI_NULLS OFF, SET QUOTED_IDENTIFIER ON, and ...


3

Here is a simple script that might help you. Works for me on SQL Server 2008 sp2 select @@version --Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) --Sep 16 2010 19:43:16 --Copyright (c) 1988-2008 Microsoft Corporation --Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) Part 1: ...


3

Come clean ASAP. The sooner you do this the better. If I'm reading the timeline correctly, when you restored the FULL backup over your production database you broke the backup chain. This means you wont be able to get the data for 06:30PM to 10:00PM into your current database that holds data for 01AM to 06:30PM + new data since the RESTORE. I would ...


3

First off... I think it is best to come clean to your manager on such issues. The business will notice the missing data and he will not appreciate being blindsided and not having all the facts at hand. In that event, things will be even worse for you. If you have no formal background in DBAing, you have no business doing DBA tasks and/or the real ...


5

Use extended properties. It's not in the INFORMATION_SCHEMA views but it will stay attached to that object. I wrote about it in detail here: https://sqlstudies.com/2015/05/18/extending-your-metadata-with-extended-properties/ But here is what it would look like attached to a User: Here is how you would query all of the extended properties for users in a ...


0

Thank you for the schemas. I did modify the employee table to include a manager bit flag which makes the query a bit easier. This doesn't exactly reproduce your desired results, but it is very close. If there is no manager comment on the last plan do you need to include the manager ID? Also, I wasn't sure on the date to include so the date is there for each ...


0

Found the answer to the original question - the new volume became browse-able after restarting the agent. (But Max's workaround is still great)


2

From BOL (SSMS Release notes), recent versions of SSMS are outside of SQL Server release. release of SQL Server Management Studio (SSMS) is a stand-alone install outside of the SQL Server release. Our goal is to update this frequently with new functionality, fixes, and support for the newest features in SQL Server and Azure SQL Database. As far as ...


3

In the past, the releases lined up - each new SQL Server was accompanied by a new Management Studio. However, in June of 2015 (concerning SQL Server 2016 and onwards) MS announced separate life cycles: With the release of SQL Server 2016 Community Technology Preview (CTP) 2.1, customers can for the first time experience the rapid preview model for ...


2

It might be latency, or it might be something else. Run a SQL Server Profiler trace on the remote DB, starting the trace just prior to connecting via SSMS remotely. IntelliSense works by running queries to get the meta-data, so you will be able to see if it is even attempting to work or not, and if so, potentially if it is running into any problems. You ...


2

+1 for sensibly wanting to get the backups on a separate drive. However, if the new cluster volume is on the same SAN, you're not really accomplishing much. It would likely be much better to run backups to a file share on a totally different system. As a workaround, you can easily add an "Execute T-SQL Statement" task to your Maintenance Plan to manually ...


1

It looks like you have only installed SQL Server Management Studio (SSMS), and not SQL Server. SSMS is the tool used to connect to and manage SQL Server Instances, if you haven't installed a SQL Server instance you have nothing to run your queries against! Press Windows Key + R (Run) and type services.msc, check to see if the 'SQL Server' appears and that ...


2

It turns out that it was indeed a bug that was squashed with the release of RC2 on 4/4/16. It had been occurring since the October preview, and I appreciate everyone's time and attention.


2

Since this is not a fully released version yet, I'd recommend opening a Microsoft Connect for this issue to make sure it gets addressed (I couldn't find a similar one myself after a bit of searching). I'm not sure that it's within the scope of DBA.se to troubleshoot release candidate software issues. I'd probably stick with SSMS 2014 until 2016 is fully ...


2

There are various possibilities and I will try to answer them according to the numbered questions. Valid connection strings for the SSMS login box are: 1st instance Using the host name SERVERNAME SERVERNAME,1433 Using the CNAME/Alias SERVERNAME-I01 SERVERNAME-I01,1433 Using the IP address 123.1.2.3 123.1.2.3,1433 For the Dedicated Admin ...



Top 50 recent answers are included