• Enterprise Manager problem

    Any nvarchar column content is shown as <binary> when using table browsing or view from enterprise manager in SQL Server 2000.

    Jadwiga10 pointsBadges:
  • Leak rate trigger

    If I have a cell that has >=50 AND another that has >=15 then I want the cell with this formula to read YES, if either of the two cells are not >= those numbers then the cell should read NO.

    Adam435 pointsBadges:
  • Optimize the query in sql server

    CREATE VIEW [dbo].[vwResults] AS SELECT r.ResultsPK, b.PersonID, dbo.ltcPerson.FirstName, dbo.ltcPerson.LastName, dbo.ltcPerson.PersonFriendlyID, b.DateCreated, b.FormName, r.FieldName, r.ValueString, r.ValueNumber, r.ValueDate, r.ValueTextInt, r.ValueBit, b.UserID, b.BatchID, b.ParentID, r.Active,...

    Rajupatil5 pointsBadges:
  • Purpose of creating SQL Server stored procedures at run time

    Hi Experts, I am a programmer in SQL. Please explain me the purpose of creating stored procedures during run time and it's effects on performance and memory. Please provide me if there is any best alternative for this. Thanks in advance

    Skothamasu15 pointsBadges:
  • remove password from SSIS package

    How can I remove the password from a password protected SSIS package? I need to access its source code, but as soon as I try to open it I get the window: Enter Password. I don't know the password. This package was created by an employee who left the company a couple of years ago.

    Rmk3255 pointsBadges:
  • runScript() returning null

    Hello to all of the participants. This is my first blog. This is a program to execute .sql file which contains bunch of sql statements. I have used iBatis package it's compling and executing with out any mistakes, but resulting nothing. I have tried in both 2.3 and 2.0 release also. Can any one...

    Querier5 pointsBadges:
  • Bulk Insert with collation change

    Hi, One of our client wants to change the collation of the database and the collation of the columns from SQL_Latin1_CP1_CS_AS to SQL_Latin1_CP1_CI_AS to match the SQL Server setting. So we are moving the data from one database to another database on the same server. We are re creating the database...

    Db23290 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:
  • Find exact point where SQL Server 2000 job fails

    I am running an SQL Server Job, that executes a stored procedure with about 900 commands (mostly insert commands). The job was working OK, but suddenly fails, due to erroneous data (error message : overflow in converting numeric data to dadatype numeric !!). How can I find the exact point (command)...

    fbellos35 pointsBadges:
  • Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS

    How to Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS

    NET20085 pointsBadges:
  • Error inserting into table with identity column

    I have 2 stored procedures. Both insert records into table variables, and each of those table variable has an identity column. One procedure executes and the other gives an error telling me that I am explicitly trying to insert into the identity column (which I'm not). Here is the code from the 2...

    Bleeb45 pointsBadges:
  • Alter SQL table

    hi i have a set of data number | code 1 | abc 2 |ff 3 |aa 3 |bb 4 |cc 5 |dd 5 |ee and i'm wondering if there is a way to convert this data so it looks like number | code1 |code2 1 | abc |null 2 |ff |null 3 |aa |bb 4 |cc |null 5 |dd |ee thx

    Lazy16755 pointsBadges:
  • SQL 2000 Upgrade

    I am upgrading four sql servers 2000 to 2005. If i do an inplace upgrade to the default instance would i need to change any passwords for linked servers, services or sql accounts?

    0 pointsBadges:
  • How to make VB6 and SQL Server 2000 multiuser and client-server?

    how to make vb6 and sql server 2000 multiuser and client server??i use adodc for connection please tell me the source code. thx

    Chibi5 pointsBadges:
  • Running a lengthy query on SQL Server 2005

    We are running SQL Server 2005 and Windows 2003 Server. I ran a query in SQL on a PC with one dual code processor and 4GB and it took six hours. However, we ran the same query in SQL on a brand-new server that has 4 quad core processors and 32GB of RAM, and it took 12 hours. Why would this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server query

    how would I write an SQL statement to view the number of purchases for each month in the year of 2008..?

    Hodhod5 pointsBadges:
  • WSUS Server multiple instances of computers listed.

    I am very new to the Windows update server (WSUS). I installed and configured the update server and everything seems to be working. I added some settings in my group policy and applied the GP to an OU and went on my way. The clients started to appear in the list of workstations on the WSUS server;...

    Skepticals0 pointsBadges:
  • Making two records into one

    I was not sure on how to word the title of my questions, so it is better if I simply give you my query and result: SELECT DISTINCT PJ.EMPL_NUM, (CASE WHEN PAY_TYPE = 1 THEN RATE ELSE 0 END) AS REG_RATE, (CASE WHEN PAY_TYPE = 3 THEN RATE ELSE 0 END) AS OVR_RATE FROM dbo.tblPayrollFlashJobDetail AS...

    Fscopel15 pointsBadges:
  • DBCC CHECKDB

    before runing DBCC CHECKDB WITH repair_allow_data_loss, How can i know what table and data that will be deleted

    Sreenu125 pointsBadges:
  • SQL 2005 SSIS Package to load table from positional flat file

    I have a positional flat file which I need to load contents into a SQL table. I've created an SSIS package and will need to call a VB script to parse the file but since I'm new at VB and SQL I need some assistance creating the VB script. There are 4 fields in the table I need to populate. The first...

    Dacker5 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