Hi all, I am running into a little bit of a problem. I need to insert records with a stored procedure into a table based on the information selected. From the info selected, it decides what table to insert it into. Example: Select top 1 SerialNo from dbo.Serial –returns ‘ASEEADL1234567′ based on the 8th letter [...]
Answer Question | March 31, 2012 8:36 PM
INSERT SELECT statement, SQL Records, SQL Server, SQL Server administration, Stored Procedures
I am working on a SQL 2005 data base, the supplirer is telling me that the reason I am unable to find the SQL Data Base when i run there Client install software through a VPN connection is that the Name Pipes are keeping the Data base from being accessed. Can anyone herlp me with this issue [...]
Answer Question | March 31, 2012 12:41 AM
SQL 2005, SQL Express, SQL Server, SQL Server administration, SQL Server security
How do you get notified when Microsoft is doing a SQL Server Patch? Is there a way to be alerted before they do a patch?
Answer Question | June 27, 2011 1:56 PM
SQL Server, SQL Server administration, SQL Server alerts
how i create refrence key of non-unique column in sql server 2008?
Answer Question | May 2, 2011 11:39 AM
SQL Column Headings, SQL Server, SQL Server 2008, SQL Server administration
Hi, We do a simple select 1 million record over a client server setup with SQL server 2008 and it take 10 times more time to get the results that doing the same request with Microsoft access db. Exactly the same setup for the network. Any special setup in SQL server we are missing. thank [...]
Answer Question | April 5, 2011 5:46 PM
Java, SQL Server 2008, SQL Server administration, SQL Server installation, SQL Server performance
I am having a little trouble combining the following 2 queries into a single nested statement (if indeed it’s possible). Can anyone assist? Query 1: SELECT Eff_Date, CoNum, Brandname, COUNT(Brandname) AS CountOfBrandName FROM dbo.Products WHERE (Eff_Date BETWEEN ’1/1/2010′ AND ’12/31/2010′) GROUP BY Eff_Date, CoNum, Brandname, DateApplied Query 2: SELECT Eff_Date, CoNum, SUM(CountOfBrandName) AS SUMofBrandNames FROM [...]
Answer Question | March 4, 2011 3:34 PM
SQL 2008, SQL Server 2008, SQL Server administration, SQL Server Query, T-SQL 2008
I just inherited a SQL SERVER 2005 32-bit attached to a SAN Server. I want to use SQLIO for performance testing and stress testing. The database is in production. Would it be a good idea to run SQLIO on a production sql server during non-work hours?
Answer Question | December 20, 2010 10:11 PM
iSCSI SAN Server, SQL 2005, SQL Server 2005, SQL Server administration, Windows Server 2003
Yes I am consultant for a small business, and currently they have a Access database that works pretty decently. At the current situation, the owner needs another database. I really do not want to have to ask the developer to keep creating different databases that includes him having to put more separate tables on the [...]
Answer Question | December 16, 2010 4:02 PM
Access Tables, SQL Server administration, SQL Server Table Migration, SQL Server tables, SQL tables
I am going to use the sql code below in a query in delphy7 SELECT left(edit1.text, 5)+’0 ‘ FROM edit.text2
Answer Question | December 13, 2010 10:26 AM
SQL 2000, SQL Server 2000, SQL Server 2000 administration, SQL Server administration
we have SQL 2008, and looking for tools to monitor sql and get sql diagrams. do you know any good tools?
Answer Question | December 16, 2010 10:51 PM
Network Monitoring Tools, Network security, SQL 2008, SQL Server 2008, SQL Server administration
Books Online tells me … make sure you have administrator permissions on the computer where SQL Server will be installed. Based on the principle of using the lowest possible user rights is it possible to safely install SQL Server 2005 using an account or group that has the required level of privileges but no more. [...]
Answer Question | December 2, 2010 5:07 PM
Local Administrators Account, SQL Server 2005, SQL Server administration, SQL Server installation, Windows Server 2003
I have upgraded SQL Server Express 2005 to Standard 2005. Every thing is updated and all Services are well running, But not able to login because I have got only Configuration Tools in Menu- Start->Programs->MSS 2005->Configuration Tools. and if I try through Run SQLWB,it’s shows not avalable. Kindly help how can I will get all [...]
Answer Question | November 1, 2010 6:18 AM
SQL Server, SQL Server 2005 Standard Edition, SQL Server administration, SQL Server Express 2005, SQL Server Upgradation, SQL Server upgrades
We need to roll back a copy of our database 5 hours. We are running sql 2005 on a windows 2003 server. How can we do this? We do not want to effect production data but want to report against the 5 hour old data.
Answer Question | October 23, 2010 5:33 PM
SQL Server 2005, SQL Server administration, SQL Server Database Rollback, SQL Server Rollback
What are the benefits or disadvantages of hosting a SQL server on site or using a MYSQL server in the cloud? The MYSQL box is much cheaper is there anything I will not be able to do with my web app using MYSQL?
Answer Question | November 3, 2010 8:14 PM
Cloud Computing, Cloud Computing in 2010, Cloud Services, MySQL, SQL, SQL Server, SQL Server administration
Is it acceptable to run SQL 2005 and SQL 2008 side-by-side on the same MS cluster (single-instance) cluster in production? At least temporarily until all SQL 2005 DB appl vendors are approved on SQL 2008. I know there were issues and recommendations to Not do this with SQL 2000 and 2005 because they were so [...]
Answer Question | August 18, 2010 2:46 PM
Cluster management, Clustered servers, SQL Server (64-bit), SQL Server 2005, SQL Server 2008, SQL Server 2008 64-bit, SQL Server administration, SQL Server clustering
HOW TO ROLL BACK SERVICE PACK IN SQL SERVER 2005
Answer Question | August 12, 2010 6:24 AM
SQL Server, SQL Server 2005, SQL Server administration, SQL Server Service Packs
I need to install a new SQL server and we are buying a 64-bit OS. What’s the maximum amount of memory that the operating system can hold/support/make use of?
Answer Question | July 13, 2010 6:01 PM
64-bit (x64), Capacity planning, Memory management, Operating systems, SQL Server administration, SQL Server memory
Hi, We have a server in which windows 2003 is installed and we have created users in the domain (eg – aaa). The server is installed with sql server 2000 and data is stored in the database. The user name for the server is administrator. The problem is when we login from the user computer [...]
Answer Question | February 2, 2010 5:19 AM
SQL Server 2000, SQL Server administration, Windows Server 2003
Can someone please explain me the internals of SQL Server replication. I need to know what happens when a new data is inserted, which all views and triggers get initiated and how the whole process works. Thanks.
Answer Question | November 10, 2009 5:19 AM
SQL Server administration, SQL Server replication
I’m struggling with when is the right time to do my last transactional log backup before my full database backup. My question is this: if I do a full db backup once a day at 10pm; and a tran log backup every 4 hours (12pm, 4am, 8am, 12am, 4pm, 8pm). If i have to restore the [...]
Answer Question | October 27, 2009 2:53 PM
Database backup and recovery, SQL Server 2005, SQL Server administration