Create a sequence called Store_seq with the following values: increment by 10, start with 500
Create a sequence called Store_seq with the following values: increment by 10, start with 500

Answer Question   |  July 8, 2008  6:34 AM
SQL Query, SQL sequences

SQL: Using a column created in the SELECT in the WHERE CLAUSE
Can I use a column in the WHERE clause that I created with ‘AS’ in the WHERE clause. I have tried and SQL tells me that the column is not in the table? Thanks, Ray

Answer Question   |  July 9, 2008  7:26 PM
SELECT statement, SQL, SQL statements

Excluding Data Usin NOT IN
I’m trying to export data from a sql table into sql reporter. The information I’m trying to retrieve is information regarding permissions (this is audit stuff). The problem is, there are spaces (and always a different amount of spaces) between the user and the permissions; for example: Type Account Permissions —– —————————- ————– Allow CREATOR [...]

Answer Question   |  July 8, 2008  1:10 PM
SQL Server permissions, SQL Server reporting, SQL statements

installation of sql server 2005 in vmware
I am trying to install sql server 2005 in vmware with scripts but failed. Script is running successfully, but nothing is shown in sql server configuratin manager.

Answer Question   |  May 25, 2011  9:42 AM
SQL Server 2005, SQL Server Configuration Manager, VMware

MSSQL$BKUPEXEC Service won’t start.
Hi All! I have a problem with this MSSQL$BKUPEXEC service after a power failure on my SBS Server Premium Edition, this service and along with these below are also not starting as they’re meant to be; Backup Exec Device & Media Service Backup Exec Job Engine Backup Exec Server BlackBerry Dispatcher BlackBerry Policy Service BlackBerry [...]

Answer Question   |  July 11, 2008  12:47 AM
MSSQL$BKUPEXEC, SBS, SQL Server, SQL Server backup

unable to attach sample database in SQL 2005
Hi, I installed SQL server 2000 and SQL 2000 SP4. Than I installed SQL Server 2005. But when I am trying to attach the AdventureWorks Sample database, I am getting the following error: TITLE: Microsoft SQL Server Management Studio —————————— An error occurred when attaching the database(s). Click the hyperlink in the Message column for [...]

Answer Question   |  July 7, 2008  9:51 PM
Microsoft SQL Server Management Studio, Microsoft.SqlServer.Smo, SQL Server 2005

i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??
i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??

Answer Question   |  July 8, 2008  5:55 PM
Software maintenance, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB, Visual Basic 6

must Access be installed to use Analysis Server
Working with Analysis Manager Version: 8.00.194, my Sales cube looks good until I try to browse the data that comes from Foodmart 2000.mdb. Is this because Access is required?

Answer Question   |  September 20, 2008  5:10 PM
Analysis Manager, Database, Microsoft Access, SQL Server

cube data fails to display
Working through the Foodmart 2000 sample sales cube in SQL Analysis Manager, all goes smoothly but at the end data does not display. The error message is “unspecified error”, unable to browse the cube. This is the Sales cube created with the Quickstart example on Foodmart 2000.mdb.

Answer Question   |  July 7, 2008  5:07 PM
SQL Analysis Manager

Assigning access to SQL Server Integration Services (SSIS) packages
How do we assign access for users to SQL Server Integration Services (SSIS) packages?

Answer Question   |  July 4, 2008  6:19 PM
SQL Server, SSIS, User access

Allowing SQL Server 2000 Enterprise Edition to utilize free physical memory
I have two identical SQL Server 2000 Enterprise Editions running on Windows 2003 Enterprise servers. They both have 8GB of RAM with /PAW and /3GB switches configured. The max server memory is set to 7GB on both. On one of the servers, the available physical memory under Task Manager Is always showing 3GB free, yet [...]

Answer Question   |  July 4, 2008  6:16 PM
Memory, SQL Server 2000, SQL Server performance

Slowdown on a server running SQL Server 2000 and Windows Server 2003
I have a server with SQL Server 2000 SP4 and Windows Server 2003 Standard Edition SP1 that runs SAP Business One. The server’s specs are: ML350G5 XEON 2.0DC 4GB RAM 6 UNITS SAS 72GB C:=>Raid 1+0, D:=>DATA Files, E:LOG files, F:TempDB files Swith Hub: 3COM 2924 SFP plus 3COM 4210 Cable: CAT5E I have two [...]

Answer Question   |  July 4, 2008  6:13 PM
SAP Business One, SQL Server 2000, SQL Server performance, Windows Server 2003

Using a .bak file with SQL Server 7
I currently use SQL Server 7, and I have a .bak file downloaded. Can you direct me on how to open this .bak file and how to convert it to allow usage with SQL Server 7?

Answer Question   |  July 4, 2008  6:11 PM
BAK, SQL Server 7.x

How SQL Server will work with PerformancePoint Server 2007
Can you explain the basic architecture and operation of PerformancePoint Server 2007, and how it might work with SQL Server?

Answer Question   |  July 3, 2008  6:10 PM
PerformancePoint Server 2007, Servers, SQL Server

SQL Server 2005 within MS Access VBA
I have am MS Access (VBA) program where I need to create a table on a SQL Server database then append data to the table. I have the code that generates the update query but I need the ADO code that creates the connection to the SQL Server 2005 database then I need the code [...]

Answer Question   |  July 3, 2008  3:44 PM
Microsoft Access, SQL Database, SQL Server 2005

sql server
what are the diferent versions of sql server

Answer Question   |  September 26, 2009  5:22 AM
SQL Server

Looking for a database name query in SQL
Is there a query in SQL that could return me the name of a database, or whether it is connected to SQL Server or Oracle?

Answer Question   |  July 4, 2008  5:49 PM
Database, Query, SQL, SQL Query, SQL Server

Including a primary key in a nonclustered index in SQL Server 2005
The query optimizer for SQL Server 2005 is suggesting that we include a primary key as part of a nonclustered index. Is it OK to include that to increase SQL performance?

Answer Question   |  July 2, 2008  5:36 PM
Index, Primary keys, SQL performance, SQL Server 2005

Setting database security to prevent restoring databases on other SQL Servers
Within a database in my SQL Server, I am able to control users from Alter Table and Alter SP, and a strong ‘sa’ password is also created. When I login to the backup of that database with a backup operator ID, the backup operator is able to restore the database, and his and others’ rights [...]

Answer Question   |  July 3, 2008  5:21 PM
Database backup and recovery, Database security, Security, SQL Database, SQL Server

Backing up and restoring a LIVE database in SQL Server 2000
I am using SQL Server 2000, and I backup and restore my LIVE database to a new backup server every night. Do you have any ideas as to why my restored database runs slow when compared to the LIVE database? Do I need to rebuilding indexes? Is there any way of backing up indexes as [...]

Answer Question   |  July 4, 2008  3:52 PM
Database backup and recovery, Indexes, LIVE database, SQL Server 2000