If you are getting a timeout while on the table designer, change the “Transaction time-out after” value under Tools –> Options –> Designers –> Table and Database Designers This will get rid of this message: “Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.”
Try specifying the port: import pyodbc server = r”xxxER\xxxSQLSERV” db = “xxxDB” user = “xxx” password = “xxxx” port = “1433” conn = pyodbc.connect(‘DRIVER={SQL Server};SERVER=’ + server + ‘;PORT=’ + port + ‘;DATABASE=’ + db +’;UID=’ + user + ‘;PWD=’ + password) If you’re still having issues, try using the IP or FQDN of the … Read more
You can create .sdf files with SQL Server 2008 Management Studio. In the File > Connect Object Explorer dialog, change the Server Type dropdown to SQL Server Compact Edition. Then in the Database File dropdown choose New Database…. and you’re ready to go.
Have you already looked at adding a check constraint on that column which would restrict values? Something like: CREATE TABLE SomeTable ( Id int NOT NULL, Frequency varchar(200), CONSTRAINT chk_Frequency CHECK (Frequency IN (‘Daily’, ‘Weekly’, ‘Monthly’, ‘Yearly’)) )
In Mgmt Studio, when you are editing the top 200, you can view the SQL pane – either by right clicking in the grid and choosing Pane->SQL or by the button in the upper left. This will allow you to write a custom query to drill down to the row(s) you want to edit. But … Read more
SQL Server was not configured to allow mixed authentication. Here are steps to fix: Right-click on SQL Server instance at root of Object Explorer, click on Properties Select Security from the left pane. Select the SQL Server and Windows Authentication mode radio button, and click OK. Right-click on the SQL Server instance, select Restart (alternatively, … Read more
I suggest you split your stored procedure into two procedures that each respectively return a separate table and have those called to different worksheets. There are a variety of ways to return data to Excel using SQL Here is a favourite of mine from code by Joshua (you don’t have to use the parameters): Select … Read more
The behavior is documented here: A large result set splits the long JSON string across multiple rows. By default, SQL Server Management Studio (SSMS) concatenates the results into a single row when the output setting is Results to Grid. The SSMS status bar displays the actual row count. Other client applications may require code to … Read more
Had the same problem, I fixed it. Open SQL Server Configuration manager Click on the SQL Server Services (on the left) Double-click on the SQL Server Instance that I wanted to start Select the Built-in account radio button in the Log On tab and choose Local system from the dropdown menu Click apply at the … Read more
LocalDB was introduced in SQL Server 2012 CTP3. It’s basically a new version of SQL Express, with same functionality, dedicated to developers. So you don’t need to install any SQL server. If you have installed SQL 2012 or Visual Studio 11 then you already have it, and it runs over .Net 4 or higher. If … Read more