installing SQL server enterprise edition on XP
how can I install SQL server enterprise edition on windows XP? I know there is a way but I dont know it if some body know it tell me plz

Answer Question   |  June 9, 2008  10:30 AM
SQL Server Enterprise Edition, SQL Server installation, Windows XP

Need to upgrade sql server
Hi right now my database server running on sql server 2000 & my application is also running from the same server for heavy load on server i m going to seperate my database server & application server i need a help bocz my database size is all most 3 GB. also i need to upgrade [...]

Answer Question   |  June 9, 2008  7:44 AM
SQL Server 2000, SQL Server 2005, SQL Server upgrades

SQL 2005 Transaction Logs
I am by no means very good at SQL. I know the basics. I am a network engineer but was recently asked to do a few tasks in a SQL 2005 environment. I currently have a database that is residing off-site and I was asked to import the database and transaction logs so that this [...]

Answer Question   |  June 10, 2008  4:17 AM
SQL Server 2005, SQL Server administration, SQL Server transaction logs

Don’t run the SQL Server Account as Local Administrator or member of the Administrator Group?
Based on the advice “Don’t run the SQL Server Account as Local Administrator or member of the Administrator Group” Will this setup prevented you from using critical features? How did you get around this? The link below makes reference as to how a critical feature “Automatic Server Restart Feature” is affected if SQL Server Account [...]

Answer Question   |  June 9, 2008  1:09 AM
SQL Server, SQL Server administration, SQL Server security

Insert records between records in a file using RPG code.
Is there a way to insert a record in between records in a file? For example, a file contains 10 records (1 to 10). I want to insert a record in between records 1 and 2, thus record 2 will move to position 3, 3 to 4, and so on and so forth. Can SQL/Insert [...]

Answer Question   |  June 10, 2008  5:00 PM
RPG, RPG ILE, SQL scripts

Looking for best way to have SQL Server data security, replication as well as security maintenance
I joined a production environment recently, and I’m the key person here. We have 2 servers: one production server and a replication server. Data from the application goes to the production server every second and that is replicated to the replication server. We fetch the data from replication server. There is no failover clustering or [...]

Answer Question   |  June 7, 2008  7:21 PM
Database security, SQL Server replication, SQL Server security

SQL SERVER 2005-MAX FUNCTION
I have a stored proc1 which returns a list of dates for one particular job number.I execute this proc in an other proc2 ,to get the list of all dates. Then in my proc2 we can get the MAX of this list of dates. In the WHERE clause of my SELECT statement, i need to [...]

Answer Question   |  June 8, 2008  6:18 PM
MAX, SQL Server, SQL Server 2005

Linked Servers????
Hi everybody, I’m an IT student and i’m doing professional practices. A simple project was assigned to me. This company uses SMS to collect information of all his PC’s and stores this information in a MSSQL database. A manager checks this information and fills another database located in another server. For example, in the SMS [...]

Answer Question   |  July 4, 2008  3:51 PM
Database, Enterprise Manager, Linked servers, SQL, Windows Server, Windows Server 2003

how to upgrade server to SQL 2005
I have a system with MS SQL Server 2005 installed and am running the MS SQL Server Management Studio Express but when I query the database version it comes back as SQL 2000 – 8.00.194. How do it change to using SQL 2005?

Answer Question   |  June 6, 2008  11:08 PM
SQL Server 2005, SQL Server Express Edition, SQL Server Management Studio, SQL Server upgrades

how to update a row in grid view in vb.net
how to update a row in grid view in vb.net using sql server as back end

Answer Question   |  June 5, 2008  7:28 PM
ADO.NET, SQL Server 2000, VB.NET 2005

Restoring SQL Server 2000 database
I want to restore a database in SQL Server 2000, using a specific name. I tried restoring it using Enterprise Manager, but kept getting the error ‘You must select a backup set to restore’. Why is this and how do I resolve it?

Answer Question   |  June 5, 2008  10:09 AM
SQL Server 2000, SQL Server backup, SQL Server Enterprise Manager, SQL Server errors

sql scripts
Hi all, i’m updating a new ‘commun management’ software n i wanna update the database bcoz i added many extra tables. i did write scripts for all the tables this way: Create……….. Drop……….. Alter…….. so our clients would be able to have access to it. but i have been asked to write other ways script [...]

Answer Question   |  June 5, 2008  9:12 AM
Scripts, SQL, SQL scripts

Need help executing MULTIPLE SQL extracts from a JCL
GREYBEARD52: Thanks again for the info, BUT I’m not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won’t help – it doesn’t support SELECT. Are there ANY OTHER ALTERNATIVES or a way to tweek this command [...]

Answer Question   |  January 27, 2010  6:57 PM
DB2, JCL, SELECT statement, SQL

Problem converting Access SQL query to T-SQL 2005
I have a SQL Server 2005 database. One of my co-workers has put a MS Access front-end on it, because of the ease of designing queries in Access. I need to convert an existing query from Access SQL to T-SQL to put it into production. So far, I have removed all the obvious differences between [...]

Answer Question   |  June 4, 2008  3:41 PM
Microsoft Access, SQL, SQL Server 2005, T-SQL

sql instance
what is a sql server instance for? thanks.

Answer Question   |  June 3, 2008  2:56 AM
SQL, SQL instance

Linking Microsoft CRM to MSSQL Server
We are currently setting up a email newsletter system for one of our client and are looking at linking to and fro their CRM, for example, we need to link our newsletters (stored in MSSQL) to their list of contact emails (Stored in CRM) and write information related to the newsletter usage back to CRM. [...]

Answer Question   |  June 3, 2008  2:07 PM
Microsoft CRM, SQL Server 2000

Veritas vs. SQL Server 2005
Why will SQL Server not accept files restored from Veritas backups?

Answer Question   |  June 2, 2008  1:56 PM
Backup, SQL, SQL Server 2005, Veritas, Veritas Backup Exec

Planning to move data on new databse server?
Well i m working in MNC As a Network admin actually we have one server having data & application so both our application and database on same server & now we are facing some problem on it so we plan to seperate database server & application if any body has a plan or he/she know [...]

Answer Question   |  June 1, 2008  10:03 AM
Application Server, Database servers, SQL Server 2000

Call Stored Procedure Multiple times
I want to use a SQL script that takes values from one table and then calls a stored procedure multiple times for each of those values. Each time, I am passing in those values as a parameter for each stored procedure call. How can I do that?

Answer Question   |  August 31, 2010  6:48 PM
SQL Server, Stored Procedures

iSeries DB2 SQL subquery to compare yesterday sales to 120 day ternd
Hi, I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here’s the ” Hard coded version (Works) SELECT SLSBIGD.R1SSID,SLSBIGD.prdistynm,SLSBIGD.prdiclrd,SLSBIGD.prdiclrnm, sum(SLSBIGD.MNET$) [...]

Answer Question   |  May 30, 2008  2:31 PM
Date format, Date variable, DB2/400, SQL Query, SQL Subselect