SQL Server Tag Directory

Featured SQL Server Questions

What data should be stored in SQL Azure and Table Storage?
My team and I are in the planning phase for the typical social networking type of a web application. It includes profiles, messages, chats, groups, albums, etc. But now we’re trying to figure out the deciding factors on what data should be stored in SQL Azure and what should be stored in Table Storage. Can...

Answer Question   |  April 8, 2014  6:00 PM
Azure Table Storage, SQL Azure
asked by:
56,535 pts.

Restore a SQL Express 10.0 database
How can I restore a SQL Express 10.0 database on SQL Express 10.5?

Answer Question   |  April 4, 2014  11:39 AM
Database, SQL Express
asked by:
5 pts.

How to extract key phrases from a log file using a batch file.
How can I  extract key phrases from a log file using a batch file.  I am new to this. I need to know how to extract key phrases from a log file using a batch file. I need to create the batch file first to extract the phrases from the log file.  I don’t need to...

Answer Question   |  January 14, 2014  1:18 AM
Performance testing, RSScripter
asked by:
60 pts.

SQL 2008 Security: How do I give users access to just views within a DB?
I have inherited a SQL DB and need to give a group of users access to some views within a DB. We do not want them to access the tables, just the views. They will be connecting using MS Excel for reporting purposes. Do I use a role or schema? What is the best practice...

Answer Question   |  December 12, 2013  5:19 PM
Microsoft Excel, SQL, SQL 2008
asked by:
5 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 2005 Security to access 2 databases on same server via Stored Procedure
We are tyring to apply best security practices by only granting EXECUTE security to Stored Procedures connected to a Role and make users members of the role. However the SP needs to access data from another DB on the same server and when trying we receive “SELECT permission was denied on the object”. We have...

Answer Question   |  December 6, 2013  8:33 PM
Database management, Security, SQL 2005, SQL Server 2005, Windows Server 2003
asked by:
15 pts.

SQL 2000 & Outlook 2000
We have a couple of SQL 2K Servers which have a mailbox associated with them, have always used Outlook 2000 because anything newer does not work and today it has gone wrong!!! We are now getting a “Cannot open the mailbox, information store not available” we cannot get the server to work with email and...

Answer Question   |  November 11, 2013  2:12 PM
Exchange 2007, Outlook 2000, Server 2000, SQL Server 2000
asked by:
60 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.

How to find a specific word in a SQL table
How do you write a SQL query to find a specific word in a SQL column. Example: I want to show all records that have the word Bob in it but do not want to include records that are Bobby or Bobble etc., only the exact word Bob. Hope that makes sense.

Answer Question   |  October 25, 2013  3:13 AM
SELECT statement, SQL, SQL Query, WHERE statement
asked by:
5 pts.

SQL Server trigger, insert result of multiple where clause into a variable
Hi All, I have a select statement that stores the result in a variable,this works fine if there is only one condition and field in the clause.How do I go about it if there is more than one? For example (Working one) SELECT @Variable = (SELECT [Field] FROM [Table] WHERE [FIELD] = Value) But I...

Answer Question   |  October 23, 2013  8:23 AM
SELECT statement, SQL, SQL variables, Triggers
asked by:
20 pts.

Calling a stored procedure in a SELECT list on SQL Server 2000
I am using SQL Server 2000, and my question is: is there any way to call a stored procedure in a SELECT list?

Answer Question   |  October 21, 2013  8:16 PM
SELECT statement, SQL Server 2000, SQL stored procedures, Stored Procedures
2,585 pts.

SQL Server Job Example using sp_start_job
I need to use sp_start_job to schedule two jobs in SQL Server: the second job may run only if the first succeeds. Can you give me an example of a job running this store procedure to do this? Is there another method to do this in SQL Server? Thanks in advance!

Answer Question   |  October 21, 2013  6:44 PM
sp_start_job, SQL Server
asked by:
25 pts.

Database Creation
Recieving an error for database creation permission for sql 2005. Please advise

Answer Question   |  October 18, 2013  3:35 PM
SQL Database, SQL Server 2005
asked by:
5 pts.

Read Excel from Sql Server 2005/2008 SQLEXPRESS
How to read the excel data’s from Sql Server 2005/2008 SQLEXPRESS

Answer Question   |  October 16, 2013  11:30 AM
SQL Express, SQL Server 2005, SQL Server 2008, SQLEXPR
asked by:
50 pts.

Update Data SQL Server From AS400
Hi, some help me. I want to write data to SQL Server from AS400 in RPGLE. Some have code for make this. Thanks for advance.

Answer Question   |  October 16, 2013  5:16 PM
AS/400 SQL, RPGLE, SQL Database, SQL Server
asked by:
JLH
5 pts.

How do I convert SQL Server 2012 files to SQL Azure?
Currently, I’m running SQL Server 2012 with Visual Studio Beta 11 as well as SQL Server 2008 R2 version of the .mdf file because the staging server uses R2. I’ll be moving up to SQL Azure for a project I’m working on. What is the best way to port files over? Do I actually need...

Answer Question   |  October 15, 2013  1:51 PM
SQL Azure, SQL Server 2008 R2, SQL Server 2012
asked by:
56,535 pts.

Create a database in SQL Server 2005
Create a database in sql server 2005 but database name passed as parameter into a stored procedure

Answer Question   |  October 14, 2013  7:05 AM
SQL Database, SQL Server, SQL Server 2005, SQL Server database, SQL stored procedures
asked by:
Let
5 pts.

Who is using a database in SQL Server 2008?
I’ve never seen this problem before. I went to change the name of a database in SQL Server 2008, but got hit with an error message saying that the db has to be exclusively locked to do this. So obviously someone else is using the database, but I don’t know who. We have a rather...

Answer Question   |  October 7, 2013  12:19 PM
SQL Database Concurrent Users, SQL Server 2008
asked by:
56,535 pts.

Restore SQL Server 2000
Our server crashed, I installed SQL 2000 on another server and would like to restore the databases from a backup copy. Please help.

Answer Question   |  September 23, 2013  3:17 AM
Restore Database, SQL Server (32-bit), SQL Server 2000
asked by:
5 pts.

Dynamic vs. Stored Procedure table inserts
I just finished making some code changes to get around a problem. I changed my code from doing a dynamic insert to using a stored procedure. Originally it was 20 lines of code for the dynamic process. Doing it the stored procedure way, by the time you defined all the parms it was 107 lines of vb code...

Answer Question   |  September 20, 2013  1:47 PM
SQL 2000, SQL Server, VB .NET
asked by:
6,360 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: