Database

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

I need Websit that compare SQL server - Oracle - Access

23-Feb-09 9:02

Have you noticed this: http://technet.microsoft.com/en-us/library/ms164014.aspx[^]. Perhaps there's the reason.

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

E_Gold22-Feb-09 1:18

E_Gold

22-Feb-09 1:18

Hi evryone
I need Websit that compare between SQL server - Oracle - Access
(Query...Connection...SP.. )

than'k for any help

Re: I need Websit that compare SQL server - Oracle - Access

riced22-Feb-09 2:19

riced

22-Feb-09 2:19

Try googling 'Comparison of relational database management systems'

Regards
David R

Re: I need Websit that compare SQL server - Oracle - Access

Wendelius22-Feb-09 2:26

Re: I need Websit that compare SQL server - Oracle - Access

22-Feb-09 2:26

Just posted a link to a wiki article: 'Comparison of relational database management systems'

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

Wendelius22-Feb-09 2:24

Re: I need Websit that compare SQL server - Oracle - Access

22-Feb-09 2:24

There are plenty of similarities and differences. Googling would give you lots of results to investigate more on the features you're interested in: http://www.google.com/search?hl=en&q=compare+sql+server+oracle&meta=&aq=f&oq=[^].

Also you could see this page as a 'top level' comparison: Comparison of relational database management systems[^]

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

E_Gold22-Feb-09 4:45

E_Gold

22-Feb-09 4:45

Thank's
but i need more SQL Query's Comparison

Re: I need Websit that compare SQL server - Oracle - Access

Wendelius22-Feb-09 7:27

SQL Server Inventory and Database Documentation

22-Feb-09 7:27

Since you know what you're looking for, why don't you google with those keywords that are interesting to you.

It's impossible to give you similarities or differences between three different databases. For example Oracle SQL reference is ~1500 pages and I think that over 50% differs from SQL Server (in one way or another).

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

DrMaltz20-Feb-09 18:27

DrMaltz

20-Feb-09 18:27

I've recently arrived at a firm that has well over 30 databases for various applications. The downside is that there has been no documentation on any of the systems. I've tried to encourage the DBAs and developers to proactively document the purpose of tables, stored procs,etc.. but this has been slow and coming. I've been looking at a few tools from RedGAte, but I'm not sure what else is available. Is there a good process or set of tools that can be used to document a database along with the means to inventory the details for a CMDB?
Thanks.

DrMaltz
"The Code King"

Re: SQL Server Inventory and Database Documentation

Wendelius20-Feb-09 20:45

20-Feb-09 20:45

I believe this situation is quite familiar to many (most?) of us Smile | :)

The only good process I know is exactly what you mentioned, do it proactively when everything is clear in mind. Doing the documentation later is always somewhat gathering the pieces.

About the tools, I think RedGate makes good products, but also this: http://www.dbdesc.com/[^] could be worth to look at.

There are few areas these tools don't cover so if you use a tool to generate the documentation, I would still try to manually include for example:
- E/R diagrams per subsystem (especially in larger dtabases)
- if a table/view has enumerated values etc. in a column, what do they mean
- same for procedures
- privilege/role maps and so on

Hope this helps,

Mika

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

sqlite problem

mirko8620-Feb-09 5:47

mirko86

20-Feb-09 5:47

hi everyone , im using sqlite and i have a problem where, well i use a lot of delegates to make updates or inserts in the database and sometimes they collide and the database locks itself when writing is being done

i managed to "fix" this by using a lot of labels so everytime i get the exception "database is locked" i thread.currentThread.sleep, for 3 seconds and then my label sends it to the beginning of the try statement, kinda like this

retry:
try
{

}
catch
{
System.thread.currentThread.sleep(3000);
goto retry;
}

so with this i got it to work "kind of " simultanoulsy but i went here http://www.sqlite.org/faq.html[^]
and i see this sqlite3_busy_handler and SQLITE_BUSY stuff, i have read it like 100 times and still i dont have a clue how to use it or how to get it or anything about it, anyone of you can point me in the right direction?? appreciate the help

Im using c sharp application by the way

Re: sqlite problem

Wendelius20-Feb-09 5:56