• Conversion of Oracle trigger to MS SQL

    How can I convert an Oracle trigger into MS-SQL?

    Jannat895 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:
  • Member relationship in DB2

    I would like to know the relationship of member in DB2 interms of  MSSQL table. I need the query to fetch member in SQL Server

    sbesuedbknk5 pointsBadges:
  • MSSQL logs

    Hi everyone, I'm wondering if someone could help me in getting the logs in MSSQL? or possibly using script? I need to get the logs from an application. This application has a backend database MSSQL. There's no other way in getting the logs but to get the logs directly with the database. I need to...

    jezz341195 pointsBadges:
  • SAN to SAN hardware level replicaiton to replicate MSSQL 2008 R2 databases

    If SAN to SAN hardware level replication solution is implemented, how can we utilize this solution to transfer MSSQL 2008 R2 databases' MDF and LDF files.

    MSSQLDBA5 pointsBadges:
  • collation discrepancy issue

    how to fix the collation discrepancy issue while upgrading an application. In mssql 2005 database server, tried to create a database with windows authentication and manually provided sql authentication and ran three queries ALTER DATABASE djbadmin SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER...

    Tigerravi5 pointsBadges:
  • How can we get shell when dbms is SQL2008 and we found an sql vuln in REFERER field, which revealed version,dbs,tables etc?Sqlmap didn’t work.

    Hello, During my last pen test I found an sql vulnerability in the REFERER field of the headers. This revealed me, using sqlmap with --referer option, the DBMS which is Microsot SQL 2008,all  db names, tables, db users etc. My problem is that I cannot test if a shell can be spawned, since...

    Astathaki5 pointsBadges:
  • SQl Server 2008 standard Mirror architecture, fail over without changes in applications

    I am trying to implement the mirror architecture for SQL Server 2008 standard database. We have different processes that connected to database and I don’t have control over those environments.  I got impression that in such cases it’s better to create DNS on server site that could be used by...

    DDB0075 pointsBadges:
  • MSSQL 2008 sudden and drastical slow down – IT telephony

    Hi, I'm a newbie, greeting everybody from Hungary, and thanks for your time :) Generally the SQL system runs smoothly. There is a SP which runs two times daily, and it logs the begin/end times. It takes about 20 minutes each time, normally. Suddenly I see that it takes 3-4 hours. Each time the same...

    Sandy6015 pointsBadges:
  • Ageing Report T-SQL

    Im trying to write a query to retrive debtors ageing report in sql I have two tables [strong]1. Billing(billAmount,BillDate,AccountNo)[/strong] [strong]2.Payments(payAmount,payDate,AccountNo)[/strong] I need the output to show ageigng [strong]0-30, 31-60, 61-90, 91+[/strong] with the balances for...

    Sanisto45 pointsBadges:
  • Kerberos unconstrained delegation for MS SQL svc account

    Can an MS SQL service account run non-SQL services if "trust this user for delegation to any service (Kerberos only) has been enabled?

    Calicdaj5 pointsBadges:
  • Would using a table variable from a function be efficient?

    We divided our tables from table zone_a, ..._b, ..._c to zone_z, these tables have the same attributes. We have divided this tables in this way so that any data that is under zone_a would only be on it's specific table, and the same with the other remaining table. Since per table holds thousands of...

    C114020 pointsBadges:
  • 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:
  • what is different from MSSQL, MYSQL and Oracle 11g?

    what is different from MSSQL, MYSQL and Oracle 11g? Which one is the best for 15000 transaction daily?

    Juna060615 pointsBadges:
  • applications of rdbms in real world

    i need to know how rdbms is used in our real life with good example

    Chithra5 pointsBadges:
  • ms sql query problem with a case statement

    [strong]This code works: SELECT     passengers.*, passship.passship_name AS name, passship.passship_speed AS speed, passship.passship_size AS cargo, hyperjump.hops AS hops, ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) AS ptprofit...

    Rinkratt20 pointsBadges:
  • Getting last entries from two different tables

    Hi, I need to get the last entries from two different tables in MSSQL. I can get the last entry for one table by usung the following. SELECT * FROM dbo.Shaft_Scales WHERE dbo.Shaft_Scales.ID = (SELECT max(ID) from dbo.Shaft_Scales ID) The problem is adding another table. Please help

    GPNel200675 pointsBadges:
  • MS SQL SERVER (BKUPEXEC) Services wont start

    Hi ALL, Background: Windows 2003 Server returned the error missing or corrupted file after the server was found OFF due to possible power problems (Server is on a UPS). Ran a CHKDSK on the server and it fixed the missing or corrupted file problem and server now up and running. Is seems that my SQL...

    Ahmyown30 pointsBadges:
  • EMC networker MSSQL Restore hangs

    I am trying to restore the model database on a EMC MSSQLv5.1 client The EMC server is version 7.4.2 When running the restore we can see no activity on the Client and in the Networker console it shows the server as "browsing". In the devices tab no tapes are loading and nothing is reading from...

    Shaun536910 pointsBadges:
  • SQL Find a number between the given ranges of number / Find a row which has range of given number

    I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value in...

    Bsethi245 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