• SQL injection attack detection

    How can I find if my site is vulnerable for SQL injection attacks? Can anyone share the tips to prevent it?

    KelvinS80 pointsBadges:
  • MS SQL Server version

    Hi MS-SQL Server-ers, I'm wondering with is the date displayed in the version of SQL Server (by using @@version)? Could anyone tell me what is that date referred to? Thank you!

    srithea350 pointsBadges:
  • SQL Server database administrator

    Temp DB size is gradually increasing. My current temp DB size is 12gb. How do I resolve this issue?

    nasarbabu30 pointsBadges:
  • Check if a column exists in SQL Server database

    In a SQL Server database, is there a way to check if a column exists in a table? This is what I came up with but it keeps returning false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') Thanks!

    ITKE434,595 pointsBadges:
  • SQL Server: Parameterize IN clause

    Is there a way to parameterize an SQL query that contains an IN clause with a variable number of arguments? Something along the lines of this: select * from Tags where Name in ('ruby','rails','scruffy','rubyonrails') order by Count desc I don't want to use a stored procedure/XML so what's the best...

    ITKE434,595 pointsBadges:
  • Sanitize user input for a SQL injection using PHP

    What's the best way to sanitize user input for a SQL injection / XSS attack? I need it done with PHP too and it needs to still allow types of HTML tags. Thanks!

    ITKE434,595 pointsBadges:
  • SQL Server 2008 R2 database isolation change

    I want to change my database isolation to read uncommitted in SQL server 2008 R2. Can someone tell me the exact process and how should I can achieve this?

    edwinjhoffer3,355 pointsBadges:
  • Trigger email alerts on Windows Server 2008

    In Windows Server 2oo8, can I trigger it to send out an email alert when our logical disk partitions become low on space? We currently have two SQL Servers that are running out of space. It's due to log files. Thank you.

    ITKE434,595 pointsBadges:
  • Move SQL query results to another table

    I have this query: SELECT a.* FROM devices_staging a INNER JOIN ( SELECT ComputerName, MAX(SystemSync) max_date FROM devices_staging GROUP BY ComputerName ) b ON a.ComputerName = b.ComputerName AND a.SystemSync = b.max_date And the results I get are correct. How do I move these results to another...

    icelander5 pointsBadges:
  • Export SSRS Report to Microsoft Excel

    Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.

    AmitJoshi14310 pointsBadges:
  • Export SQL Server database to SQL script

    For my SQL Server database, is there a way to export it to an SQL script? I need something like mysqldump. It would take the database's name, and create a script that will remake the tables, data, stored procedures, etc. Does anyone know of anything like this?

    ITKE434,595 pointsBadges:
  • Add SQL Server Agent jobs to Microsoft Excel spreadsheet

    I have a list of SQL Server Agent jobs and I need to add them to my Excel spreadsheet. The problem is that I don't want to do this manually. Is there a T-SQL command that would create this list for me?

    ITKE434,595 pointsBadges:
  • SQL Server log file is too big

    We are using SQL Server 2008 with full recovery model, the database size is 10 GB and the log file is 172 GB, we want to clear up the space of the log file internally, we did transaction log file backup it should be clear up , but it still 172 GB. What to do?

    mimiKh5 pointsBadges:
  • SQL Server: Should I have auto-shrink turned on?

    This is a basic SQL Server question, but for my database, should I use the auto-shrink option. But someone told me it's not really secure. Is that true?

    ITKE434,595 pointsBadges:
  • Can I add a dependency to a Windows Service?

    We currently have a Windows Service that's using a SQL Server database. I don't have control over it (my boss does) but he asked me to add a dependency so it starts up after SQL Server starts up. Can I do this? Is there a specific tool I have to use?

    ITKE434,595 pointsBadges:
  • How to fix this error in SQL and Excel?

    When I execute the T-SQL, I want to copy result and paste Excel sheet but the numbers had problem. For example in SQL, 4.2900 but when I copied Excel 42.900. Can you help this problem please?

    edwinjhoffer3,355 pointsBadges:
  • SQL stored procedure is taking too much time to execute

    One store procedure is working fine at one location. But the same store procedure is taking too much time to execute in different location on same network. What would be reason for this and how to reduce response time?

    mukeshkumar1230 pointsBadges:
  • How to open SQL Server 2008 after completing installation

    I have installed SQL Server 2008 R2 and how can I start with it after this?

    chinchu5 pointsBadges:
  • How do I restore my SQL .bak file over the existing database?

    How do I restore my SQL .bak file over the existing database? Do I need to delete what is there already? On a new Windows installation I need to restore our production SQL database from a .bak file. What steps do I need to take? Can I overwrite data or do I need to restore to a fresh database?

    ITKE434,595 pointsBadges:
  • Call a stored procedure on a SQL Server from my RPGLE source using JDBCR4 service program.

    Something is going wrong while setting up the connection environment (ZBCCNNPF). Can someone explain me which parameters have to be set in which way to make this process work? Kind regards, Ton Konings.

    TonKonings196215 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.

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

Following