Create a database in SQL Server 2005
Create a database in sql server 2005 but database name passed as parameter into a stored procedure
Answer Question
| March 7, 2011 7:05 AM
SQL Database, SQL Server, SQL Server 2005, SQL Server database, SQL stored procedures
Create a database in sql server 2005 but database name passed as parameter into a stored procedure
Answer Question
| March 7, 2011 7:05 AM
SQL Database, SQL Server, SQL Server 2005, SQL Server database, SQL stored procedures
SQL Server 2005 database conversion
HI, we plan to migrate SQL server 2005 from SQL server 2000. we have database with average size of 12GB. can any one please let me know how to convert our database from SQL2000 to SQL2005.Thanks in advance.
Answer Question
| March 2, 2011 11:34 AM
SQL database conversion, SQL Server 2000, SQL Server 2005, SQL Server 2005 migration, SQL Server migration
HI, we plan to migrate SQL server 2005 from SQL server 2000. we have database with average size of 12GB. can any one please let me know how to convert our database from SQL2000 to SQL2005.Thanks in advance.
Answer Question
| March 2, 2011 11:34 AM
SQL database conversion, SQL Server 2000, SQL Server 2005, SQL Server 2005 migration, SQL Server migration
How to check browser activity?
Hi, i’m working a project ,In that i’m storing login,logout time,wht if i don’t click logout button and close my browser,or somehow my system shutdown.i cannot store the logout time,so that my program will be in error state.. tell me how to get the logout time when my programmer didn’t click logout button and close [...]
Answer Question
| February 25, 2011 2:38 AM
ASP, C# .NET, SQL Server 2005
Hi, i’m working a project ,In that i’m storing login,logout time,wht if i don’t click logout button and close my browser,or somehow my system shutdown.i cannot store the logout time,so that my program will be in error state.. tell me how to get the logout time when my programmer didn’t click logout button and close [...]
Answer Question
| February 25, 2011 2:38 AM
ASP, C# .NET, SQL Server 2005
Looping in SQL
dear, i have one table with more than (16000) rows. now i should add on column with “computed column” as a result for other columns, so i already create the new column with correct statment but how can i make this statment excute for all pervious rows. to be exact: the new column should contain [...]
Answer Question
| February 23, 2011 7:18 AM
.NET Framework 3.5, Looping, SQL Server, SQL Server 2005
dear, i have one table with more than (16000) rows. now i should add on column with “computed column” as a result for other columns, so i already create the new column with correct statment but how can i make this statment excute for all pervious rows. to be exact: the new column should contain [...]
Answer Question
| February 23, 2011 7:18 AM
.NET Framework 3.5, Looping, SQL Server, SQL Server 2005
SQL reporting
I am using sql server 2005. I have a report with 2 columns.one for report name and the other for status.I want that when a user clicks on a report’s status column,the corresponding report should be opened. i am using the following code in the navigation tab–>jump to report. =Iif(Fields!SUB_REPORT.Value=”GFM_FX_EXPOSURE$”,”www.google.co.in”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_EXP$”,”GFM_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_MV$”,”GFM_INST_TYPE_MV”, Iif(Fields!SUB_REPORT.Value=”GSS_FX_EXPOSURE$”,”GSS_FX_EXPOSURE”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_EXP$”,”GSS_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_MV$”,”GSS_INST_TYPE_MV”, [...]
Answer Question
| February 22, 2011 8:07 AM
SQL Reports, SQL Server 2005, SQL Server reporting, Visual Studio 2005
I am using sql server 2005. I have a report with 2 columns.one for report name and the other for status.I want that when a user clicks on a report’s status column,the corresponding report should be opened. i am using the following code in the navigation tab–>jump to report. =Iif(Fields!SUB_REPORT.Value=”GFM_FX_EXPOSURE$”,”www.google.co.in”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_EXP$”,”GFM_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_MV$”,”GFM_INST_TYPE_MV”, Iif(Fields!SUB_REPORT.Value=”GSS_FX_EXPOSURE$”,”GSS_FX_EXPOSURE”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_EXP$”,”GSS_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_MV$”,”GSS_INST_TYPE_MV”, [...]
Answer Question
| February 22, 2011 8:07 AM
SQL Reports, SQL Server 2005, SQL Server reporting, Visual Studio 2005
SQL Server 2005 Reporting Services Move
I am trying to move an entire report server to a different server. When I move the databases and config files all of my shared data sources do not have a connection string and credentials in them. How can I move SSRS data sources with connections strings and credentials to another server?
Answer Question
| February 11, 2011 9:12 PM
Report Server, Reporting Services 2005, SQL Server 2005, SQL Server migration, SQL Server Report Server
I am trying to move an entire report server to a different server. When I move the databases and config files all of my shared data sources do not have a connection string and credentials in them. How can I move SSRS data sources with connections strings and credentials to another server?
Answer Question
| February 11, 2011 9:12 PM
Report Server, Reporting Services 2005, SQL Server 2005, SQL Server migration, SQL Server Report Server
SQL 2005 Database instance
Hi there i have a windows 2003 domain in our school, i have a problem with my sql 2005 database. im trying to uninstall a instance from the database engine. it wont uninstall. i believe that this is corrupt. im trying to reinstall sophos but as the old database will not uninstall sophos wont reinstall. [...]
Answer Question
| April 12, 2011 12:13 PM
Database Instances, SQL 2005, SQL Server 2005, SQL Server 2005 Database, Windows Server 2003 Domain, Windows Server 2003 SP2
Hi there i have a windows 2003 domain in our school, i have a problem with my sql 2005 database. im trying to uninstall a instance from the database engine. it wont uninstall. i believe that this is corrupt. im trying to reinstall sophos but as the old database will not uninstall sophos wont reinstall. [...]
Answer Question
| April 12, 2011 12:13 PM
Database Instances, SQL 2005, SQL Server 2005, SQL Server 2005 Database, Windows Server 2003 Domain, Windows Server 2003 SP2
Search: Error with SQL : Login failed for ‘SA’.
I’m using a softawre written in VB(.net). It runs normal on XP and 2003 server. it supports both Access and SQL 2000 and 2005. but I recently upgraded my OS to Win7+SQL 2008, and I’ve been having the following error anytime a call for a screen in the software”Search: Error with SQL : Login failed [...]
Answer Question
| June 28, 2011 11:53 PM
SQL Server 2000, SQL Server 2005, VB.NET, Visual Basic, Windows Server 2003
I’m using a softawre written in VB(.net). It runs normal on XP and 2003 server. it supports both Access and SQL 2000 and 2005. but I recently upgraded my OS to Win7+SQL 2008, and I’ve been having the following error anytime a call for a screen in the software”Search: Error with SQL : Login failed [...]
Answer Question
| June 28, 2011 11:53 PM
SQL Server 2000, SQL Server 2005, VB.NET, Visual Basic, Windows Server 2003
SQL Server 2005 database installation
i installed sql2005 s/w in my system.but i don’t know how to use it.i don’t know how to create database and manage and all.can u help me?
Answer Question
| February 7, 2011 5:20 AM
SQL 2005, SQL Server 2005, SQL Server 2005 Database, SQL Server database
i installed sql2005 s/w in my system.but i don’t know how to use it.i don’t know how to create database and manage and all.can u help me?
Answer Question
| February 7, 2011 5:20 AM
SQL 2005, SQL Server 2005, SQL Server 2005 Database, SQL Server database
Can I install SQL Server 2005 32 bit on 64 bit OS?
can I install SQL Server 2005 32 bit on 64 bit win 2003 OS?
Answer Question
| February 5, 2011 5:51 AM
SQL 2005 installation, SQL Server 2005, SQL Server 2005 (32-bit), SQL Server installation, SQL Server Installation Options, Windows Operating System, Windows Server 2003
can I install SQL Server 2005 32 bit on 64 bit win 2003 OS?
Answer Question
| February 5, 2011 5:51 AM
SQL 2005 installation, SQL Server 2005, SQL Server 2005 (32-bit), SQL Server installation, SQL Server Installation Options, Windows Operating System, Windows Server 2003
SQL Server 2005 permissions required by public
Our security madates that ALL object permissions be removed from”public”. After doing that, no one can see their tables or do anything. What are the absolutly NEEDED permissions required by public (Execute, Select, etc.)?
Answer Question
| February 15, 2011 6:46 PM
SQL Security, SQL Server 2005, SQL Server 2005 security, SQL Server permissions
Our security madates that ALL object permissions be removed from”public”. After doing that, no one can see their tables or do anything. What are the absolutly NEEDED permissions required by public (Execute, Select, etc.)?
Answer Question
| February 15, 2011 6:46 PM
SQL Security, SQL Server 2005, SQL Server 2005 security, SQL Server permissions
Resolving all losing conflicts-Merge Replication in SQL Server 2005 and 2000
The application I support uses SQL Server 2005 as the publisher and SQL Server 2000 at the subscriber. One of our clients went nuts trying to prune his database and deleted a year and a half of sales data. Unfortunately I did not have a backup, but I did have an old copy of the [...]
Answer Question
| February 2, 2011 5:34 PM
SQL Server 2000, SQL Server 2005, Windows Server 2003 R2, Windows XP
The application I support uses SQL Server 2005 as the publisher and SQL Server 2000 at the subscriber. One of our clients went nuts trying to prune his database and deleted a year and a half of sales data. Unfortunately I did not have a backup, but I did have an old copy of the [...]
Answer Question
| February 2, 2011 5:34 PM
SQL Server 2000, SQL Server 2005, Windows Server 2003 R2, Windows XP
Crystal Reports XI period in database name
SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?
Answer Question
| January 13, 2012 12:12 AM
Crystal Reports, Crystal Reports XI, SQL Server 2005, SQL Server 2005 Database
SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?
Answer Question
| January 13, 2012 12:12 AM
Crystal Reports, Crystal Reports XI, SQL Server 2005, SQL Server 2005 Database
How to concat SQL Server 2005 data with line feed
I am attempting to update a column in SQL Server 2005 by concatenating data from two other columns and include a line feed between the two and have the second line begin with a /. The data will be viewed through an MS Access 2003 database with a linked table using an ODBC connection. The [...]
Answer Question
| February 2, 2011 10:46 PM
Access 2003, Concatenate, Line Feed, SQL 2005, SQL Server 2005, T-SQL
I am attempting to update a column in SQL Server 2005 by concatenating data from two other columns and include a line feed between the two and have the second line begin with a /. The data will be viewed through an MS Access 2003 database with a linked table using an ODBC connection. The [...]
Answer Question
| February 2, 2011 10:46 PM
Access 2003, Concatenate, Line Feed, SQL 2005, SQL Server 2005, T-SQL
Connect Powerbuilder in SQL Server 2005
how to connect the sqlserver 2005 database in power builder
Answer Question
| February 1, 2011 12:36 PM
PowerBuilder, SQL 2005, SQL Server 2005, SQL Server connectivity
how to connect the sqlserver 2005 database in power builder
Answer Question
| February 1, 2011 12:36 PM
PowerBuilder, SQL 2005, SQL Server 2005, SQL Server connectivity
Crystal report asks for parameter at runtime
Hello All, I have a problem with crystal reports at runtime…… I have a desktop application in which I have used crystal report… When I run the application, crystal report asks for parameter even though I have supplied it through code in C#. Not able to figure out why this happens….. My Report also contains [...]
Answer Question
| August 12, 2011 10:22 AM
.NET, C#, Crystal Report, Crystal Reports, Crystal Reports Conditional Parameters, SQL Server 2005
Hello All, I have a problem with crystal reports at runtime…… I have a desktop application in which I have used crystal report… When I run the application, crystal report asks for parameter even though I have supplied it through code in C#. Not able to figure out why this happens….. My Report also contains [...]
Answer Question
| August 12, 2011 10:22 AM
.NET, C#, Crystal Report, Crystal Reports, Crystal Reports Conditional Parameters, SQL Server 2005
Experience applying SP4 to SQL 2005?
Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I would to [...]
Answer Question
| February 7, 2011 5:49 AM
Database Instances, SQL 2005, SQL Server 2005, SQL Server database, SQL Server multiple instances
Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I would to [...]
Answer Question
| February 7, 2011 5:49 AM
Database Instances, SQL 2005, SQL Server 2005, SQL Server database, SQL Server multiple instances
Upgrading for database structure
hello everyone Maybe my previous question was not the correct question to ask. I am in the middle of making an application upgrade which includes DB structure upgrade with keeping Data “data loss is not accepted here”. I have a complex DB structure in my application which depends “in some cases heavily depending” on database specific features. [...]
Answer Question
| January 25, 2011 7:42 AM
Java/J2EE, JBoss application server, MySQL Database, Oracle, SQL Server, SQL Server 2005, WebLogic Server, WebSphere Application Server
hello everyone Maybe my previous question was not the correct question to ask. I am in the middle of making an application upgrade which includes DB structure upgrade with keeping Data “data loss is not accepted here”. I have a complex DB structure in my application which depends “in some cases heavily depending” on database specific features. [...]
Answer Question
| January 25, 2011 7:42 AM
Java/J2EE, JBoss application server, MySQL Database, Oracle, SQL Server, SQL Server 2005, WebLogic Server, WebSphere Application Server
DBCCShrinkDatabase as Security Cleanup Measure?
Recently a private document wasposted to a publicly accessible SharePoint site. The file was deleted and removed from the search index by running an intermediate crawl of the content database. Now the client wants to shrink the database, which is just under a 1Tb in size and sits on a SAN, claiming that this will [...]
Answer Question
| January 24, 2011 9:38 PM
Database file security, SQL Server 2005, SQL Server security, SQL Server Shrink Database
Recently a private document wasposted to a publicly accessible SharePoint site. The file was deleted and removed from the search index by running an intermediate crawl of the content database. Now the client wants to shrink the database, which is just under a 1Tb in size and sits on a SAN, claiming that this will [...]
Answer Question
| January 24, 2011 9:38 PM
Database file security, SQL Server 2005, SQL Server security, SQL Server Shrink Database
Storage Area Network Configuration IOPS
I have a SAN with a RAID 10 (16 Drives) and a stripe size of 512. I want to align the disks for better SQL Server performance, the problem is that the OS is already installed on a non-aligned drive and SQL Server is running in production using non-aligned drives. My current 8 drives starting [...]
Answer Question
| January 17, 2011 11:10 PM
IOPS, SQL 2005, SQL Server 2005, SQL Server 2005 performance, Storage Area Networks
I have a SAN with a RAID 10 (16 Drives) and a stripe size of 512. I want to align the disks for better SQL Server performance, the problem is that the OS is already installed on a non-aligned drive and SQL Server is running in production using non-aligned drives. My current 8 drives starting [...]
Answer Question
| January 17, 2011 11:10 PM
IOPS, SQL 2005, SQL Server 2005, SQL Server 2005 performance, Storage Area Networks
