• Read Only Table

    I create a table in sql server 2k5, the script is look like this: CREATE TABLE [dbo].[tb1PmtD]( [PmtDLU] [int] NOT NULL, [PmtDInvLU] [int] NOT NULL, [PmtDAmount] [money] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[tb1PmtD] WITH NOCHECK ADD CONSTRAINT [tb1Pmttb1PmtD] FOREIGN KEY([PmtDLU])...

    Ipong40 pointsBadges:
  • SQL Database Migration Process

    Hello, I would please like to know if someone could help me out with a database migration issue.I have a server and i need to migrate all of my data on my current database to a new database.It seems that the new database might be a little different in structure and the tables generally so i would...

    Absorbed5 pointsBadges:
  • Error message on versioning in SQL Server 2005

    I’ve received this error message on SQL Server 2005: "Version store is full. New version(s) could not be added. A transaction that needs to access the version store may be rolled back. Please refer to BOL on how to configure tempdb for versioning." What exactly is version store, and do I need to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL 2000 and 2005 Offline Table Reindex Determination

    Hello, I have prcessed SQL 2000 offline reindexes in the past for specific tables when there was scheduled downtime, but I was wondering if there is a tool or script that I can run for a specifc SQL database to determine which tables in the database would need to be reindexed. I do not want to...

    Bankerdba5 pointsBadges:
  • Can we use a central database for distributed CRM software?

    Can I implement a central database (Microsoft SQL Server) with distributed CRM application servers in remote locations? Due to large number of Outlook CRM clients, we'd like to try this model of distributing CRM application servers in remote major data centers with a single SQL Server. Thank you.

    CRM Ask the Expert250 pointsBadges:
  • Running a stored procedure in SQL Query Analyzer or as part of a SQL job

    I have been trying to run a stored procedure in SQL Query Analyzer and as a step in a SQL job. If I run it in Query Analyzer, it takes less than a minute, but it takes considerably longer if it is run as a step. I use SQL Server 2000. Why would there be so big a difference?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server Error while creating db from DUMP

    Hi, We get the following error while trying to create a new db from a dump which contains the MDF and LDF files. Appreciate if anyone could let me know on what could be the reason for this error. The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at...

    Vidukarth25 pointsBadges:
  • Error accessing Oracle data using SQL job

    I have a DTS package that use the MS OLE DB provider for Oracle. The DTS package executes stand alone; but when placed in a schedule job, it won't run. This was working; but quit after I had detached some databases to copy them. After re-attaching them, the jobs would no longer run. I have logged...

    Randym1,740 pointsBadges:
  • Moving a DTS package to SQL Server 2005

    I would like to move a DTS package created in SQL Server 7.0 to SQL Server 2005, as we are in the process of migrating the server. Can anyone offer me advice?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Cold Fusion 8.0 + Memory Issues

    Hi, I am hosting a cold fusion application which was developed in version 6.1 in CF8 server. There is a application variable which is set to a value of 1000 in the Application.cfm and we invoke components and have a loop till the max value of this variable which runs a sp on SQL Server2005. The...

    Vidukarth25 pointsBadges:
  • query of query errors

    I have a runtime query of a query error as below. java.lang.String cannot be cast to java.util.Date But the output format is correct and is in date. This application was developed in coldfusion 6.1 and sqlserver2000. But now we get this error when it was migrated to coldfusion 8 and sql server...

    Vidukarth25 pointsBadges:
  • Error message when connecting SQL Server database to ASP.NET

    I’ve been getting the following message when connecting my SQL Server database to the ASP.NET application: "Login failed because, under default settings, SQL Server 2000 does not allow remote connections." What might this mean?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Unable to open a SQL application on two different machines

    If someone in our office opens a SQL application, no one else is able to open it. We all receive the message: “Another application is using this file.” How can we solve this problem?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Setting aside code for 12 databases in separate database on SQL Server

    I have 12 databases on my SQL Server, one for each month of the year, and I have almost all the same stored procedures in each database. This architecture is hard to maintain, because you have duplication of the code, and a modification must be made on all the databases. Is there a way to put all...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Making a query for a SQL Server database

    I would like to make a query for my SQL Server database to specify that only unmatching records should be displayed from both tables. Can you help me in doing so?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Create Stored Procedure based upon existing Stored Procedure

    How do I create a Stored Procedure based upon an existing stored Procedure in SQL Query Analyzer V 8.00.760

    Trainingit20 pointsBadges:
  • Is there a built-in stored procedure in SQL Server 2000 that returns the sql table structure of XML format

    i have a xml file.i want to insert the contents of the xml file into a table in sql server 2005.

    Mitha10 pointsBadges:
  • i want to send sap idoc to sql server 2005

    I have one application in sap which takes sap data into idoc and want to send in sql server 2005

    Vimalshah5 pointsBadges:
  • Windows 2003 server hangs after reboot

    Hi All, We have a Windows 2003 server ( Model: HP Proliant DL385 ) running SQL Server 2000, in which we always experience issues. The issue is that Windows Server 2003 hangs after every reboot. Sometimes, it has also bluescreened and has created a memory dump. First time, when it bluescreened, the...

    jeevan930 pointsBadges:
  • Saving Query results into Excel format

    How can I save query results into .xls format directly from Microsoft SQL server Management studio?

    Preetg5 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