SQL Server Tag Directory

Browse Alphabetically:

Featured SQL Server Questions

  • Backup and restore SQL Azure database

    I have a SQL Azure database that's roughly 40 GB and when I'm backing it up and restoring it, it takes roughly 6-8 hours. Is there a way to make it faster? If so, what's the process?

    ITKE409,490 pointsBadges:
  • Reset password for SQL Azure account

    I just created a new SQL Azure account. I'm able to get into the 'manage' page as an administrator but there's one big issue: I forgot the password to one of the databases! I'm looking to reset that password - is there a way to do that? Thanks!

    ITKE409,490 pointsBadges:
  • Copying SQL Azure database to development machine

    I'm looking to copy my SQL Azure database to my local development machine. I already have a development database in the cloud but don't want to pay for it anymore. I have copied by production database to the new development database but I need that same one on the local machine. How can I go about...

    ITKE409,490 pointsBadges:
  • PowerBuilder 11 in SQL 2008

    We are seeing performance issues with our PB 11 app after SQL 2005 DB was migrated to SQL 2008. We did not change any code just the connection profile. From: [Profile APP] DBMS = SNC SQL Native Client(OLE DB) Database=database UserId= DatabasePassword= LogPassword= ServerName=SQLServerName LogId=...

    Lstadler5 pointsBadges:
  • What are the best tools for SQL monitoring and SQL diagrams?

    we have SQL 2008, and looking for tools to monitor sql and get sql diagrams. do you know any good tools?

    Persa5 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:
  • Documentum Stops Processing

    During import of Excel files, documentum just stops processing & disappears. There's nothing in the log, other than 49 files were processed & no errors. EMC cannot duplicate the error in their lab. Installation gone awry? CC me at morgans@southcoastplaza.com with solution.

    CMSteven5 pointsBadges:
  • Would SQL Azure be PCI DSS compliant?

    I'm using a separate Windows Server that is PCI-DSS compliant, is it still compliant if I had SQL Azure hosting the backend? I'm currently only storing permitted values. Thank you very much!

    ITKE409,490 pointsBadges:
  • How to automate SQL Server database backup

    I've been generating SQL Scripts on a daily basis so we can have a backup our SQL Azure database. But we're working to do this on an automated level. Is there a way to do this?

    ITKE409,490 pointsBadges:
  • Netgear storage with SQL 7

    I have a database stored in my Netgear storage central. When I start my PC, it runs SQL 7 before the drivers for the Netgear, so my database can not be found. What can I do?

    Simonedp5 pointsBadges:
  • Parameter in select statement

    Hi, I need to pass a parameter into a stored procedure which values are dynamic always. Executing a variable which having the Select statement. Following query working fine. BEGIN DECLARE @strQuery NVARCHAR(MAX) DECLARE @CountryId INT DECLARE @CityId INT SET @CountryId = 2 SET @CityId = ' AND...

    Plugsharma40 pointsBadges:
  • SQLRPGLE – How to override data set data structure at run time

    I currently have an SQLRPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to make this...

    NarkedDiver20 pointsBadges:
  • SQL – Pass the result of the first query as the second query select column name

    I want to pass the result of a SQL query as the column name in another query eg. (note there will be a single result for the first query): SELECT CASE WHEN fld_type1 = 'A' THEN 'VAL_ALPHA1' WHEN fld_type1 = 'D' THEN 'VAL_DATE1' ELSE 'VAL_NUM1' END AS FIELDNAME FROM TABLE1 I want the result of the...

    Chris12325 pointsBadges:
  • SSL on SQL 2005 Express

    Hi, I am attempting to encrypt the connection string to/from my database server. I cannot seem to find guidance on where [what directory] to place the CA certificate. I am working with a Windows Forms application that call to the data store. Any assistance will be appreciated.

    ETCGMan40 pointsBadges:
  • Migrate MySQL database to SQL 2005

    We are looking to migrate from MySQL to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?

    Karl Gechlik9,860 pointsBadges:
  • Running a disk check on Windows 2000 Pro

    When running a disk check on a Windows 2000 professional computer it creates files in the root of the C: drive. What are these files and can they be used to restore data?

    NewnanIT1,110 pointsBadges:
  • SQL 2005 Database Compare

    If there a way to compare two similar database to find where a Stored Procedure is different between the second database. Different in it not there or the Create Date or Modify Date is different?

    SQLNovice15 pointsBadges:
  • SQL Server Disk Alignment

    What size should I set the Starting Partition Offset on the disks when running SQL Server 2005 32-bit enterprise edition, should it be 1024KB or 64KB?

    Rick Martinez585 pointsBadges:
  • Limit SQL Admin Access to a single DB

    I need to set up admin access on a MS SQL server but limit the access to a particular DB.

    Cybx10 pointsBadges:
  • Looking for Backup solution for VMware environment

    We've started adding VMware servers to our data center, and we need a backup solution that works. We'll have a mix of ESX4.0 and ESX3.5 hosts along with vCenter 4.0. Host will have Windows 2003, Windows 2008, RedHat 4.x and 5.x. Some hosts will have MS SQL 2005 and Oracle DB. We have TSM deployed...

    ITKE409,490 pointsBadges:

Browse Alphabetically:

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