command timeout

i getting timeout on following .net code:

static void main(string[] args)  {  	string sconn = "data source=myserver;initial catalog=mydb;integrated security=true";  	using(var conn = new sqlconnection(sconn) )  	{  		conn.open();  		var cmd = new sqlcommand("dbo.sptest",conn);  		cmd.commandtype = commandtype.storedprocedure;  		cmd.commandtimeout = 1000;  		sqlcommandbuilder.deriveparameters(cmd);    		var par = cmd.parameters[1];  	}  }  

query timeout occurs stored proc added or altered after database restored test server. queries fail, eg cmd.executenonquery(). used deriveparameters example.  when testing procs untouched since before restore, queries work fine.  cause this?

@joseph: nothing hints or stats. test failed on empty proc.

i created new database scratch. set db options follows:

• set quoted_identifier on
• set arithabort on
• set numeric_roundabort off
• set concat_null_yields_null on
• set ansi_nulls on
• set ansi_padding on
• set ansi_warnings on
• also ansi null default on

i created new test proc. after changing connect string refer new db, test worked fine.  went restored db on test server, changed db options, , in new query window, dropped , recreated test  proc had failed.  time worked fine.  i’ve never had problem restored db before, , still don’t understand caused problem, appears well.

SQL Server  >  SQL Server Data Access