SQL Server Tag Directory

Featured SQL Server Questions

Instance specific error when connecting to SQL Server
What is instance specific error? It is occuring while connecting to SQL Server  … how can i fix this error?

Answer Question   |  April 14, 2014  2:06 PM
SQL Server, SQL Server error messages
asked by:
5 pts.

Do extra spaces affect disk space size?
I currently have over 147 columns in a SQL Server database (with the majority of them as VARCHAR). This data is imported from our agency and for extra fields, they all include spaces in the field instead of entering an empty string / NULL. I just ran a script that would covert all those columns...

Answer Question   |  March 27, 2014  5:00 PM
SQL Server database, Storage
asked by:
54,905 pts.

Errors in creating database in SQL Server
While creating a database in SQL Server I got error as: an exception occured while executing a transact-sql statement or batch microsoft.sqlserver,express.connection-info create database permission denied in database master Can anyone tell me how to proceed?

Answer Question   |  February 19, 2014  11:07 AM
SQL Server, SQL Server database
asked by:
5 pts.

How can I restore a database from .mdf file?
How can I restore a database from .mdf file? I only have .mdf backup file.

Answer Question   |  February 12, 2014  12:01 AM
SQL Server backup, SQL Server database restore
2,585 pts.

Trying to get rid of “divide by zero” error message using SQL Server 2008
In SQL Server 2008, I keep receiving this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. Now, this is more of a general question but what is the best way to write SQL code so this message will never appear again.

Answer Question   |  October 31, 2013  1:45 PM
SQL Server 2008, SQL Server error messages
asked by:
54,905 pts.

High LATCH_EX wait
What is LATCH_EX wait? Our LATCH_EX wait is very high. What do I need to look at to fix this?

Answer Question   |  October 28, 2013  6:19 PM
SQL Server, SQL Server 2008, SQL Server Enterprise Edition, SQL Server performance
asked by:
585 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.

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.

Link Oracle 10g with SQL Server problem
I have created a link between our Oracle DB and SQL server db It was successfully created and I was able to select data from oracle table using SQL Server. Then I have created a view in SQL Server using this link to read from Oracle, the view was created: create view dah_test as (...

Answer Question   |  October 23, 2013  8:00 AM
Error 7399, Oracle 10g, Oracle error messages, OraOLEDB.Oracle, SQL Server errors
asked by:
35 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.

store image to sql server
would you please give me a code to store and retrieve an image in SQL Server 2000, using Visual Basic 6.0 on the front end

Answer Question   |  October 23, 2013  8:28 AM
SQL Server 2000, SQL Server Image Store, VB 6.0, Visual Basic, Visual Basic 6.0
asked by:
10 pts.

Cannot connect VB program with SQL Server 2005 in local machine
The simple program of fetching the data of table through vb.net program. I am retrieving the data into DatagridView . I am writing following String str for connection: Dim str As String = " Data Source=COMP1SQLEXPRESS ; Initial Catalog=Atuldb; User Id=COMP1comp11;Password= " my database name is “Atuldb”, I am using SQL SERVER MGT STUDIO. In...

Answer Question   |  October 23, 2013  2:34 PM
SQL Server, SQL Server 2005, SQL Server Management Studio 2005, VB.NET 2008, Visual Basic, Visual Basic .NET, Visual Basic 2008
asked by:
5 pts.

Performance benchmarks for SQL Server 2008 R2
Have performance benchmarks for SQL Server 2008 R2 been published somewhere?

Answer Question   |  October 23, 2013  8:25 PM
SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring
asked by:
54,905 pts.

Errors while attempting the mirroring process in SQL Server 2005
I am using SQL Server 2005 Enterprise Edition, and I’m having a problem beginning the mirroring process. I am receiving the error messages: “Alter failed for Database ‘db_muthu’. (Microsoft.SqlServer.Smo)” “An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)” “Database Mirroring Transport is disabled in the endpoint configuration. (Microsoft SQL Server, Error: 1486)” What...

Answer Question   |  October 23, 2013  7:33 PM
Mirroring, SQL Server 2005, SQL Server Enterprise Edition, SQL Server errors
2,585 pts.

Software to automate backups for SQL Server 2008 databases
I am running SQL Server 2008 and I know how to create backups of this data manually using SQL managment studio but we are looking for a way to automate the process. Does anyone know of a product that can be utilized to do this? Or a way the managment studio can be set up...

Answer Question   |  October 23, 2013  4:44 PM
Automated backup, Backup & recovery, Backup software, SQL managment Studio, SQL Server 2008, SQL Server backup, SQL Server backup and restore, SQL Server Management Studio
asked by:
30 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.

I want to load XML to a table in SQL Server 2005
i have a xml file.now i should upload the tags of the xml as fileds in a table in sql server.automatically the values should be inserted in the table data.

Answer Question   |  October 23, 2013  8:58 AM
SQL Server 2005, SQL Server import/export, XML
asked by:
10 pts.

Install SQL Server Client Components on Windows XP
I use my SQL Server 2000 Developer Edition disk to install client components on my Windows XP. I insert the CD into the drive. I click SQL Server 2000 Components on the first screen. I click Install Database Server on the next screen. An InstallShield icon appears for a few seconds and then nothing. I...

Answer Question   |  October 23, 2013  8:59 PM
Installation, SQL Server 2000, SQL Server 2000 Developer Edition, SQL Server Developer Edition, SQL Server installation
asked by:
5 pts.

Backing up SQL Server 2005 databases to a tape drive
I am currently running SQL Server 2005 and I’ve set up a maintenance plan that backs up my databases to the disk. I’d like to change that and backup my databases to a backup tape drive that’s attached to a backup server. Can this done, and if so, how?

Answer Question   |  October 23, 2013  6:00 PM
Backup, Backup to Tape, SQL Server 2005, SQL Server database
2,585 pts.

Script to restore database permissions during a migration to SQL Server 2005
We are in the process of migrating from SQL Server 2000 to SQL Server 2005, and I’m searching for a script that can transfer and restore the database permissions of all accounts from SQL Server 2000 to SQL Server 2005. I used sp_help_revlog to restore the logins, but I still have to restore the database...

Answer Question   |  October 23, 2013  3:13 PM
Database permissions, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server Database Permissions, SQL Server databases
2,585 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: