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
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
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
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
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
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
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
How do I use SQL 2005 after installation?
Answer Question
| January 30, 2013 1:38 PM
SQL Server 2005, SQL Server installation
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
How can I get the AdventureWorks database for SQL Server 2005 SP1??
Answer Question
| December 14, 2012 9:35 AM
AdventureWorks, SQL Server 2005
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
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
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
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
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++
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++
Installing a named instance using another edition’s installer.
I have a SQL Server 2005 standard edition installed with a default instance. I need to install an additional named instance. However I could not find the standard edition installer CD; and my colleague managed to dig out a copy of the Express edition installer. Can i use the Express edition installer to install a [...]
Answer Question
| May 3, 2012 6:07 AM
SQL Server 2005, SQL Server editions, SQL Server installation
I have a SQL Server 2005 standard edition installed with a default instance. I need to install an additional named instance. However I could not find the standard edition installer CD; and my colleague managed to dig out a copy of the Express edition installer. Can i use the Express edition installer to install a [...]
Answer Question
| May 3, 2012 6:07 AM
SQL Server 2005, SQL Server editions, SQL Server installation
How to Upload Image into SQL Server 2005
Please i need help to upload images into sql server 2005 using vb.net 2008. kindly assist please as i am working on an application that would require users to upload their credentials.
Answer Question
| April 11, 2012 6:40 AM
SQL Server 2005, VB.NET 2008
Please i need help to upload images into sql server 2005 using vb.net 2008. kindly assist please as i am working on an application that would require users to upload their credentials.
Answer Question
| April 11, 2012 6:40 AM
SQL Server 2005, VB.NET 2008
Creating clustered index on exiting table
I have a SQL Server 2005 Enterprise Edition database table that has 768,526 rows in it with no primary key or clustered index. This database’s logs are getting shipped to a disaster recovery server on an hourly basis. I need to create a clustered primary key constraint on this table; however when testing in my [...]
Answer Question
| April 17, 2012 1:55 PM
SQL Server 2005, SQL Server Indexes
I have a SQL Server 2005 Enterprise Edition database table that has 768,526 rows in it with no primary key or clustered index. This database’s logs are getting shipped to a disaster recovery server on an hourly basis. I need to create a clustered primary key constraint on this table; however when testing in my [...]
Answer Question
| April 17, 2012 1:55 PM
SQL Server 2005, SQL Server Indexes
update the tables in to two server using a single ssis package
i have 2 servers server A and Server B.i have written a package in server A.i want to update the tables in both server A and B.when i execute the package from BIDS it is working fine when i schedule the package in agent job i am getting the below error. Executed as user: RICRDWDEVSYSTEM. …ckage [...]
Answer Question
| April 5, 2012 10:04 AM
SQL Server 2005, SSIS Package 2005
i have 2 servers server A and Server B.i have written a package in server A.i want to update the tables in both server A and B.when i execute the package from BIDS it is working fine when i schedule the package in agent job i am getting the below error. Executed as user: RICRDWDEVSYSTEM. …ckage [...]
Answer Question
| April 5, 2012 10:04 AM
SQL Server 2005, SSIS Package 2005
How to connect my computer to SQL server 2005
I need your kind support in connecting my computer to SQL server 2005? I am a bignner and I will be thankful if you explain it step by step? What should I write in the code to recognize my database? Thank you and regards..
Answer Question
| May 16, 2012 10:43 AM
SQL Server, SQL Server 2005
I need your kind support in connecting my computer to SQL server 2005? I am a bignner and I will be thankful if you explain it step by step? What should I write in the code to recognize my database? Thank you and regards..
Answer Question
| May 16, 2012 10:43 AM
SQL Server, SQL Server 2005
Calling stored procedure in a database to query data in another database
Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData ‘some_remote_db_name’; and [...]
Answer Question
| February 27, 2012 10:25 AM
SQL Database, SQL Server 2005
Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData ‘some_remote_db_name’; and [...]
Answer Question
| February 27, 2012 10:25 AM
SQL Database, SQL Server 2005
Load balance of SQL database
When my database has grown beyond the performance capabilities of a single SQL Server, what are the ways get increase the system performance?
Answer Question
| May 2, 2012 10:18 AM
SQL Server 2005, SQL Server database
When my database has grown beyond the performance capabilities of a single SQL Server, what are the ways get increase the system performance?
Answer Question
| May 2, 2012 10:18 AM
SQL Server 2005, SQL Server database
Connecting SQL server 2005 with IAN connection
how we can connect sql server2005 with lan area? what are all the settings and options want to change?
Answer Question
| February 28, 2012 11:51 AM
SQL Server 2005, SQL Server career advice
how we can connect sql server2005 with lan area? what are all the settings and options want to change?
Answer Question
| February 28, 2012 11:51 AM
SQL Server 2005, SQL Server career advice
Store and retrieve data in UTF-8 on SQL Server 2005
(Apologies:I put this question under Windows Server 2003 tag by mistake, so I copied and pasted it here where it should be) I am trying to store and retrieve data in UTF-8 on SQL Server 2005 and having problems. I manually type Greek (just for example) into the database and when I open the table [...]
Answer Question
| April 8, 2012 11:11 AM
SQL Server 2005, UTF-8
(Apologies:I put this question under Windows Server 2003 tag by mistake, so I copied and pasted it here where it should be) I am trying to store and retrieve data in UTF-8 on SQL Server 2005 and having problems. I manually type Greek (just for example) into the database and when I open the table [...]
Answer Question
| April 8, 2012 11:11 AM
SQL Server 2005, UTF-8
Store and retrieve data from SQL Server 2005 in UTF-8
I am trying to store and retrieve data in UTF-8 on SQL Server 2005 and having problems. I manually type Greek (just for example) into the database and when I open the table SQL makes it into question marks ???. What should I do to be able to store and read UTF-8 data? My columns [...]
Answer Question
| February 28, 2012 10:42 AM
SQL Server 2005
I am trying to store and retrieve data in UTF-8 on SQL Server 2005 and having problems. I manually type Greek (just for example) into the database and when I open the table SQL makes it into question marks ???. What should I do to be able to store and read UTF-8 data? My columns [...]
Answer Question
| February 28, 2012 10:42 AM
SQL Server 2005
sql server 2005 do not show Add new administrator in Surface area Configuration
Hi all I haved a problem with the installation of SQL Server 2005 SP3 in a WIn xp OS. I proceed to install the free application but when i try to check the permisions to create a DB i went to Configuration tools > SQL Server Surface area Configuration, but the screen did not [...]
Answer Question
| December 8, 2011 8:37 PM
SQL Server 2005
Hi all I haved a problem with the installation of SQL Server 2005 SP3 in a WIn xp OS. I proceed to install the free application but when i try to check the permisions to create a DB i went to Configuration tools > SQL Server Surface area Configuration, but the screen did not [...]
Answer Question
| December 8, 2011 8:37 PM
SQL Server 2005
MVC Architecure and ASP.net programming
Are Action Filters, model binding & validation new features in MVC?
Answer Question
| October 19, 2011 1:54 PM
ASP.NET Web applications, MVC, SQL Server 2005
Are Action Filters, model binding & validation new features in MVC?
Answer Question
| October 19, 2011 1:54 PM
ASP.NET Web applications, MVC, SQL Server 2005
