• Identity Reseed SQL Server 2005

    I have the following table create table SubscriptionTrans ( transid bigint identity(9223372036854775805,1), transdate datetime ) Run the below insert script 3 times. insert into SubscriptionTrans select getdate() You'll get below error Msg 8115, Level 16, State 1, Line 1 Arithmetic overflow error...

    Jsql155 pointsBadges:
  • sql server 2005 local connection

    I have installed sql server 2005 in local machine and I am trying to connect to that locally. but it is not working. I tried both istalling as default and also by naming as instance. sql server configuration manager shows the services running but I can not connect to in management studio.

    Hashki20 pointsBadges:
  • Deadlock issue in SQL Server 2005

    I have encountered a deadlock issue in <A href="http://searchsqlserver.techtarget.com/topics/0,295493,sid87_tax301323,00.html”>SQL Server 2005</a>. According to the trace flag 1204 report, the following two queries are causing the deadlock: 1. Simple insert statement INSERT INTO...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL server as data source for OBI EE

    hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source. My ODBC was succesful and i can import from that database but i get following errors when...

    NewIT5 pointsBadges:
  • SQL server 2005 to SQL server 2008

    I am following using sql server 2008 but following some lessons written by BOB Taybor. Is MyCompany.mdf for 2005 abailable in 2008 format?

    Standaman15 pointsBadges:
  • Restoring a deleted table in SQL Server 2005

    How do I restore a deleted table in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • MS SQL SERVER (BKUPEXEC) Services wont start

    Hi ALL, Background: Windows 2003 Server returned the error missing or corrupted file after the server was found OFF due to possible power problems (Server is on a UPS). Ran a CHKDSK on the server and it fixed the missing or corrupted file problem and server now up and running. Is seems that my SQL...

    Ahmyown30 pointsBadges:
  • Database maintenance task (full back up) fails on SQL Server

    Hi My daily maintenance job fails due to the below error from last 20 days regularly Executing the query "BACKUP DATABASE [shipment] TO DISK = N'D:\backup\shipment.bak' WITH NOFORMAT, NOINIT, NAME = N'shipment', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Write on...

    GIG240 pointsBadges:
  • How to move SQL Server databases to a new drive.

    I have installed all my databases (nice_cls and nice_audit) in D:/ drive and need to move them to E:/ drive.

    KD31355 pointsBadges:
  • Mirroring from a production environment to a DR environment

    I have a production environment and a disaster recovery environment and each of them have two SQL 2005 servers in a cluster. We have two LANs -- the first one is our standard/everything LAN and the second is a Service LAN. We are looking to mirror from our production environment to our DR...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Accessing SSRS from a Web server

    We have a Web server at our collocation site with public access. On the server, there is a simple menu with links that call SQL Server Reporting Services. We also have another server -- with SQL Server 2005 -- that contains our database and reporting services. This one is only on the internal...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Replacement of CROSS APPLY statement

    1. I am running query in which cross apply operator is used 2. That same query exceutes more than 10 times 3. Due to cross apply it increase the time to excute the report

    Archanaraghulohe10 pointsBadges:
  • Data integration

    I want to import a table from dbase III to Sql server 2005. I also want to automate this process and run it after ever one hour. Is there a simple way to do this task.

    ShSyed5 pointsBadges:
  • Increasing Processors of SQL Server 2005 in VM

    Hi, We are about to increase the number of processor on a Virtual Machine from 1 to 2 for one of our clients, will this affect the SQL Server 2005 which installed on the Virtual Machine, just wondering if are any issues to look out for, and if anyone has done this before? Thanks.

    Db23290 pointsBadges:
  • Error backing up with SAP transaction DB13

    The following error message occurs when I attempt to backup with SAP transaction DB13: ***************************** SQL Job information ****************************** Jobname: SAP CCMS Full DB Backup of master,RPD [20090620094326-6-094326] Type: TSQL DB-Name: RPD For Run: 20090620 09:43:26...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is it possible to connect from the SSIS Analysis Services task to SQL Server 2000 Analysis Services?

    Using the Analysis Services Processing Task in SSIS 2005, we are trying to connect to SQL Server 2000 Analysis Server cubes. While we are able to successfully create an Analysis Services connection, when we try to configure the task and specify the connection created above, we receive the following...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 Processor Licence

    Hi All, Just wondering what happens when an additional licence is purchase for a SQL Server 2005 that is currently running with one processor. IE. How do we purchase the processor licence for our clients, what to do when we purchase this licence? Thanks in advance.

    Db23290 pointsBadges:
  • Adding processor to SQL Server 2005

    Hi All, We are about to add an additional processor to one of our SQL Server 2005, just wondering if there are any downside to doing this and if this a low risk task to do, i.e. we won't encounter any problem after doing this? Thanks.

    Db23290 pointsBadges:
  • Problem with Download-only Articles in New Subscription of Merge Replication

    Hi, I have a Publication in a SQL Server 2005 Merge Replication with Mobile Devices. To explain my problem follow this example: I have an Article in Download-Only with 100 rows. When I start new subscription I look, in the Replication Monitor, that Process start with "Insert 300 rows" for this...

    Eclipses5 pointsBadges:
  • Which version of SQL will work best?

    We have a small but critical application that is accessed by about 30 - 40 users on our network. We want to set up a SQL environment to run the database, but the application accessing the data is locally installed on each users machine. Users will access the db over our network using an ODBC...

    LeninKAF5 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