• Copy SQL stored procedure from local to live database

    Hello, I want to copy multiple procedures from a local database to a live database?

    vikasbhatt25 pointsBadges:
  • How do insert many images (BLOB) into a SQL Server table

    How do I insert several images (BLOB) in to a SQL Server table?

    cjohnNewVIc5 pointsBadges:
  • Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!

    We're always looking for great resources to share with the community, so here's your chance to share what's in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you'll never forget. Don't have a...

    MelanieYarbrough6,345 pointsBadges:
  • SSRS line chart color

    I have PV and high two series on one chart. I need to compare PV vlaue with high, when PV value is deviated to high then set the color red. I wrote the expression as "IFF(PV<=HIGH, RED, GREEN", for which I got the color but there is a small problem. For example: PV = 20, 25, 28, 35, 37, 39, 28....

    anu4kumari5 pointsBadges:
  • Migrate data from MySQL to SQL Server

    Hi all SQL Server experts, I'm new to SQL Server. Can you please help me out from I want to migrate data from MySQL to MS SQL. What steps do I need to follow? Can you please tell me in step-by-step? Thanks in advance.

    nasarbabu30 pointsBadges:
  • Execute SQL SELECT via RUNSQLSTM error

    Trying to execute SQL-statement "SELECT * FROM mylib/myfile" give errormsg SQL9010. Some say that SELECT is not supported with RUNSQLSTM, but IBM command parameter text indicates otherwise. Is SELECT supported and what am I doing wrong?

    DanTheDane2,555 pointsBadges:
  • 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!

    srithea240 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!

    ITKE405,890 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...

    ITKE405,890 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!

    ITKE405,890 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,205 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.

    ITKE405,890 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?

    ITKE405,890 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?

    ITKE405,890 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?

    ITKE405,890 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