Programming SQL

SQL Server 2000 on Win 2008
Hi, We've installed the SQL Server 2000 on our Windows Server 2008. However, we can't connect SQL Query Anylyzer to the SQL Server 2000 on the Win2008. Ho do we fix this problem. Thanks for help. Jason ... 6 Jan 2010 09:51

Can't use Sql server when using forms authentication
Hello! I do some exercise from a book which work if I run from VisualStudo(VS) but doesn't work when run from IIS. This exercise will use forms authentication Here is some background information: I use windows XP pro with a Sql Server express 2005 database. I have also Sql Server Management Studio Express I ... 31 Dec 2009 14:21

sp default permissions
Is there a way on a SQL Server 2008 database to set default grant execute permissions whenever a new stored procedure is created on that database? Thanks. David ... 24 Dec 2009 18:25

Wierd Performance Question- Please help!!
Hi, I have a stored procedure and in that one update statement is taking 36 minutes when ran thought the client application. But, when i profiled and run those statements in the batch in management studio it gives me results in less than 5 minutes. Please let me know your tips to trouble shoot this. th... 23 Dec 2009 18:34

read cobol comp-3 field
Hi, Anyone here knows how to read a flat file with Cobol comp-3 field from sql server. Thanks, ... 28 Dec 2009 12:58

tsql to change oracle pswd
Is it possible to use tsql or sqlcmd to change an Oracle password? ... 24 Dec 2009 17:20

how to sum a text field with commas
I have a field that contains values like "1,3,0,0" and "2,0,0" and "1". I need to sum those values within the field. The field can have up to 100 numbers seperated by commas. How can I do sum them? so in example 1 "1,3,0,0" I would want it to say 4 example 2 "2,0,0" I would want it to say 2 example 3 "1" I... 24 Dec 2009 02:09

Connection string to SQL Server to 2005
Hi, We have a software that we need to install on our users machines. During the installation process looks like it is trying to create a datbase in our sql server 2005. Here is the connectiong string that is generated by during the insallation process Persist Security Info=False;Integrated Security=true;Ini... 24 Dec 2009 06:25

Sql 2008 - Failover & Domain
Hi all, i'm installing a sql 2008 failover cluster. I haven't a microsoft domain controller in this network. I cannot to install sql 2008 failover cluster in a domain controller! So, I could join my server in a Novell domain and install sql failover service? Thanks and sorry for my bad english Christian ... 22 Dec 2009 09:15

SQL Select Problem
Hi all I have a little problem with a select. I would need to have the most simple solution :-) I have the following table: [FK_Candidate], [Key], [Value] 1 'Profession' 'Informatiker' 2 'Profession' 'Inform... 22 Dec 2009 07:04