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
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
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
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
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
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??
Answer Question | July 8, 2008 5:55 PM
Software maintenance, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB, Visual Basic 6
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
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
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
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
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
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
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
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
what are the diferent versions of sql server
Answer Question | September 26, 2009 5:22 AM
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
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
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
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