Refresh a SQL View in ILE
You can drop the view and create it again but you may not need to If you “updated one of the files that the view is based on” by adding or deleting a field that is not used by the view no change should be necessary. The view contains the set of rules for gathering [...]

View Answer   |  April 7, 2009  6:45 PM
AS/400 SQL View, RPGILE, SQL View

SQL 6.5 Upgrade
I have not done this upgrade, but I would not expect to see performance drop. Some things to check and do if missing <ul> Have you set Maximum Memory for SQL Server Have you changed database compatibility level to 10 Have you re-created statistics for all your upgraded databases Do you have enough memory on [...]

View Answer   |  April 7, 2009  2:56 PM
SQL, SQL 6, SQL 6.5, SQL Upgrades

Backup Performance Compare
I suggest you reading <a href=”http://msdn.microsoft.com/en-us/library/ms190217.aspx”>this MS Article</a> about the topic.

View Answer   |  April 7, 2009  1:41 PM
SQL Server 2005, SQL Server backup and restore, SQL Server database, SQL Server performance

Tool for migrating DTS to SSIS
Hi have a look at this <a href=”http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/”>really good article</a> that talks about the topic.

View Answer   |  April 7, 2009  1:09 PM
Data Transformation Services, DTS, SQL Server Integration Services, SQL Server migration, SSIS

How do I write a SQL statement to get all data from a table called subscrib?
SELECT * FROM subscrib;

View Answer   |  April 6, 2009  1:42 AM
SELECT statement, SQL, SQL queries, SQL statements

Renaming a SQL 2005 server
After you rename the server normally, connect to the SQL Server and run the following. <pre>exec sp_dropserver ‘OldServerName’ go exec sp_addserver ‘NewServerName’, ‘LOCAL’ go</pre> Then restart the SQL Server Service.

View Answer   |  April 4, 2009  10:55 PM
SQL 2005, SQL Server 2005

SQL Export to Excel file column?
You can use the <a href=”http://msdn.microsoft.com/it-it/library/ms174420.aspx”>DATEPART </a>to get just given parts of the DT filed.

View Answer   |  April 4, 2009  5:01 PM
Microsoft Excel, SQL Export to Excel, SSIS, SSIS 2005, SSIS Package 2005

Store Procedure Codes Please help
I think you would have more chances to get useful responses if you synthesize the question a little. So, I would re-word the question being as specific and concise as possible, would post an example of the desired output (if applicable), would try to clearly specify what my problem is, and if I was getting [...]

View Answer   |  April 4, 2009  1:59 AM
SQL, SQL stored procedures

Viewing distinct records in a SQL query result
This could be one way to do it: <pre>SELECT id, min(description) FROM YourTable GROUP BY id;</pre>

View Answer   |  April 3, 2009  6:03 PM
SELECT statement, SQL Query, SQL Server Query

How to implement an Entity Relationship Diagram into a working database?
If you are asking how to diagram an existing database, from within SQL Server Management Studio open the database, and select Diagrams. Add your tables, and it will create the diagram for you. You can also use Visio to reverse engineer your database. If what you are asking is how to create the database in [...]

View Answer   |  April 3, 2009  2:34 PM
ER diagrams, SQL Server 2005, SQL Server database diagram

Matching External lists to your Database?
How do i start. I also work fo a comapny where we have lists come in every day that we need to de-dupe from what in our SQL Server database. We get lists from Alliance as well a lot of other vndors so i know your pain. As far as software tools we use MatchIT [...]

View Answer   |  April 3, 2009  12:23 AM
Query optimization, SELECT statement, SQL, SQL queries

Acces rights for all user of an SQL SERVER 2005
This T/SQL script will script out all the rights to all the regular database objects in your database. <pre>select sys.schemas.name ‘Schema’, sys.objects.name Object, sys.database_principals.name username, sys.database_permissions.type permissions_type, sys.database_permissions.permission_name, sys.database_permissions.state permission_state, sys.database_permissions.state_desc, state_desc + ‘ ‘ + permission_name + ‘ on ['+ sys.schemas.name + '].[' + sys.objects.name + '] to [' + sys.database_principals.name + ']‘ COLLATE [...]

View Answer   |  April 2, 2009  6:29 PM
SQL Server 2005, SQL Server permissions, SQL Server user permissions

Optimizing a SQL Server stored procedure
There are many factors that could affect performance. Without more information, it will be really hard to answer. Can you post your code ? ——— The first thing that you need to do is identify what statement within your stored procedure is causing you the most problems. You can do this by looking at the [...]

View Answer   |  April 2, 2009  6:27 PM
EXEC, SQL Server stored procedures, SQL Server tables

Passing data between two SQL Server databases
Yes, if you have a linked server from the database server that you are connecting to, to the other database server and the login which you use to access the remote server via the linked server has access then you can access the remote database. However using a variable for the database or server name [...]

View Answer   |  April 2, 2009  6:24 PM
SQL Server databases, SQL Server stored procedures

SQL Writer library failed initialization
Have you tried uninstalling and reinstalling the SQL Writer as per the error message?

View Answer   |  April 2, 2009  2:14 AM
SQL, SQL writer, SQL Writer error messages

Configuring IPv4 host to IPv6 compatible in Fedora 9 Sulphur
Hi This question is very OS specific. Please refer to a Fedora Working Group or Blog. Cheers, Silvia Hi, If all you are looking to do is assign an IPV6 address to an interface, use the command: [root@serverA ~]# ip -6 addr add {ADDRESS} dev {DEVICE} to delete the address substitute ‘del’ in place iof [...]

View Answer   |  April 1, 2009  4:17 PM
Config, Fedora 9, IP configuration, IPv4, IPv6, Networking

What is the difference between SQL and T-SQL?
SQL refers to the base Structured Query Language which is an ANSI Standard. T-SQL, also known as Transact-SQL, is a “superset” of SQL which is used by Microsoft SQL Server and Sybase SQL Server. T-SQL supports all the commands that SQL supports, but SQL doesn’t support all the commands that T-SQL supports. For more info: [...]

View Answer   |  May 15, 2013  3:31 PM
SQL, T-SQL

Simple SQL server question?
Using SQL 2000 you’ll need to create a temp table (a table with a # as the first character in the table name) then put the selected rows into the temp table. Update the values in the temp table as needed, then write those values to the destination table then delete them from the source [...]

View Answer   |  March 31, 2009  10:55 PM
dBASE, Microsoft Access, SQL Server 2000

Create text file to OS400 folder by using Microsoft SQL Server 2005
Instead of trying to create the folder on the mapped drive, create the file on the OS400 folder using the full network path to the folder. You will need to make sure that the SQL Server is running under a domain account and that, that account has rights to the network share on the OS400 [...]

View Answer   |  March 31, 2009  5:23 PM
AS/400 Text File, OS/400, SQL Server 2005

Application not responding in Windows XP Professional
Try either the process explorer (procexp.exe) or process monitor (procmon.exe) utilities from Sysinternals/Microsoft. These can be found at http://live.sysinternals.com. You can also do a search for them on the Microsoft website if you need additional documentation.

View Answer   |  March 31, 2009  5:10 PM
SQL Server 2000, SQL Server errors, Windows XP, Windows XP Professional