• Too many XP profiles

    We have over 100 XP local profiles on our library machines. The users use thier own respective usernames to log onto our domain. We dontnor plan on using roaming profiles. Is there a way to delete the local profiles quickly without doing them one at at time? Is there a way to limit the number of...

    Kellarm0 pointsBadges:
  • Oracle to SQL Server Migration – CURSOR type conversion

    When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.

    Kumar937825 pointsBadges:
  • SQL Integration with Oracle10g

    have created a link between our Oracle DB and SQL server db it was succussfulty created and i was able to select data from oracle table using SQLServer. then i have created a view in sqlserver using this link to read from Oracle, the view was created create view dah_test as ( SELECT count(*) as...

    Kmadani35 pointsBadges:
  • Error message in Reporting Services on SQL Server

    I am trying to post a report on Reporting Services on SQL Server, but I keep receiving this error message (“salesexpo1” is the name of the table): An error has occurred during report processing. Query execution failed for data set 'rSellingEP_AV'. Invalid object name 'Saleexpo1'. What might...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Moving from single server to multiple servers

    Hi all, We have a Single Windows 2000 server (Back office edition, configured as a Primary domain controller). It has SQL server 2000 running, which serves a bespoke database application. The server is also used as a simple fileserver for documents, etc... We do not use Exchange Server. I need to...

    Michaeltwozero0 pointsBadges:
  • SQL 2005 to .XML

    How do I automate 2 sql servers to replicate .xml files

    Camofa5 pointsBadges:
  • sql server 2005 slow

    Several times during the day SQL Server 2005 Express is becoming very very slow (actually freezes), even if there was no activitry at all. After restart it is normal again for a couple of hours, then freezes again.

    Vad20 pointsBadges:
  • Why sqlcode error=100 comes ?

    sqlcode error=100 comes. The required fields are being populated in table. Still why i am getting this error ?

    NAVIN5 pointsBadges:
  • How do you install SQL Server Enterprise Manager?

    how can installed SQL Server Enterprise Manager,

    0805198220 pointsBadges:
  • DTS Package Schedule runs only once, Status shows executing

    Hi, I have set up a DTS Package and schedule it to run every 2 minutes (to prove it will run regularly). Unfortunately the package only runs once. The process only takes a few seconds. The job status shows "Executing Job Step '1 DTS Package1'" Is there something I'm missing? Gabs

    Gabs15 pointsBadges:
  • SQL Server 2000 Log File Size is increasing

    I have a sql server 2000 where log file is increasing very fast. My mdb file is 600 MB and Log file 6GB. How can i reduce the size of the file. Shrinking the file is not working.

    Ynaina5 pointsBadges:
  • LDF size reduction

    How can reduce *.LDF size i have run the command dbcc shrinkfile (Filename,1) but could not reduced.

    SAP Cum IT35 pointsBadges:
  • ASP.net profile object

    I attempted to use the profile object as described in a training video; however when I hit f5(to execute the app in debug mode) the browser begins to opens up but I end up with the debugger telling me it cannot open SQL Server. According to the video the Profile object will default to "string" if...

    Alemap5 pointsBadges:
  • how to Configure mail profile in MS SQL 2000 ?

    I have a requirment to recieve mail from my SQL server 2000 when ever a JOB in my SQL SERVER Agent fails ,I have my MAPI configured and SMPT too but in the SQL SERVER AGENT Properties window , the Mail profile is not enabled , how do i configure this , I want it in SQL SERVER 2000.

    SRI HARSHA10 pointsBadges:
  • Setting up failover notifications in SQL Server 2005 cluster

    We are new to clustering. We have recently successfully implemented a four-node (active/passive config) SQL Server 2005 cluster. How can I be automatically notified when a node within the cluster fails over to the passive standby or other node within the cluster? Thanks, JGalt

    JohnGalt35 pointsBadges:
  • Command to display virtual nodes hosted by a physical server.

    We have a four node (N+1)SQL 2005 cluster. From a DOS prompt, is there a command that can be run on each of the physical servers that will show you if it is hosting one of the virtual nodes of the cluster?

    JohnGalt35 pointsBadges:
  • Emails go straight to the Task Folder

    In outlook 2007, some emails received are being moved straight to the task folder rather than the inbox. There are no rules set in Outlook causing this to happen. Any ideas? Is this a bug?

    Lindsey5 pointsBadges:
  • Error message in Query Analyzer on SQL Server 2005

    I am trying to run the following command in Query Analyzer on SQL Server 2005: use temp alter user [MY-LP79EFIWXO93login_a] with login = [MY-LP79EFIWXO93login_b] However, I keep receiving this error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. Why might this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • i5/OS vs MS sequel server 2005

    The powers that be would like to replace our 20 year old i5 home grown billing system with a .NET solution (partial) over MS SQL Server 2005. How do we convince the powers that be to keep & improve what they have or should we just surrender and start taking .NET classes?

    Soooyeah5 pointsBadges:
  • Overlapping data on a merge replication between three SQL Servers

    We have a merge replication between our three SQL servers at three different locations. One is the publisher and two are subscribers, and we have a primary key on a table (a unique field with is auto-incremental by one). On the publisher’s server, if the user creates a new order, the table...

    SQL Server Ask the Experts2,585 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