SQL Server

Home Network Configuration SQL Express 2005

Hello,I am pretty new to Sql.I had setup a SQL Express 2005 Advanced on a computer w/ xp on it before and had no problems.I recently purchased a installed a new computer (the other one died) w/ Windows Vista.As before, I downloaded and configured Sql Express per instructions for the software...

Answer Question   |  May 12 2008   11:16 AM GMT   |  asked by Ddog0629
Network connectivity, SQL Server 2005, SQL Server Express

how to get list of encrypted objets in sqlserver 2005?

i need a list of encrypted store procedure name,encrypted trigger ,encrypted functions from sql server 2005.

Answer Question   |  May 12 2008   7:50 AM GMT   |  asked by Subrata73
SQL Server 2005, Encrypted stored procedures, Encrypted triggers

Access rights in SQL Server 2005 users

Hello,I'm using Ms SQL Server 2005. I'm connecting server via ADO.I have a question about access rights. Let me tell this with an example.Let's say I have a database named as DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3.I want to create a SQL user which will have all righst on TBL_1 and TBL_2....

View Answer   |  May 11 2008   7:49 PM GMT   |  asked by DetayMan
SQL Server 2005, SQL Server security, ADO

Connecting Crystal Repor2008 to SQL 2005 database

Via Crystal Report2008 I have to produce a number of reports collecting data from a SQL2005 database running on another computer(2). This computer is not in my domain, but in a workgroup. However, the computer has the same IPaddress category. Anybody can help me with the steps to connect to the SQL...

View Answer   |  May 9 2008   11:14 PM GMT   |  asked by Antillas
Crystal Reports 2008, Crystal Reports, SQL Server 2005

row_number in sql 2000

how to find out the row_number in sql 2000 like using row_number() function in sql 2005

View Answer   |  May 8 2008   10:51 PM GMT   |  asked by Rl
ROW_NUMBER, SQL Query, SQL Server 2000

schedule a restore plan

using sql 2005, management studio,, how to schedule a daily database and restore plan.

View Answer   |  May 8 2008   1:58 PM GMT   |  asked by DRE1
SQL Server restore, SQL Server Management Studio, SQL Server backup

SQL Server error message ‘Could not find the index entry for RID ‘1628000000a412030044160000869a0000040000′ in the database

I'm getting the error 'Could not find the index entry for RID '1628000000a412030044160000869a0000040000' in the database. The table is a very big table and lots of transactions are happening every minute. Please let me know what would be the possible cause and solution for this problem.

View Answer   |  May 7 2008   4:21 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server, Index, SQL Server errors

Is there a way to set up database mirroring in SQL Server 2005 to receive failover notification?

I'm setting up database mirroring in SQL Server 2005 Standard Edition and was wondering if there is a way for SQL Server to send me a notification of a failover and for it to automatically run a script when the mirror is brought online.

View Answer   |  May 7 2008   4:12 PM GMT   |  asked by SQL Server Ask the Experts
Database mirroring, SQL Server 2005, SQL Server alerts

Is there a query to search text of all SQL Server database objects that reference a specific table/instance?

We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?

View Answer   |  May 7 2008   3:49 PM GMT   |  asked by SQL Server Ask the Experts
Query, SQL Server migration, Database objects

Error when upgrading SQL Server 2000 to SQL Server 2005

I am upgrading SQL Server from 2000 to 2005. While upgrading I have received the below mentioned error. Kindly review and advise me on this. By the way, I have sufficient disk space on my server."TITLE: Microsoft SQL Server 2005 SetupSQL Server Setup has encountered the following problem:...

View Answer   |  May 7 2008   3:29 PM GMT   |  asked by SQL Server Ask the Experts
Upgrades, SQL Server upgrade, ERROR MESSAGE

Query error when using application role with ADO connection

I am developing an application with an ADO connection. I need to run a query on two different databases on the same server using an application role. When I run the query I get an error \domainusername does not have a logon on database (referring to the second database). Is there any way around it?...

View Answer   |  May 7 2008   3:24 PM GMT   |  asked by SQL Server Ask the Experts
ERROR MESSAGE, Application development, ADO

How to perform exploratory database testing using ERDs

Can you please advise me on how to perform exploratory testing on a database using ERDs?

Answer Question   |  May 7 2008   3:05 PM GMT   |  asked by SQL Server Ask the Experts
Database testing, SQL Server database design and modeling, ERD (Entity Relationship Diagram)

How to Schedule jobs in DTS in sql server 2000

I have got 7 jobs in my sql server server agent, now i want them to run simultaniously one afer the other using DTS, is it possible,if yes how can i do it

View Answer   |  May 7 2008   5:14 AM GMT   |  asked by SRI HARSHA
SQL Server Agent, DTS, SQL Server 2000

Connect to Sybase ASE 15 via MS SQL 2005

I'm in a test phase and would like to connect to a Sybase ASE 15 server in much the same way as linking tables in access. How would I accomplish that?

Answer Question   |  May 5 2008   9:06 PM GMT   |  asked by Bhassel
Sybase, Sybase ASE 15, SQL Server 2005

Backup SQL database with BRMS AS400

Running BRMS on i520 v5r4 LTO 4 tape library. Company just installed on seperate machines, same network: Windows2003 Server with MSSQL Database.I want to use BRMS and our robust LTO library system to get to the data on the SQL Database. Have little success with the LTO 4 being supported by...

View Answer   |  May 5 2008   3:42 PM GMT   |  asked by Vic585
AS/400 backup, BRMS, SQL Server

datetime conversion

SQL Analyzer has issues w/below relative to the datetime conversion- - what is the problem?convert(varchar(10),ft.postdate,101) 'PostDate',

View Answer   |  May 5 2008   3:31 PM GMT   |  asked by Mictip
SQL Query Analyzer, DateTime

How do my database sql2005 database to another server with management studio

Has sql 2005, using management studio to do a full backup of my database. Using maintenance wizard to set the backup. I only see my local drive and not my share folder created onthe other server where i want to place the .bak file. Any idea will be helpfull.

View Answer   |  May 5 2008   2:10 PM GMT   |  asked by DRE1
SQL Server backup, SQL Server Management Studio, SQL Server 2005

DB size

Hi, I am using a software which is using SQL DB. Each time there is an error (one of the tasks fails) the DB grows. I would say over 1G per day! Currently I have DBs which are 45G and I am running out of space.Anyone has any idea how to shrink the DBs or do something to reduce the size.The LDFs...

View Answer   |  May 2 2008   3:30 PM GMT   |  asked by Ellie
SQL Server 2000, SQL Server performance tuning, SQL Server logs

Suspect DB

Hi, I am using sql server 2000 and recently found 2 of the DBs are marked as Suspect and I don't have access to them any more.Would you please help me with this?Thanks,Ellie

Answer Question   |  May 2 2008   3:24 PM GMT   |  asked by Ellie
SQL Server security, SQL Server 2000, Suspect database

Can’t Install SQL Server 2000 on Window XP SP2

I try to install SQL Server 2000 on Window XP SP2, but there is an error message mean "OS not support.". What should I do? How can I install SQL Server 2000 on Window XP SP2? Please, give me the best and detail answer. Thanks.

View Answer   |  May 2 2008   4:29 AM GMT   |  asked by Yoyo
SQL Server 2000, SQL Server errors, Windows XP