• Adding a password to a SQL Server 2005 database

    We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • convert SQL datetime to date only

    Using SQL, how can I convert a data in a datetime field to a date only data? When I run a job to collect data, I use the getdate() function that returns the date and time. I want to then convert this to the same date but with a time of 00:00:00. Please advise. Thanks! ~Gina

    Gina35 pointsBadges:
  • How to change datetime values in SQL Server?

    I want to present a datetime value without hours, minutes or seconds in SQL Server 2008? Would this code work?Statement @SomeDate datetime = '2013-09-18 16:30:22' select trunc_date(@SomeDate) ----------------------- 2013-09-18 00:00:00.000

    ITKE352,430 pointsBadges:
  • How to implement crosstab query in Access?

    How to implement crosstab query

    Shamu75 pointsBadges:
  • Impact on application after upgrade from SQL Server 2005 to SQL Server 2008?

    What would be impact/changes to be done in my application which is using general SQL for upgradation from SQL Server 2005 to SQL Server 2008 ?

    Vht5 pointsBadges:
  • How can Systems Center help with uptime, availability and performance of SQL Server instances and Exchange mailbox servers?

    We are particularly concerned with the uptime, availability, and performance of SQL Server instances and our Exchange Mailbox Servers. How can Systems Center help me with this? This question was asked during the Microsoft System Center live chat on IT Knowledge Exchange in January 2010.

    ITKE352,430 pointsBadges:
  • Invalid String or buffer length ERROR in SQL Server 2005

    I am trying to connect to SQL Server 2005 express edition using JDBCODBC bridge driver. I have succesfuly configured the data source but when I use DriverManager.getConnection("jdbc:odbc:sql")-->SQL is the data source name. I catch this Exception. Many thanks in advance.

    1023965 pointsBadges:
  • Backing up and copying a database across SQL Servers

    I have SQL Sever 2005 on both servers A and B, although I do not have SQL Studio Manager on server A. I would like to backup a SQL database from server B onto server A, and then copy it over to server B and restore it to the same database. How would I go about doing this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I connect DB and input values in stored procedures using VBA

    Hi all, I'm using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me.

    Jprpvk5 pointsBadges:
  • Conversion of SQL Server 2000 to iSeries DB2 V6R1

    Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.

    Tprusko5 pointsBadges:
  • Code Impact Analysis Tool

    Hi, Need a tool to do the impact analysis of .net/java/com code files and should produce the matched code/classes/objects/methods/references etc. for a particular database hit (stored-procedure or select/insert/update query)

    Kvrao5 pointsBadges:
  • Dcom Error – event id 10003.

    I am getting Dcom Error,in eventlog file. its appearing frequantly. how to solve this problem, please anybody help me.this is what showing in the event log. Event Type: Error Event Source: DCOM Event Category: None Event ID: 10003 Date: 9/4/2004 Time: 8:50:51 AM User: N/A Computer: Database server...

    Hfakruddin0 pointsBadges:
  • How do you create stored procedures in SQL Server 2000?

    How do you create stored procedures in SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Inbound and outbound interfaces in SAP

    I have been asked to find out the list of Inbound and Outbound interfaces in SAP and their structures. Basically we will try to write a module which can send data in the SAP required format and also receive the data from the SAP in their format and load it in our SQL Server table. Is there a way I...

    rajivk5 pointsBadges:
  • Create A Fixed Text File From SQL DB Table

    Hello programmers. After doing much research I am unable to resolve how or where to custom format each field of my SQL table output into my text file. Can someone help me with enhancing the below vb script? I need to reformat certain values. Do I do the formatting in the Dim section or in the if...

    Ilfoprog50 pointsBadges:
  • Get data from one MySQL datebase server to another in real time

    Hi, I am using MySQL database. I want to create one more database which I want to get updated in real time from the remote MySQL database server. Kindly help me in this. Thanks

    Chetanm145 pointsBadges:
  • How to Display Japanese character in Crystal Report 8.5

    Hi, I've some data stored in Japanese language in SQL Server 2005 database using nvarchar datatype. When I execute store procedure in SQL Server, it's showing japanese character properly in SQL server. However, when I'm trying to display data in crystal report 8.5, it's showing ????? character....

    Kaushalp50 pointsBadges:
  • Bundling SQL Express Edition

    Is it free to Bundle the SQL Express Edition within our Product or along with our Product CD/DVD?

    Rajeshbs45 pointsBadges:
  • How to check browser activity?

    Hi, I'm working a project, in that I'm storing login, logout time. What if i don't click logout button and close my browser, or somehow my system shutdown.I cannot store the logout time, so that my program will be in error state. Tell me how to get the logout time when my programmer didn't click...

    Karthij5 pointsBadges:
  • Can somebody provide me SQL questions based on various situation?

    I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for...

    Mayurkhe295 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