How to write the query
How to write the query from one table.(i don’t want first row and second row)

Answer Question   |  October 29, 2007  11:10 AM
Query, SQL Server 2000

Create credential
I need to create a credential,and a proxy for my Jr. dba to support and troubleshoot production SSIS and SQL jobs. I want to create a credential/proxy that follows best practice and can be implemented as a standard across environments. Can you give me an example of a credential that has sufficient permissions? Do I [...]

Answer Question   |  December 2, 2007  7:50 PM
SQL Server, SQL Server security

Systems problem
I always wonder why this happened to my system…..a situation like this. I redesign my system since its predecessors made me a lot of headache. The previous months after it was been upgraded many complains in one particular problem. This is what the problem is……they notice that in no particular time there are data that [...]

Answer Question   |  December 2, 2007  3:11 AM
SQL, SQL Server, VB

Clustered indexes
Why can only once clustered index be created on a table ? What is a row locator?

Answer Question   |  December 2, 2007  10:07 AM
SQL Server 2000

importing into Reporting Services 2005
Can Excel SS or anything besides an Access.mdb be imported into Reporting Services 2005

Answer Question   |  February 1, 2008  7:17 PM
Reporting Services 2005

Nested Selects in CLLE
I am attempting to palce Nested Select Statements within a CLLE program and it will not accept the process. ie: SELECT wHEN a=B THEN(DO) PROCESS…. ENDDO WHEN C=D THEN(DO) PROCESS eNDDO WHEN (X=Y) tHEN(DO) select wHEN X1 = A tHEN(dO) PROCESS eNDDO wHEN X1 = b THEN(DO) PROCESS eNDDO eNDselect wHEN X=z tHEN(DO) ENDDO ENDSELECT [...]

Answer Question   |  October 24, 2007  7:11 PM
CLLE, NESTED, SELECT statement

Select from table where data row missing
I have a table with the main fields being BU, ASSET, BOOK for any BU and ASSET combination, there should be two to four rows of data, with just the BOOK value being different. Data corruption has caused us to find all BU-ASSET combinations missing the value ‘AMT’ for BOOK. I need to join the [...]

Answer Question   |  October 25, 2007  9:34 PM
OUTER JOIN statement, SELECT statement

How to create a user login and password in Enterprised Manager in SQL server 2000
Hello, I am new SQL server DBA. I can create a new user. The request came in also ask for the password. Is there anyone can help me on how to set password to a user in in Enterprised Manager in SQL server 2000? Thanks,

Answer Question   |  November 2, 2007  8:45 PM
Enterprise Manager, Password, SQL Server 2000

sql server 2000
i am learnin sql server 2000 by ownself tell me the wright way how i can learn after this i shall go for oracle

Answer Question   |  May 23, 2008  11:37 AM
SQL, SQL Server 2000

Triggers in sql server 2005
hi Experts, I have created a table called MyEmployees with ManagerID,ContactID,etc.,.. fields. Also i created another table ManagerAndContact with Only ManagerID and ContactID as fields. Now what i need is, whenever am inserting a new row in MyEmployees table, the corresponding ManagerId and ContactId should be inserted into the second table – ManagerAndContact using trigger. [...]

Answer Question   |  December 2, 2007  2:36 AM
SQL Server, SQL Server 2005

database sql,with vb coding,first time running not fast
we have an accounting package written in visual basic 6.0 and sql database,the problem is when we open the database the first time,it takes lot of time,but when we open it after, it will be very fast and remain fast ,even when we quit the application and restart it.

Answer Question   |  February 22, 2008  8:40 AM
SQL Database, Visual Basic 6

SQL Server Schema Best Practices
I am in the process of establishing a “sandbox” database for a mix of users with SQL development skills. I have done this before with Oracle but not with SQL Server. What I would like to do is build a database whereby each user has their own play area. We are running SQL Server 2005 [...]

Answer Question   |  February 22, 2008  3:01 PM
SQL, SQL Server

Triggers
I was a cobol/db2 programmer for many, many, many years, and I now have the opportunity to work with SQL Server. That’s the good news…the bad news is NO training. I will have to learn this on my own. Do anyone have any suggestion on how to get started. My first project is to identify [...]

Answer Question   |  February 22, 2008  1:36 PM
SQL Server

I can update the dataset, but not the database
Posted on behalf of BodjorB: I have been trying to update a database in a program i developed using Microsft Visual Basic 2005,SQL Express — whenever I enter data and click on Update, this updates the dataset, but the database is not updated. What am I forgetting?

Answer Question   |  October 5, 2007  12:37 PM
Database, SQL Express, Visual Basic

SQL 2000 to Yukon Migration
Posted on behalf of Kilaru: We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it [...]

Answer Question   |  May 23, 2008  9:32 AM
Exchange Server ActiveSync, HTTP, SQL Server 2000

SQL 2000 to Yukon Migration
We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for [...]

Answer Question   |  February 22, 2008  8:02 AM
Access, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server

Need to create a bootable server 2003 CD
Hello, I have a burned copy of Server 2003 Enterprise edition that a friend gave to me. I’d like to install it on my test server, but am unable to because the CD is not bootable. I have tried booting the server with a 98SE floppy boot disk but am unable to run setup through [...]

Answer Question   |  April 19, 2013  3:17 PM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

insert into system tables
I’m trying to do inserts into system table – e.g. insert into sys.extended_properties values(1, ‘OBJECT_OR_COLUMN’, 1973582069,3, ‘MS_Description’, ‘Code used by the State for reporting purposes’) But i get this error: Msg 259, Level 16, State 1, Line 1 Ad hoc updates to system catalogs are not allowed. The reason for my doing this that there [...]

Answer Question   |  October 5, 2007  9:44 AM
SQL Server

SQL joins on encrypted data
Hi – we are in the process of encrypting various pieces of sensitive information in our SQL 2000 tables. For many fields we are using Blowfish 448 encryption and a concern has arisen about inline SQL statements that contain joins in our ASP scripts. Are there any scenarios that you have run across where there [...]

Answer Question   |  October 5, 2007  2:35 PM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server, Web site design & management

exchange configuration
We have Windows 2003 Small Business Server R2 and Windows XP professional workstations. The director of the company would like to operate the following scenario He would like to send and receive his company emails as normal. He would like his PA to receive a copy of all of his emails He would also like [...]

Answer Question   |  January 18, 2008  6:30 AM
Desktops, Exchange, Exchange security, Management, Microsoft Windows, OS, Security, Servers, SQL Server