How do I restore my SQL .bak file over the existing database?
You can just restore it over the existing database. When you have the restore window open, just check the Overwrite database check box on the advanced tab.

View Answer   |  July 13, 2010  6:20 PM
.bak file, Data management and storage, SQL Database, Windows installation

Maximum memory on a 64-bit operating system?
It depends on the OS version. Take a look at this: <a href=”http://msdn.microsoft.com/en-us/library/aa366778(VS.85).aspx”>Memory Limits for Windows Releases (msdn)</a>

View Answer   |  July 12, 2010  6:52 PM
64-bit (x64), Capacity planning, Memory management, Operating systems, SQL Server administration, SQL Server memory

SQL server SP3
the other time when i had problem, i shut down all SQL services and installed the patch and it worked.. —— Without the actual error message from the log file which the installer created I’d just be guessing and that would be a waste of both our time.

View Answer   |  July 12, 2010  6:17 PM
SQL Server 2005, SQL Server 2005 Service Pack 3, SQL Server 2005 SP3, SQL Server Updates

Connecting to the SQL- SERVER from VS-2008 C#
This is not something that can be answered in a couple of lines here. In general, you will probably have to include the System.Data.SqlClient namespace and use some SqlConnection, SqlCommand, SqlDataReader objects. A simple google search will return many articles/tutorials on the subject. Feel free to post here any specific problem/doubt you encounter.

View Answer   |  July 12, 2010  2:56 PM
Connecting to SQL SERVER FROM C#, SQL Server connectivity, SQL Server database, Visual C# 2008, Visual Studio 2008

SQL Server 2008 Finding Most Recent Record Only
<pre>SELECT Letter_Ref, MAX(Print_date) FROM YourTable GROUP BY Letter_Ref</pre>

View Answer   |  July 12, 2010  2:44 PM
SQL Record, SQL Server 2008, SQL Server Query

How to create date in SQL Server 2000
Use the DATETIME datatype. This will store the value in a universal format. You then simple control the display format from your application. And if u want to make change from your procedure just use following: SELECT CONVERT(VARCHAR(8), GETDATE(), 5) AS [DD-MM-YY] u can give datetime column name in place of GETDATE() ——— You can’t [...]

View Answer   |  July 12, 2010  2:28 PM
Automated SQL Query, Display Attribute, SQL Server 2000 Database, SQL tables

How do I use DateDiff in cobol using SELECT statement?
First question I have is what release of the OS are you on? COBOL has intrinsic functions to do this very easy. This is an example of this function: <pre> 01 TIME-DIFF PIC S9(09) VALUE ZEROES. 01 START-TIME FORMAT TIMESTAMP VALUE ’2000-01-01-00.00.00.000000′. 01 END-TIME FORMAT TIMESTAMP VALUE ’2000-01-01-00.00.00.000000′. … COMPUTE TIME-DIFF = FUNCTION FIND-DURATION (START-TIME [...]

View Answer   |  July 12, 2010  1:29 PM
AS/400, COBOL, DATEDIFF, SELECT statement

Migrating from AS/400 to SQL Server
A product for DB2, DB2 Connect can connect a DB2Uninversal data base to iSeries DB2-400. It is a DRDA connection and runs much faster than ODBC. If you decide to move the data to MSSQL then can use Microsoft Access but it is ODBC and would be very slow for a large database.

View Answer   |  July 9, 2010  6:10 PM
AS/400 DB2, AS/400 migration, AS/400 SSIS, SQL Server migration

Sponsor Post: Cloud Migration Pros and Cons Live Chat Today
Suggest to try on Microsoft Online Service that is a business-class communications and collaboration software offering delivered as a subscription service, hosted by Microsoft, and sold with partners. These services help make it easier for customers to rapidly and cost-effectively access the most up-to-date technologies, and are designed for rapid deployment to provide customers with [...]

View Answer   |  July 8, 2010  2:53 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, datamangement, Development, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

SQL Server view column conversion problem
That’s because the processing is being done on the base table. If you want to search the view using an integer on that column you’ll need to put an index on the view. This will require that you rebuild the view with the SCHEMABINDING option, then you can build a clustered index on the view, [...]

View Answer   |  July 7, 2010  5:13 AM
Data conversion, SQL Server 2005, SQL Server Query, SQL Server View

Getting error when i am trying to insert the record in QTEMP file trough QSH DB2 command
when using QSH, your requests are federated to a separate job. this means that your local QTEMP is not the same as the QTEMP in that particular job. So it won’t work. as you say, you have to use a named library.

View Answer   |  July 6, 2010  1:16 PM
DB2, Qshell, QTEMP Library, SQL procedure

‘convert as/400 dates ’0001-01-01′ to SQL Server 2000′
http://forums.systeminetwork.com/isnetforums/showthread.php?p=70731 recommended that you convert the dates in a dts to null if ’0001-01-01′ select case datefield when ’0001-01-01′ then NULL else datefield end from prmstable; Phil

View Answer   |  July 5, 2010  5:29 PM
AS/400 date format, SQL Server 2000 administration, sql server 2000 datetime data type

SQL Server 2008 query To Find Columns with incorrect information
How about something like this ? <pre>SELECT * FROM your_table WHERE Town LIKE UPPER(Surname)+’%'</pre>

View Answer   |  July 1, 2010  3:46 PM
SQL Data Set, SQL Database, SQL Query, SQL Server 2008

ORACLE-TRIGGERS
Working with Oracle TIMESTAMP data type is so much easier than Oracle’s DATE data type (which of course) included date & time. TIMESTAMP is more granular (detailed). Oracle’s TIMESTAMP includes micro seconds (6 digits to the right of the decimal point) , exactly like DB2′s TIMESTAMP. For TIMESTAMPs in Oracle simply substract one from the [...]

View Answer   |  July 1, 2010  3:40 PM
Oracle PL/SQL, Oracle SQL Developer, Oracle triggers, SQL Trigger

How to keep date format when creating Index on a Table
I’ve found out the reason why the Date Format has changed: That’s because there is a option in RUNSQLSTM command to specify Date Format which is default to *JOB. What is needed to do is change that option to *ISO, then problem is solved!

View Answer   |  July 1, 2010  4:50 AM
SQL Database Indexing, sql indexes, SQL statements, SQL tables

Kerberos unconstrained delegation for MS SQL svc account
Yes. The account which runs the SQL Service is just a Windows account. It can be configured to run any service on the computer.

View Answer   |  June 30, 2010  7:07 PM
Kerberos, MSSQL, SQL Server permissions, SQL Server security

I’m interested in creating a web form that will deposit information into a SQL Server database.
You can use just about anything to do this. The most common options would be to use ASP, or ASP.NET. However you could also use Java, Cold Fusion, etc.

View Answer   |  June 30, 2010  7:05 PM
Forms Design, SQL Forms, SQL Server 2005, SQL Server 2005 Database, T/SQL

How can I write a SQL query to get the database name ?
Are you trying to get the instance name? That can be gotten by running <pre>SELECT @@SERVERNAME</pre> If you are trying to get the database name, you already have the code to get that.

View Answer   |  June 29, 2010  7:38 PM
Database name, SQL 2008, SQL Database, SQL Query

Trimming Values with SQL Server Express 2005
Try: <pre>left(<field>, len(<field)-7)</pre> This will discard the right-most 7 characters.

View Answer   |  June 29, 2010  5:42 PM
RTRIM, SQL Server Express 2005, SQL Server Functions, TRIM function

Linking users of Access 2003 to SQL Server 2008 database
Yes you can use a 32bit driver to connect to a 64bit SQL Server.

View Answer   |  June 28, 2010  9:22 PM
Access 2003, SQL Server 2008, SQL Server database, SQL Server Management, SQL Server Migration Assistant