SQL Server

Diff. between PF and a sql table

can anybody say what is the most basic diff. between making pf by writing DDS and sql table by create table command because both can having index.....

synonym in SQL server 2005

How can one get the information about the object type of synonym that is whether the synonym belongs to function, stored procedure, table or view using a query. Sys.synonyms table contains information about synonyms present in a particular database but it does not tell for which object the synonym...

Upgrade to IDES CRM 7.0 (ABAP)

Hi All, My client using sap IDES CRM 5.0 (ABAP) and he wanted me to upgrade to IDES CRM 7.0 (ABAP) . I am new to BASIS, can any one help , which CD's( with the CD numbers and related notes numbers ) to be downloaded from service market place and how to start the upgrade on a stand-alone system...

Windows Server and SQL database upgrade

 We are goging to upgrade server, SQL server databases and domain name, now currently using as following setting 1. Server OS - Windows server 2003 Enterprise Edtion. 2. SQL server 2000 3. domaname xxx1 we are looking and upgrade to new os version, server SQL server and change domain name. ...

Optimizing Query that uses linked tables and bound form w/joins

I have a bound form whose record source is an Access query.  That Access query involves 3 linked SQL Server tables (one inner join, one left join).  The form takes a while to open. I have run a SQL Profiler and it appears that access is sending two select fields from table without where clauses,...

SQL Server 32 bit, AWE/3GB/PAE

I have read quite a few articles that recommend turning on /3GB on a server with 32bit SQL server and 32bit Windows 2003 standard where you have between 4GB and 16GB or RAM. Why is /3GB needed? Just so SQL Server can have more VAS, and because VAS is better than AWE mapped memory? This switch...

Contest Update: Nominate a member and you could win 1 of 5 Amazon gift cards

A quick and important update on our Panasonic flatscreen contest and the nominations process -- we will be giving away five (5) $20 Amazon.com gift cards at random to members who nominate someone in the community feedback form here. Thanks!

Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB

I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done this? ...

Making a WAN

Hi, I would like to know the best way to setup a WAN. We have 4 small companies and one main Head quarter.  2 companies are in one city and 2 are in another city. Below is the detail on what each site has. HQ(head quarter)- HP Mail Server (HP ML350) - Win 2003 Server + Exchange Server...

The most-watched IT questions this week: Sept. 22, 2009

Curious as to what the most popular IT questions and answers are on  ITKE? So were we! So we’ve been watching the watchlists, so to speak, to bring you the top 10 questions, answers and discussions at the top of user watchlists this week. Read them all at our Community Blog.

Nominate a member for our latest Panasonic flatscreen giveaway

In our latest (and biggest!) IT Knowledge Exchange giveaway, we're giving thanks to the star members of the community who provide quality contributions in their questions, answers and discussions. Did a member answer your question in a particularly great way?, Did someone recently contribute to...

Odd problem (conversion or openquery?) only appearing in a stored procedure but not when running it adhoc

Here's the code I can run with no problems: declare @AnneeSelectionnee numeric select @AnneeSelectionnee = 2009 declare @DateDernierImport datetime select @DateDernierImport =  'Nov 14 2008 12:00AM' SELECT     LTRIM(RTRIM(T_ASFSTAG0.STANS1)),     LTRIM(RTRIM(T_ASFSTAG0.STHFO1)),...

Complete System Backup SQL Server

We are running SQL 2008 on Dell Servers with a wholesale Distribution Package Software by Activant Solutions Called P21 (Prophet 21) Our question is this! WE have a SQL Server and a TS Terminal Server running our Distribution Software and off of this equipment was recommended by the Activant...

If running two SQL Server db in two VMs, I should purchase two db servers?

If running two SQL Server db in two VMs, I should purchase two db servers? This question is from the Microsoft Virtualization Live Chat which took place on August 27th.

PASSING PARAMETERS TO REPORT VIEWER

Hi Kindly excuse me if i appear abit ignorant on this subject as i am relatively new to SSRS. I have managed to create a report that has 3 parameters (ie. Start Date,End Date,Drop down list) which i have successfully deployed to Report Server. The report basically uses a Stored Procedure which has...

dbcc checkdb error; object id 0

Hi, We have been ask by one of our customer to restore a database from SQL Server 2000 and SQL Server 2005. The restore completed however when we run a integrity check on the database errors occurred. We than ran an integrity check with repair allow data loss option, as the customer is happy to...

Trigger Use

I have a Sequel Server 2005 database with a Table called Main Call Issue. I want to update the DateTimeModifed field to be the Current System date without changing my original DateTimeAdded field when the record was added to the database. I know a Trigger will work here. Where do I place the...

Export Oracle data to Excel

Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks Software/Hardware used: Oracle, Excel

The most-watched IT questions this week: Sept. 15, 2009

As part of a new feature on the IT Knowledge Exchange Community Blog, we're highlighting the top 10 most-watched questions. Here are the top 5: Virtualization vs. Consolidation, Tracing a computer to an IP address, Connect remote Oracle 11g server in VB 6.0, How to utlize multiple static IP's when...

SQL Database User

Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql...