Accessing an SQL 2005 Synonym with ODBC
Is there a way to link to a synonym in SQL 2005 using ODBC and MS Access?
View Answer
| Oct 7 2008 5:54 PM GMT
| asked by
Randym
ODBC, SQL 2005, Microsoft Access
SQL 2005 and Security Account Delegation
I read this feature for SQL2000 SP3 but I wonder if this is still valid for SQL2005 or, if it has changed which is the new feature that enables to retain the authentication credentials of the original client.
View Answer
| Oct 3 2008 4:04 PM GMT
| asked by
Alessandro.panzetta
SQL 2005, Security Account Delegation, SQL 2000
How to create a temporary table in sql 2005 via SSIS
I need to load a flat file into a temporary table. So I need to know how to step by step how to in SSIS "Data Flow Task" create a temporary table, load one col from the flat file to the temporary table along with the date it was loaded. I will then use the temporary table to delete from another...
View Answer
| Oct 1 2008 8:55 PM GMT
| asked by
NewBee7
SQL tables, SQL 2005, SSIS
PHP or HTML
I need to create a database that allows a user to query info. on a project,name, proj number, contacts, contact #, etc. We are using SQL 2005. The office manager will enter info. about each project into an access form. Then, from the HTML page a user can f search by project name or number to list...
View Answer
| Aug 21 2008 3:08 PM GMT
| asked by
Caddman
SQL 2005, HTML, PHP
SQL 2000 and 2005 Offline Table Reindex Determination
Hello,I have prcessed SQL 2000 offline reindexes in the past for specific tables when there was scheduled downtime, but I was wondering if there is a tool or script that I can run for a specifc SQL database to determine which tables in the database would need to be reindexed. I do not want to...
View Answer
| Aug 15 2008 2:59 PM GMT
| asked by
Bankerdba
SQL 2005, SQL database, SQL 2000
I need to move a sql 7.0 database to a different server running sql 2005.
What would be the best way to do that and will the jobs and DTS jobs come with the database? If not how can I move them also. Thanks for any suggestions.
View Answer
| Aug 12 2008 2:21 PM GMT
| asked by
Bubbanm
SQL 2005, SQL database
Move/Copy System DB’s to new server in SQL 2005
Trying to move system DB's to brand new server (really virtualized server). Server names are different. Any suggestions would be appreciated.
View Answer
| Aug 4 2008 5:12 PM GMT
| asked by
Seandon
SQL 2005, SQL, Database migration
Problem with SSIS & AS400, Source is AS400, Dest is SQL2005
When I'm trying to retrieve data from AS400, I received the below error:The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".How do I know which code page to use besides the default of 1252?
View Answer
| Jun 24 2008 11:44 PM GMT
| asked by
Thuybui
AS/400 errors, SQL 2005, SSIS
clustered sql 2000 to sql 2005 upgrade
What can I expect when upgrading a clustered SQL 2000 box to SQL 2005?
View Answer
| Jun 24 2008 9:41 PM GMT
| asked by
Ajf
SQL Server upgrades, SQL Server clustering, SQL 2005
