Using MS SQL Server

database owner?
SQL Server 2005 SP2 What is the significance of the owner of a database being sa as opposed to some administrative (or non-administrative) local login? Should I favor one over the other? Can I change the owner of a database? TIA aj ... 19 Jun 2008 01:14

Full text search in albanian
Hello everyone, I'm trying to implement full-text search for the albanian language. What's the best way to implement it? Based on my current understanding the most feasible way is to: 1. Use one of the supported lnaguages, for example Turkish. 2. Replace noisy words of Turkish with Albanian noisy words. 3. Rep... 19 Jun 2008 01:14

PERSONAL BANKRUPTCY
********************************************************* http://personalbankruptcy1.blogspot.com ... 19 Jun 2008 01:14

Problem With View and Changing Field Length
I had a strange situation with a view in SQL 7, that I could use some input on. I had a very simple view -- select a, b, c from table1 where x=y and z=q. Field a in table1 originally was varchar 70. A long time ago I changed it to varchar 95. I used this view as an ODBC linked table in an Access MDB. Recent... 19 Jun 2008 01:14

"Maksanhierontalaite" ; )
YLE Ajankohtainen kakkonen 13.05-08:" Nyt ei olle en�� KENELLEKK��N ep�selv��, ett� maailma on ajautumassa ennen�kem�trt�miin tuleviin n�l�nh�t�kriiseihins�!" Niin.. ..! Olen jo vuosikaudet opettanut sit�, ett� maailmassamme on tuloillaan niin raju ja katastrofaalinen n�lk�tuho, ettei ihmiskunta on vastaavaa ko... 19 Jun 2008 01:14

stored procs
Is there a way to look at the internals of built-in stored procedures and see what they are doing? sp_help provides little information. ... 19 Jun 2008 01:14

live online training
Live Online training in Oracle Technology by experienced, certified professionals. Training Available -> Oracle Database Administration -> Oracle Application Express -> Linux for DBAs Our Instructors credentials -> Certified Project Management Professional (PMP) -> Oracle Certified Master (OCM) -> Orac... 19 Jun 2008 01:14

IF within SELECT
Hello, I'm working on a DB on which I can run only SELECT commands, so I'd like to modify these UPDATE commands, into one SELECT command, which makes use of IF statements: update Table set field1=field2 update Table set field1=field3 where 'condition' I've modified it into this: select *, IF(condition,... 19 Jun 2008 01:14

Compound vs Simple Indexes
I have two tables. I want to get one column from table B into table A. I have added a "blank" column in table A for that information. The "link" criteria is on 3 columns. What I am wondering is if I am better off creating 3 different indexes (one for each column) or a single index of all 3 columns. Thanks, ... 19 Jun 2008 01:14

Looping Through the Records returned from a DTS Lookup
Okay...here is what I need to do. I have an Oracle Connection that I want to pull records from into an SQL table. I have a view in the SQL server that contain the values I want to use in a where statement to query the Oracle DB with. What I need to do is loop through the Lookup (of the SQL view) in an ActiveX scri... 19 Jun 2008 01:14