SQL Server Tag Directory

Featured SQL Server Questions

Behaviour of Service Broker during clustered SQL Server failover
Hi, I have 3 instances of SQL Server 2005 hosted on a 3-node cluster, using Polyserve clustering.  Each instance is nominally hosted on its own node in the cluster. I have configured Service Broker to route messages from INST-A (on NODE-1) to INST-C (on NODE-3), using TCP and a NetBIOS name.  This NetBIOS name obviously...

Answer Question   |  March 14, 2014  2:26 AM
SQL Server clustering, SQL Server Service Broker
asked by:
5 pts.

How can I pass tablename as a parameter in MySQL stored procedure?
my SQL stored procedure is like this…. ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = ‘Insert into ‘ + @_tablename + ‘(ImageID,Status) values (‘+ convert(nvarchar(5),@_ImageID) +’,'+ CONVERT(nvarchar(1),@_Stat) +’)’ –print @strTemp exec(@strTemp) end I want this stored procedure in MYSQL.

Answer Question   |  January 23, 2014  8:38 AM
Database programming, MySQL, MySQL Stored Procedures, SQL, SQL stored procedures, Stored Procedures
asked by:
45 pts.

SQL 2000 migration to SQL 2005 – need to preserve user security
Hi, I have a customer that is planning on moving to new hardware and performing a SQL upgrade (2000->2005).  I know that our application (FileNet Image Services) is sensitive to what we refer to as an “orphaned” database.  Our app stops working if a database is simply detached/attached to another server because it loses that...

Answer Question   |  December 7, 2013  2:24 PM
SQL Database Security, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server security, SQL Server Upgrade
asked by:
5 pts.

SQL Server view column conversion problem
I have a view with a column SWID. The source column is Varchar while in the view creation it has been cast to INT. The source table has a non-numeric value “CITY”, while during the view creation, this record have been filtered out. When I select all records from the view, it’s working well. However, when...

Answer Question   |  November 6, 2013  5:12 PM
Data conversion, SQL Server 2005, SQL Server Query, SQL Server View
asked by:
5 pts.

Free Chapter – Hardening a SQL Server implementation
Another free chapter download is available on the IT Bookworm Blog. Written by: Ross Mistry and Hilary Cotter Book: Microsoft SQL Server 2008 Management and Administration. Overview: “If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert...

Answer Question   |  October 29, 2013  3:24 PM
Database security, Free Chapters, Hilary Cotter, Ross Mistry, Sams Publishing, SQL Server, SQL Server 2008, SQL Server security
asked by:
6,875 pts.

SQL View performance vs. SELECT
I am experiencing slow views on my database. If I create a view and run it, then use the same select statement from the view and run. They both return the same data, but View runs slower. My expectations was that since views are compiled, they should run faster. Could some one clarify this for...

Answer Question   |  October 25, 2013  7:22 AM
SELECT statement, SQL Server performance, SQL Server views
asked by:
5 pts.

Row by Row Stored Procedure in SQL Server 2008 R2
Hi all, Hopefully someone will be able to help me here – I’m nearly there but can’t get it right, I’m trying to create a stored procedure that when it runs, it will do a query and then send send an email out for each of the rows that it returns. e.g. If I have...

Answer Question   |  October 25, 2013  1:36 PM
SQL, SQL Server 2008, SQL Server 2008 R2, SQL stored procedures, Stored Procedures
asked by:
65 pts.

SQL Server 2005 Express SP3 Memory Usage
Upon Startup of my system the sqlwriter process immediately grabs 700mb of RAM and holds it. As I use the SQL Server to do different thing the memory usage grows and causes the memory on my system to decline. The SQL Server never releases the memory and it causes my system to respond slowly. I...

Answer Question   |  October 23, 2013  12:50 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server memory, SQL writer
asked by:
5 pts.

SQL Server 2000 Database Table Limit?
Is there a limit to how many tables a single database can hold in SQL 2000?

Answer Question   |  October 23, 2013  8:18 PM
SQL Limits, SQL Server 2000, SQL Server database, SQL Server tables
asked by:
25 pts.

Running a query on both SQL Server and Oracle databases
How do I run a query that queries a SQL Server database and an Oracle server database, on two different servers, and uses all the data?

Answer Question   |  October 23, 2013  7:47 PM
Oracle, Oracle queries, SQL Server databases, SQL Server Query
2,585 pts.

SQL Server Security Login does not work after restoring database on another computer
I backup the production database on server named SQL1 then restored the database on server named SQL2. SQL server security login name “user1″ has been created on both SQL1 and SQL2 servers. When I restore the database on SQL2 I have to re-map and give db_datareader access to the “user1″ user name again. How can...

Answer Question   |  October 23, 2013  8:59 PM
SQL Server, SQL Server security, SQL Server Security Login
asked by:
585 pts.

SQL Server 2008 Finding Most Recent Record Only
Hi there I have a databse that logs letter print activity The fields being Letter_Ref Print_date Any time someone prints a particular letter it leaves a date in print ref What i want to do is find the most recent print date for each letter_ref is this possible and if so how

Answer Question   |  October 23, 2013  9:26 AM
SQL Record, SQL Server 2008, SQL Server Query
asked by:
20 pts.

Optimizing a SQL Server stored procedure
I want to optimize my stored procedure in SQL Server, as it takes some time to execute. It uses a temporary table to store some data, and then it uses a dynamic query that we execute using the EXEC statement. How can I remove temporary table or, in general, how can i improve performance of...

Answer Question   |  October 23, 2013  4:47 PM
EXEC, SQL Server stored procedures, SQL Server tables
2,585 pts.

SQL Server transactions in ASP code
Can we create sql server transactions in asp, if so how can we manage transactions in asp. Please suggest me, how to do it.

Answer Question   |  October 23, 2013  1:46 PM
ASP, SQL Server, SQL Server transactions
asked by:
100 pts.

Upload Excel to SQL Server Table
I have an Excel spreadsheet with 3 fields being used. (1) Material x(30) Key (2) Description x(30) (3) Extended Description (text) I want to create a table that I can match to an existing table where the key is the Material and update the description and extended description on the existing table. Can you create...

Answer Question   |  October 23, 2013  2:55 PM
Microsoft Excel, SQL Server, SQL Server tables, SQL Sever Commands
asked by:
5 pts.

Performance issues with a large table in SQL Server 2005
I have an application that is managing inventory for a company that has multiple locations. Items are being inserted into an inventory table roughly every 5-6 seconds from three locations. At the same time, this company is packing inventory in boxes in order to fulfill orders. I have a table setup for this in which...

Answer Question   |  October 23, 2013  12:11 AM
SQL Server 2005 performance, SQL server 2005 performance tuning, SQL Server query optimization
asked by:
5 pts.

Union operator in SQL server 2000
How to give where condition to the result of the query using Union operator?

Answer Question   |  October 23, 2013  7:27 AM
SQL Query, SQL Server, SQL Server 2000, SQL Server Query
asked by:
45 pts.

Reading xml url into SQL Server 2008 Table with OpenXML
I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url...

Answer Question   |  October 22, 2013  5:21 PM
SQL Server, SQL Server 2008, SQL Server tables, SQL tables, XML, XML development
asked by:
5 pts.

Writing a query to store an image file in a SQL Server 2005 table
How would I write a query to store an image file in a SQL Server 2005 table?

Answer Question   |  October 22, 2013  7:02 PM
SQL Server 2005, SQL Server Query, SQL Server tables
2,585 pts.

(provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53
Problem: SQL SERVER is up and the instance connect is running. All required ports on Firewall is open/ also try to disable Firewall but no success. TCP/IP protocol is ENABLE.  SQL SERVER port is by Default 1433. Also try this: The problem is the Instance name from the client is not resolved, to do that...

Answer Question   |  October 22, 2013  4:22 PM
SQL Server connectivity, SQL Server error messages, SQL Server Remote Connections, TCP/IP Protocols
asked by:
30 pts.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: