Database

Wendelius23-Feb-09 8:49

23-Feb-09 8:49

Don't quite understand. Your problem is that you try to create a table that already exists. So you must either drop it or modify your code so that you don't create the table if it already exists.

The need to optimize rises from a bad design.My articles[^]

MarcelloTurnbull23-Feb-09 9:08

MarcelloTurnbull

23-Feb-09 9:08

After you answer I added the DROP TABLE in the beginning of the code but it has not worked. I must not modify the code following the snippet.

Thank you

Marcello Turnbull

Wendelius23-Feb-09 9:14

23-Feb-09 9:14

Could you post the whole code? Also do you receive the same error or something else?

The need to optimize rises from a bad design.My articles[^]

MarcelloTurnbull23-Feb-09 9:29

MarcelloTurnbull

23-Feb-09 9:29

DROP TABLE #Teste

DECLARE @x int
SET @x = 5

IF @x > 1
SELECT IDField1
INTO #Teste
FROM Table1

ELSE

SELECT IDField2
INTO #Teste
FROM Table1

(...)

Buddy, the error message is the same.

Thanks

Marcello Turnbull

Wendelius23-Feb-09 9:47

23-Feb-09 9:47

That's odd. For some reason the parser interpets that the table is going to be created twice (of course that's not gonna happen since you have IF ... ELSE structure).

However, could you use the following:

DROP TABLE #Teste;
CREATE TABLE #Teste (
   IDField1 int
);
DECLARE @x int;
SET @x = 5;
IF (@x > 1)
BEGIN
   INSERT INTO #Teste
   SELECT IDField1
   FROM   Table1;
END;
ELSE 
BEGIN
   INSERT INTO #Teste
   SELECT IDField1
   FROM   Table1;
END;

The need to optimize rises from a bad design.My articles[^]

MarcelloTurnbull25-Feb-09 2:31

MarcelloTurnbull

25-Feb-09 2:31

Buddy

I apologize for I could not reply yesterday but it was holiday here Wink | ;-)

Snapshots[^]

It worked so thank you very much

Marcello Turnbull

Wendelius25-Feb-09 4:42

SQL 2000 Code/Update Deployment

25-Feb-09 4:42

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

cjb11023-Feb-09 2:23

cjb110

23-Feb-09 2:23

I'm looking for some views/ideas on the following problem that I currently face:

We have a SQL 2000 Application with all the back end code written in SQL, controlled by a VB GUI.
Due to the nature of the app we have fairly frequent code changes to make.

These changes are implemented by a third party, as I do not have access to the production systems.

At the moment I generate lots of .sql files for the various tables, views, sp's etc that are changing and they are just run through QA one at a time.

My problem is finding a more reliable way of deploying these changes, as lots of files means one could be missed etc or ran twice which might present 'non' error errors.

Do people use batch files and the command line? or are third party tools the norm?

Re: SQL 2000 Code/Update Deployment

Wendelius23-Feb-09 8:45

SQL Server 2000: Login failed for user ' ' [modified]

23-Feb-09 8:45

I believe that how changes are gathered varies a lot.

But in your case, why do you separate different modifications to different files instead of gathering all modifications to a single file? That way you could ensure that everything is run (only once) and that the execution order is correct (sometimes this can be an issue for example with foreign keys, triggers etc). This script cold be run using osql.

The need to optimize rises from a bad design.My articles[^]

Nada Adel23-Feb-09 1:07

Nada Adel

23-Feb-09 1:07

I'm trying to connect to my sql 2000 database "mydatabase" using JDBC for SQL Server 2000, but I failed.

I'm using IReport to connect to the database and I added the driver for sql server 2000. I made sure it runs under mixed mode (i.e: windows and sql server authentication)
I created a login user (ASPNET) user and granted permissions to him on the database (without any passwords).

The url that I use for connection is jdbc:microsoft:sqlserver://localhost:1433/mydatabase
username:ASPNET and I don't enter any passwords.

error: Login failed for ASPNET. The user is not associated with a trusted sql server connection.

When I don't enter any username or password, he tries to connect using my computer's credentials but also fails.
I don't know what's wrong.

I tried everything but I failed to connect to it.
I even installed sql server 2000 sp3 on the computer but to no avail.

Am I missing something?
How am I supposed to connect to the database?

sorry for taking so long..I hope someone could help me out.

modified on Monday, February 23, 2009 7:27 AM

Rob Philpott23-Feb-09 1:37

Rob Philpott

23-Feb-09 1:37

I think what you're seeing here is a trusted connection issue. You're not connecting to Sql Server using a username and password but instead using your windows account. You'll need to add the domain account as a user to SqlServer.

Also, its worth just making sure your account isn't locked (3 wrong log-ins etc) as this produces exactly what you describe.

Regards,
Rob Philpott.

Nada Adel23-Feb-09 2:33

Nada Adel

23-Feb-09 2:33

ok, I've just created a login user with my computer name and its domain and I specified the authentication as Windows Authentication coz otherwise a password will be required and I set the default database as "mydatabase".
This time the error is: cannot establish connection. Cannot open database requested by login. Login failed for user domain/username

Should I restart sql server or what?

Rob Philpott23-Feb-09 2:57

Rob Philpott

23-Feb-09 2:57

I think its your domain and the logged on account you want to add, not the computer name. You'll then need to add that user to the Sql Server so they can access the server, and add the permission to the database you're using as well.

Regards,
Rob Philpott.

Nada Adel23-Feb-09 3:08

Nada Adel

23-Feb-09 3:08

oh I'm sorry, I meant to say the logged on account (mine is the same as the computer name) I'm sorry for mixing things up.
Anyways, I did that, but still login failed.

Any ideas why??

Parameter Multivalue

Hakmeh Mohannad23-Feb-09 1:01

Hakmeh Mohannad

23-Feb-09 1:01

hi i have a report viewer containe parameter, i tried to get the parameter values from a web service but i could not because the web service return a sxd:schema not dataset. So i decide to pass those values into the parameter from regular aspx page and it worked, but i still have small problem

the dropdown list is selecting all values sperated by ','

what should i do to prevent this

thank you

Re: Parameter Multivalue

Wendelius23-Feb-09 8:50

23-Feb-09 8:50

Since this is ASP related problem, I believe that you would get much better help in ASP.NET forum[^]

The need to optimize rises from a bad design.My articles[^]

SQL LOGIC

Vimalsoft(Pty) Ltd23-Feb-09 0:28

Vimalsoft(Pty) Ltd

23-Feb-09 0:28

Good Day All

i have a table that carries a Field that has data like this

10101010101010

Now the Function that adds this 1's and 0's is working like this. If its selected insert "1" else "0", So if i can interpret the above if will be

1 3 5 7 9 11 13

the only thing that am interested in is "1's", if i can display their Position in a SQL Query i will be happy

i want to take these Values from a SQl table and Bind them to a Gridview. Remember the Number of Zeor's can increase , but the Limit is 63 including the "1's" and "0's".

Thank you

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za

Wendelius23-Feb-09 8:28

23-Feb-09 8:28

If possible, I think you should change the structure and use a child table to represent those values. It would be then far easier to handle the data.

However, if you want to have all 63 possible values in columns where the correspinding bit is on, you could use something like:

select convert(int, substring(data.field, 1, 1)) * 1,
       convert(int, substring(data.field, 2, 1)) * 2,
       convert(int, substring(data.field, 3, 1)) * 3,
       convert(int, substring(data.field, 4, 1)) * 4,
       convert(int, substring(data.field, 5, 1)) * 5,
       convert(int, substring(data.field, 6, 1)) * 6,
       convert(int, substring(data.field, 7, 1)) * 7,
       convert(int, substring(data.field, 8, 1)) * 8
       ...
from (select convert(varchar(63), 10101010101010)
       + replicate('0', 63-len(convert(varchar(63), 10101010101010))) as field
       ) data

The need to optimize rises from a bad design.My articles[^]

Vimalsoft(Pty) Ltd23-Feb-09 19:28

Vimalsoft(Pty) Ltd

23-Feb-09 19:28

hi Mika

Thank you for your response, i have came with the Following and it seems to work.

declare @S as nvarchar(63)
set @S = '10101010101010'

declare @NS as nvarchar(128)
set @NS=''
declare @Len as int
SET @Len = LEN(@S)

declare @Counter as int
SET @Counter = 1
WHILE @Counter < = @Len
BEGIN
	if (SUBSTRING(@S,@Counter,1)='1')
		set @NS = @NS + ' ' + convert(nvarchar,@Counter)
	SET @Counter = @Counter + 1
END
select @NS

What do you think about it

Thank you

Wendelius23-Feb-09 20:17

23-Feb-09 20:17

That should be okay. The idea is the same as in the statement I posted and if you can use T-SQL instead of plain SQL, using a loop is easier.

The need to optimize rises from a bad design.My articles[^]

Vimalsoft(Pty) Ltd23-Feb-09 20:35

Vimalsoft(Pty) Ltd

23-Feb-09 20:35

Thank you

Wendelius23-Feb-09 22:49

SQL Server 2008 Remote Debugging

23-Feb-09 22:49

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

cfoxtrot22-Feb-09 21:08

cfoxtrot

22-Feb-09 21:08

Dear all,

I am accessing a database which is running on an SQL Server 2008 machine via SQL Server Management studio 2008 from a remote machine. I am using SQL authentication and I am able to do all the query and database management work.

However when I try to make use debugging I get an error stating unknown username or bad password. I did not manage to find any solution for this error. Have you ever encountered such a thing?

Any potential solutions will be greatly appreciated!

Many thanks

Re: SQL Server 2008 Remote Debugging

Wendelius23-Feb-09 9:02