SQL Server Tag Directory

Browse Alphabetically:

Featured SQL Server Questions

  • Difference between nvarchar(max) and NText

    Now, I'm a beginner using SQL Server and I'm looking to learn more about the advantages / disadvantages between "nvarchar(max)" and "NText" data types. Now, I don't need to know backward compatibility so I already know that "nvarchar(max)" isn't supported by previous SQL Server releases.

    ITKE366,480 pointsBadges:
  • Migrating SQL Server 2005 back to SQL Server 2000

    How would I go about migrating SQL Server 2005 back to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to repair backup of .mdf file database?

    One of our clients gets the following error when trying to backup a database:quote:________________________________________System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x121db60d; actual: 0x521db60d). It occurred during...

    jordan26henderson5 pointsBadges:
  • What are basic differences between SQL Server 2000 and 2005

    What are the Basic difference between SQL 2000 and 2005? Thanks!

    Amin4rmOvexTechnology250 pointsBadges:
  • How to connect Google cloud SQL instance from Eclipse using app engine?

    I am trying to connect to Google cloud SQL instance from eclipse in my app engine connected android project. So far I'm able to connect to cloud SQL instance using Class.forname("com.mysql.jdbc.Driver"). But it requires authorizing my IP address in Google cloud SQL every time I want to use the...

    hussain22juzer525 pointsBadges:
  • Advantages of SQL Server 2005 over SQL Server 2000

    What are the benefits of upgrading to SQL Server 2005 from SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Updating the database using information_schema in SQL Server 2000

    I am having database a and b. I want to update database a according to adaptations in database b. b is same as a operations are done on b database and after completion a will get updated for permanent change? How can I do this automatically by using information_schema in SQL Server 2000

    Mcm5 pointsBadges:
  • Linked SQL Server problems

    I have 2 servers. Server 1 has SQL 2000 (SP2). Server 2 has SQl 2000 + SQL 2005 (sp2). I'm trying to create a linked server on Server 1 to Server 2 SQL 2005. I can get SQL 2005 linked into SQL 2000 on server 2 itself but when I got to Server 1 and try to create a linked server to SQl 2005, I get...

    KH155 pointsBadges:
  • How to restore SQL Server 2000 backup file

    How do I restore a SQL Server 2000 backup file?

    Nareshaswal5 pointsBadges:
  • Migrating data from Microsoft Access to SQL Server 2000

    I want to transfer data from access to SQL table and vice versa through Windows service. So, please help me.

    VBNET5 pointsBadges:
  • How can I make backup 4 file only and restore in SQL Server 2000

    How can I make backup 4 file only and restore in SQL Server 2000?

    01058478505 pointsBadges:
  • The specified module could not be found

    We are trying to install a software (on about 70 workstations) that uses a SQL type database that is stored on our server. We all have Windows XP and our server is Windows Server 2003. About half the Workstations are able to connect to the database with no problems. The rest are unable to connect...

    Kc54555 pointsBadges:
  • SQL Server datetime

    Hi - When I run this: select cast ('461129' as datetime). I get 2046-11-29 00:00:00.000 instead of 1946-11-29 00:00:00.000 Can you please let me know why and what I need to do in order to get the required results? Thanks.

    DBM10 pointsBadges:
  • SQL2000 linked to SQL2005 doesn’t allow TRAN selects

    Hi all, I have a SQL2000 machine that has a linked server that runs SQL2005 (before this was a SQL2000) When the systems were both SQL2000 from ServerA it was possible to run: BEGIN TRAN SELECT * FROM MYSVR.MYBD.DBO.MYTABLE COMMIT TRAN After the ServerB has been upgraded to SQl2005 the code above...

    alessandro.panzetta9,725 pointsBadges:
  • Transferring a database from Microsoft Access to SQL Server 2000

    How would I transfer a database from Microsoft Access to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Connectivity with Developer 2000

    Hi friends, I am using d2k as front end and for back end. I want to use my SQL Server 2000 data. How can I connect it? Thanks!

    Amitd15115 pointsBadges:
  • Upgrading SQL Server 2000/2005 to 2008 with VMWare and EMC SANs

    Has anyone ever seen a White Paper on the best way to utilize features of both VMWare and EMC Symmetrix based SANs in a real-time or rapid batch based upgrade from SQL Server 2000/2005 to SQL Server 2008 with minimal downtime for application availability?

    SQL2K8Dude5 pointsBadges:
  • Planning to move data on new database server?

    Well I'm working in MNC as a network admin actually we have one server having data & application so both our application and database on same server & now we are facing some problem on it so we plan to separate database server & application if any body has a plan or he/she know how move...

    Ravijoshi2020 pointsBadges:
  • 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 03  +...

    PRINCESS85 pointsBadges:
  • Null Expressions

    I am sure this is simple, I just need to know what the expressions is if you have fields in lets say a report that are : some empty and some with information...such as Telephone Field. I want to show only those "telephone" that are actually in the field. Example John Doe 555-555-5555 430 Cow Street...

    Karenfae30 pointsBadges:

Browse Alphabetically:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following