• SQL Express 2005 query times lagging

    I execute some simple queries on my own system's sql server express 2005, the executions time is under 1 second but when I execut the same queries on our server's sql server express 2005, the queries execution time is about 3 seconds or more and I don't know why. both of the systems have the same...

    Reza838325 pointsBadges:
  • 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?

    ITKE346,360 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:

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