• SQL 2005 keeps rebooting

    My SQL 2005 server keeps rebooting. I can not figure out why. I get an NT SUbsystem message and then a 30 second countdown. This happens 20-40 times in a day. How can I fix it? I can not even run a virus scan to completion. Windows server 2008 SQL 2005. McAfee 8.7.1.

    Troubleshooter24755 pointsBadges:
  • SQL Server 2005 database design

    What is 1*,o* 1..1,1..*,0..*,1..* in databse design,i have no exact idea about this,need help. 

    Shamu75 pointsBadges:
  • Getting password when we know Product Code and Serial in Pl/SQL Developer

    Can any one please tell me how to know the current password of my pl/sql developer which i am using currently? I know my product code and serial Send me the procedure Thanks in advance PSR.COM

    PSRDOTCOM5 pointsBadges:
  • When creating a web application in Sharepoint 2007, where is the data stored?

    hello guys :) when I create a web application on sharepoint 2007...where does t he data and documents that am uploading be saved?? in that path that I have set ?? or on SQL Server that I have installed on C: drive thank u in advance

    IT19875 pointsBadges:
  • Process ID 174:102 owns resources that are blocking processes on Scheduler 2.

    Looking for solution to Process ID 174:102 owns resources that are blocking processes on Scheduler 2. We recently installed our Lucent Vitalnet app with SQL 2000.  it runs fine for 2-3 days, then the app stops when the above SQL error message occurs.  Rebooting the server temporarily fixes the...

    Meken1abe5 pointsBadges:
  • tutorials

    hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.

    Mmm5550 pointsBadges:
  • Trouble installing SQL Server 2005

    I have installed SQL2005 as default instance on a server that already has 2000 as the default. how can I remove sql2005 safely and reinstall 2005 as a named server.

    Pmister5 pointsBadges:
  • How do I use primary keys in SQL server?

    I have a table called course,and course_id is primary key in this table. I created another table subject.I mapped these 2 tables by course_id as foreign key,I  created another table teacher,i want to map this with subject, only subject_id to teacher_id mapping is required,how i mapp this,can i...

    Shamu75 pointsBadges:
  • How many processors can SQL Server 2008 R2 support?

    How many processors can SQL Server 2008 R2 support?

    ITKE413,500 pointsBadges:
  • Can I restore a SQL 2000 backup to a new SQL Server 2005?

    Can I restore a SQL 2000 backup to my new SQL Server 2005? Will I have to perform any other steps or can I do a simple backup and restore? Windows 2008 Server.

    TeachMeIT975 pointsBadges:
  • Upgrading from SQL 2000 to SQL 2005

    Will you need to purchase a new server to upgrade SQL 2005?

    Noles15 pointsBadges:
  • xp_fileexist workd in Query window but doesnt in stored procedure

    Hello, I am running on SQL server on my local PC . I am singed onto the PC using a network user. This probelm happens if the SQL server service runs as either Local system or network service. In the server management studio if I go to a query window and enter Declare @result int exec xp_fileexist...

    Kendo5 pointsBadges:
  • Running Profiler, an update statement show reads but no writes?

    Example: last 3 columns are write, rowcount,reads [table] [tbody] [tr] [td]75072[/td] [td]SQL:StmtCompleted[/td] [td]UPDATE UserHdr SET LastActivity = '29-Aug-2010 01:23:24 AM' WHERE UserKey = 'M'[/td] [td]205[/td] [td]2010-08-29 01:23:24.393[/td] [td]The FactorSoft Program[/td] [td]12695[/td]...

    Manodak15 pointsBadges:
  • Error during SQL Server 2000 installation

    When I attempt to install SQL Server 2000 using Windows XP Service Pack 2 for IT Professionals and Developers, I encounter the following error: "Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system. Only client components will be available for...

    SQL Server Ask the Experts2,585 pointsBadges:
  • XML Schema Problem

    hi I have an xml file <UserRoleConsumers> <UserRoleConsumer> <ConsumerID>67</ConsumerID> <RoleConsumerID>89</RoleConsumerID> </UserRoleConsumer> <UserRoleConsumer> <ConsumerID>45</ConsumerID> <RoleConsumerID>78</RoleConsumerID>...

    Dilipd0065 pointsBadges:
  • SQL Insert Error Against Runtime Control Error in FLP

    am trying to insert into sql-2000 database my code is: StringBuilder sb=null; sb=new StringBuilders; sb.Append("Insert into dummy(name,amount) values"); foreach(Control ctl in this.FlowLayoutPanel1.Controls) { if( ctls.Name.Contains("tb") && ctl is TextBox) { sb.Append(ctl.Text); } }...

    Maheshwag260 pointsBadges:
  • Parameter Date Conversion in SQL 2000

    my code is : string sql="insert into dummy(date)values(@date)"; sqlcommand cmd=new sqlcommand(sql,con); cmd.parameters.add("@date",sqldbtype.datetime).values=maskedtextbox1.text text; cmd.executenonquery(); the problem is it's throw and error like  conversion of varchar to date; Note :- my demand...

    Maheshwag260 pointsBadges:
  • SQL Server 2005 error after development

    I developed an application and when we moved it to the clients site we started getting this error from their SQL 2005 box: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings...

    TeachMeIT975 pointsBadges:
  • SQL 2008 R2 CPU Count

    The SQL 2008 R2 Std specification says it can use up to 4 cpus.  If I have two quad-core xeon processors.  Would this count as 8 or 2?

    LeeHerr15 pointsBadges:
  • Connect JasperServer and Sql 2008

    i tired these steps : # Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver # Extract to a good location. I chose c:program files to extract to. # Copy the sqljdbc4.jar to your installation directory which by default is: c:program...

    Edkettavan5 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.

Thanks! We'll email you when relevant content is added and updated.

Following