I’m trying to access the SQL Server instance on my VPS from SQL Server Management Studio on my local machine. It’s not working (the error I’m getting is: A network-related or instance-specific e...

How can I get the SQL Server server and instance name of the current connection, using a T-SQL script?

Recently just upgraded to SQL Server 2008 R2 Express. When I attempt to create a database after logging in using Windows Authentication with my id myuser I receive this error: An exception occur...

I am at an loose end with one particular box that is running SQL Server 2008 R2 Express. Windows Firewall is configured to allow inbound TCP & UDP 1433, 1434. Windows Firewall is configured t...

select packageid,status+' Date : '+UpdatedOn from [Shipment_Package] The below error is appeared when executing the above code in sql server. The type of UpdatedOn is DateTime and status is a va...

I have the following problem. Background I'm trying to implement an autocomplete selector with MVC3, EF4 and jquery over a table wit 4.5 million records. This is the table: CREATE TABLE [dbo].[...

I have a freshly installed SQL Server 2008 R2 Express. I'm trying to run SQLCMD locally (please do take note locally) but I am receiving the error: Named Pipes Provider: Could not open a connect...

I am developing a web site, it uses SQL Server 2008 R2 Express for its database. And in testing, there is a lot of data and images stored into this database. According to wiki, the SQL Server Expr...

I am working on SQL Server 2008 R2 Express, when I am using SQL Server debugging feature from client pc, this error occurs: The EXECUTE permission was denied on the object 'sp_enable_sql_debug',...

I wanted to drop all the synonyms of a database (sql server 2008 r2) using cursor. environment-database name- 'mydatabase', schema name- 'dbo'.. Can you please guide me as i did try but the stateme...

Initiation I have a SQL Server Express 2008 R2 running. There are ten users who read / write permanently to the same tables using Stored Procedures. They do this day and night. Problem The perfo...

After upgrading to Service Pack 1, sometimes i got failed to login my server at this time, Server Configuration Manager is like below Do I need to change anything? thank you. -- Once I co...

Is there a SQL Server equivalent to PostgreSQL's EXPLAIN command that I can run on SQL Server 2008 R2 Express (ie. without SQL Profiler)?

I am using SQL Server 2008 R2 Express and the "SQL Server and Windows Authentication" mode in my database. I can open the database using Enterprise Manager, but when I run my aspx application, I ge...

When I tried upgrading from SQL Server 2008 R2 Express to SQL Server 2008 R2 Enterprise, it passed all tests and then it failed at step "Select features", saying the following error: There are n...

WARNING: This tale of woe contains examples of code smells and poor design decisions, and technical debt. If you are conversant with SOLID principles, practice TDD and unit test your work, DO NOT ...

I have a query that uses 3 functions and a few different views beneath it, which are too complex to post here. The odd thing I am experiencing is when running the top level query, having more than ...

How can I perform this query on whatever way: delete from sys.tables where is_ms_shipped = 0 What happened is, I executed a very large query and I forgot to put USE directive on top of it, now I...

I am trying to add Reporting Services to my already installed version of SQL Server Express 2008 R2. I am installing it on a Windows Server 2008 R2 Standard edition box. When ever I run the instal...