• mssql login script

    Hello, Can anyone give me a simplet powershell script to check login attempt to remote MSSQL database.For eg: if i have a database "db" in remote sql server say 192.168.1.10 which having username"test" and password as "password".If the login is successful its output should shows as "OK" in...

    LINSONAJ5 pointsBadges:
  • a question about IMPORT/EXPORT from the SQL 2005 Migration

    In our original SQL 2000 DTS jobs, we call Stored Procedures and run BCP commands to Import/Export clients files. In our new environment we can not have the Admin right and permission for BCP. We tried to use BULK INSERT login from a special SSIS login name, but that login name is not our regular...

    906315 pointsBadges:
  • Grant users rights to run reports on reporting services

    How do I grant users rights to run reports on reporting services?  Those with admin access can run them, but users without admin access can't - they get an error that they don't have access to the data source.  When setting up the source, we used windows authentication.  I've given clearance on...

    Cindyfiller45 pointsBadges:
  • passing data between two SQL Server databases

    I am having an issue to passing data between two SQL Server databases.  I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables.  Also we are not allowed to use the...

    LL12325 pointsBadges:
  • bcp – clock time meaning

    Attempting to BCP a large resultset using a view and the queryout option. I have been playing with the network packet size and the size of the batche using join conditions. When looking at the command line output file. What do the values in "Clock Time (ms.) Total" signify. I am trying to measure...

    Joetig35 pointsBadges:
  • convert from msaccess to sql2005

    SELECT Format(DTrans.DATE,'dd/mmm/yyyy') AS dated, DTrans.trntype as Expr1 , DTrans.JVNO, 'By ' & FINNACCO.ACCNAME , (select analscode from INCEXPAN where analscode=val(DTrans.CRANALSCODE) and accode=craccode) AS CRANALSCODE, '' , DTrans.AMOUNT, dtrans.craCCODE AS accode,...

    Radhikanutalapati5 pointsBadges:
  • Power builder 7.0 compatible with SQL 2005

    We currently use Powerbuilder 7.0 with SQL Server 2000. We want to upgrade to SQL Server 2005. Does anyone know if SQL Server 2005 is compatible with Powerbuilder 7.0?

    Mukulluniya305 pointsBadges:
  • SA Password change for SQL

     What is the easiest procedure for changing the SA password, and what is the procedure for testing the password change?

    Syscheck5 pointsBadges:
  • sql results to text file

    I starting using a new laptop and checked all my sql settings however when I run the same script on my old laptop and new laptop and save to file as text, the data is exactly the same but it is much larger on my new laptop. What setting am I missing on my new laptop? I already save with Encording...

    Chpern5 pointsBadges:
  • Auto backup configuration in SQL2005

    How to setup an autobackup for the backup type of Full database and transaction log together as a single bakup file in sql2005.? We can setup to backup full database seperately and transaction log seperately, but i wanted these two should be a single backup file. Any suggestion pls.

    Shamoh40 pointsBadges:
  • Can I Use Tomcate as a “Witness” Server in SQL 2005 Mirroring

    Hello i am using SQL 2005 and i have Tomcat as an Application Server i want to use Mirroring on my DB and i am looking for the way that let me make Tomcat as my Witness server [Br class="height5" />[small] [/small]

    ITKE56,100 pointsBadges:
  • Replication Causes Client Application to Hang

    I've got 25 Sites that are running an application that connects to MS SQL 2005, All the sites have their own copy of a database and have one similar database that holds information gathered from the different sites, now what is happening is that if a client registers at one institution and then...

    Sanisto45 pointsBadges:
  • Reformatting SQL Data in a Field

    Hi, I'm new to the whole SQL experience and need help converting some data.  In our Activity table, data was imported into the UF_4 field incorrectly.  We want to convert this data "from a Decimal format" to a “NonDecimal”.  Currently the data looks like 5234.000 and we want it to look like...

    DCDJ45 pointsBadges:
  • Web Application very slow SQL 2005

    Can I get a detailed information on what are the possible things we can do to identify the performance issues? I had run the SQL 2005 profiler against load test for about 2hrs and captured all the trace. I could see the procedure that runs for various different parameters was consistently taking...

    Jsql155 pointsBadges:
  • Show the table field on vb.net form

    How can I show table fied on vb.net form.I have used sql2005.

    Chat305 pointsBadges:
  • Which version of SQL will work best?

    We have a small but critical application that is accessed by about 30 - 40 users on our network. We want to set up a SQL environment to run the database, but the application accessing the data is locally installed on each users machine. Users will access the db over our network using an ODBC...

    LeninKAF5 pointsBadges:
  • Deleting Nightly Database Backups (dumps)

    How do you set up a maintenance plan to delete or overwrite daily database backups (*.bak) file. My maintenance plan in SQL 2005 does not work...it doesn't do the cleanup it continuously appends to folder and I have to manually delete the files everyday

    637815 pointsBadges:
  • SQL 2005 Password

    If you move a sql 2000 database to sql 2005 which admin password does it have now.

    Jabbman4220 pointsBadges:
  • SQL2005 SP3

    Hi, I recently applied Service Pack 3 to SQL2005 64 bit and my server performance has been very slow since. The statistics have been updated on my databases, but that has not made a difference. Has anyone else experienced such behaviour post SP3 install? Thanks, Lakshmi

    Lmurthy5 pointsBadges:
  • Database and Log file location

    How do I change the default location for database and log files during a SQL 2005 installation?

    Quincy185 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