• Long Path Error While Copying/Moving Data

    Hello Frnds, I am very new in this site. I have one problem while I am cpoying/moving the data from the server to the local machine or in the Local machine it self. The problem is that while copying/moving data sometimes is doesn't work due to long path name. Means that if path length is greater...

    Prash7860 pointsBadges:
  • Why is SQL Server Management Studio taking so long?

    We're trying to do some offline maintenance work on one of our development databases but the "Take Offline" command (through SQL Server Management Studio) is working very slowly. We have no idea what might be causing it to run so slowly. There are no open connections too. Any ideas why this is...

    ITKE346,285 pointsBadges:
  • Checking if a view exists in our SQL Server database

    We have some SQL code that will only be executed if a certain view exists in our SQL Server database. How can we actually check if the view exists? Thanks!

    ITKE346,285 pointsBadges:
  • Checking the version of SQL Server for a database using T-SQL

    Is there a way for me check what version of SQL Server I'm using for a database through T-SQL? Would there be some sort of stored procedure I can use? Thanks.

    ITKE346,285 pointsBadges:
  • SQL Server database: Checking which locks are held on table

    I know this an older version but I'm using SQL Server 2005 and I'm trying to check what database locks are applied on rows against a query batch. Is there some tool that will help me highlight table row level locking in real time? Appreciate the advice.

    ITKE346,285 pointsBadges:
  • What’s the best way to check if a database exists on SQL Server

    I understand they're probably different ways to do this but I'm looking for the best way to check to see if a database exists on a SQL Server using T-SQL. Thanks for the help.

    ITKE346,285 pointsBadges:
  • Why should we use an Oracle database over others?

    We're looking to decide which database system we should use for our organization. We're leaning towards using an Oracle database but we're looking to first know why we should choose that over other databases (SQL Server, MySQL, PostgreSQL). Basically, we would like to know what features make it...

    ITKE346,285 pointsBadges:
  • How can we store hours and minutes in a SQL Server database?

    My partner and I would like to store times in our SQL Server database but we only need to store hours and minutes. We already know we could use "DATETIME" and ignore the rest of the data but is there an easier way to do this? Thanks so much.

    ITKE346,285 pointsBadges:
  • VB.NET code to search if a record already exists or not

    Hi! I need a fresher..I want a VB.net code to search record from SQL database table by using two fields of table as a condition i.e client name and client code before saving any new record and if record already exist in table it give me message for that. I'm sending you the code. Please help...

    Sachinm10 pointsBadges:
  • (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53

    Problem: SQL SERVER is up and the instance connect is running. All required ports on Firewall is open/ also try to disable Firewall but no success. TCP/IP protocol is ENABLE.  SQL SERVER port is by Default 1433. Also try this: The problem is the Instance name from the client is not resolved, to do...

    Safekom33330 pointsBadges:
  • SQL convert numeric to date format

    How can I convert an 8 digit numeric (format ccyymmdd) into a real datefield to be used in date arithmetics? I need to calculate the number of months between the month (current date) and a date represented in my DB as an 8 digit numeric with format "ccyymmdd". Therefor (I assume) I need to convert...

    DanTheDane2,555 pointsBadges:
  • Can I version my SQL Server database?

    I'm trying to get several of my SQL Server databases under version control. Would anybody have some advice on how I should do this? Basically, I'll want a large collection of generated test data for performance management. Thanks so much!

    ITKE346,285 pointsBadges:
  • SQL server 2008 downgrade to express

    Due to our budget we are being forced to downgrade some servers from SQL server 2008 R2 to Express. Was told it 's a saving of 20k per PC.Are there any issues that we need to know that may cause us problems? I know Microsoft does not make downgrades easy.. If anyone could shed some light I'd...

    ToddN200011,190 pointsBadges:
  • Moving SQL Server database without affecting VB 6 code

    I am using VB 6 code with Microsoft Access database. Now I want to move to SQL Server 2008 database without affecting my VB 6 code. Any suggestions?

    vikasjains20 pointsBadges:
  • Installing SQL Server 2008 and VB 6 on the same PC

    I have 1 pc.3 drives-c:,d:,e:. Now I want to install SQL Server 2008 and VB 6 on the same PC. Mean to say Can I make use of SQL Server 2008 with VB 6 on same machine?

    vikasjains20 pointsBadges:
  • Do all versions of Microsoft SQL Server 2005 support database mirroring?

    Do all versions of Microsoft SQL Server 2005 support database mirroring?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to configure SQL Server agent

    In my SQL Server, I'm unable to find the SQL Server agent. How do I find it?

    venkat199110 pointsBadges:
  • Flowchart

    Can someone help me write a flow chart and algorithm of a program where the user is asked to find an integer number between 1 and 50? Thanks!

    melkamu15 pointsBadges:
  • My database .mdf file got corrupted in SQL Server 2008

    My database .mdf file got corrupted and I have no means to get my schemas. I tried with a few softwares available on the internet but its turns out that with all of them being demo versions, I don't give back the repaired file. Is there any other means by which I can restore my db? I am using MS...

    mjozekh5 pointsBadges:
  • Setting up a ODBC connection in Lotus Notes

    I've been trying to connect and send/receive information from a Microsoft SQL Server, in my Lotus Notes application using @formula in real-time, but I'm having trouble with the configuration. I've read that I have to set up ODBC driver. Where can I find that? And do I install it on the server or...

    ITKE346,285 pointsBadges:

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