SQL Server Database Questions and Answers

Recent IT Questions

1 - 20 of 85
<<PREVIOUS 1|2|3|4|5 NEXT>>

Email Notification

Hey i am creating an application front end = vb.net and back end = sql server db!! the application helps assign staff to jobs and when an assignment occurs i would like the staff to recieve an email informing them that they have been assigned to a job... can anyone help me out with how i would go...

Answer Question   |  Nov 17 2009  0:09 AM GMT
VB.NET, SQL Server database
asked by Keirameister

  5 pts.

Replication sync_method set to concurrent in SQL Server 2000

Hi, Just wondering what happens to data that are inserted during the time of a snapshot replication generation when the sync_method is set to concurrent, as there are no table locks, are the data insert into the publisher then held in the distribution database and when the snapshot has been...

asked by Db23

  230 pts.

how to use sql server 2005

i have installed sqlserver2005 but i want to know how to open sql server and connect DB

View Answer   |  Sep 27 2009  12:28 AM GMT
SQL Server 2005, SQL Server database
asked by Anand7986

  5 pts.

Data model for Custom fields and Custom forms.

Hi, I plan to build a web application which would have dynamic forms with custom fields. he can create one module, web form having some custom fields.So these fields can be created by customer itself through web application. To make this enable i believe I should have some tables to store meta...

Answer Question   |  Sep 10 2009  8:11 PM GMT
Dynamic Forms and fields, data model, performance
asked by SQLServer2008

  10 pts.

SQL Server Database Restore

When i restore a database from server1 to server2 as stand by/read-only mode the database restores with a database owner "domainrmartinez". How can i restore a database from server1 to server2 and the database owner as "sa"? Software/Hardware used: SQL Server 2005

asked by RickMartinez

  85 pts.

Data base with Visual C++

I am learning on Data Base management. I have installed Visual C++ and will use SQL server. But I don't know which component else to install, and how to connect to and use SQL Server. Can somebody help me? Thanks a lot Software/Hardware used: Visual C++, SQL Server

View Answer   |  Aug 18 2009  9:22 AM GMT
C++, Visual C++, SQL Server
asked by Makee

  15 pts.

Adding data in SQL 2005 server

i am trying to add data on an sql database from backend problem is it does not acceptnull values kindly help. My email address is edmuia@yahoo.com

View Answer   |  Aug 6 2009  2:00 PM GMT
SQL Server database, SQL Server 2005
asked by Zippyyepee

  15 pts.

SQL Server Database Date Time Values

I am developing a software using Date Time values. i am using SQL server 2000 as the database. can i create a coloumn with only time value or data value. Only datetime is available. how can i eliminate a part of it in the database. when inserting the time values the date part is 01 jan 1900. i...

View Answer   |  Jul 30 2009  4:11 PM GMT
SQL Server database, SQL Server 2000
asked by RAYNISH

  35 pts.

sql in C#

How can I attach And detach a database file to sqlserver in C# code ? please give me an example of this

View Answer   |  Jul 15 2009  3:05 PM GMT
C#, SQL Server database, Database Files
asked by Sajjadzare

  5 pts.

SQL Server error: Cannot find log file

I am receiving the error, "cannot find log file." I detach the database and I am unable to reattach it because of the error. I created a new database and copied the MDF. When I restarted the SQL Server, I am told the database is suspect. What can I do to fix this error?

asked by SQL Server Ask the Experts

  2445 pts.

Issues rebuilding system database on SQL Server Express 2005

I am having some trouble rebuilding the system databases on my SQL Server Express 2005 instance. While I have had a total system failure, the backups have been good. I have restored the operating system but obviously there are no SQL system databases present (they were open at the time of the...

asked by SQL Server Ask the Experts

  2445 pts.

Shrinking a SQL Server database

What is the best way to shrink a database? What are the alternative methods?

asked by SQL Server Ask the Experts

  2445 pts.

Backing up SQL Server 2008 databases to a tape drive

I am running Sql Server 2008 and I need to know how to make backups of the database onto a tape drive. How do I do this?

View Answer   |  Jun 24 2009  10:36 PM GMT
Backup to Tape, SQL Server 2008, SQL Server database
asked by Phrathepmali

  30 pts.

SQL Server 2000 Database Table Limit?

Is there a limit to how many tables a single database can hold in SQL 2000?

View Answer   |  May 6 2009  8:18 PM GMT
SQL Limits, SQL Server 2000, SQL Server database
asked by Xarly

  25 pts.

Linked SQLServer

Hi, In oracle database you are able to link the oracle database to a SQLServer 2005 database, I want to be able to link a SQLServer 2005 another SQLServer 2005 database (not another SQLServer 2005), does SQLServer 2005 allow us to do this? Does it only allow server to server linking? Thanks.

asked by Db23

  230 pts.

Connecting a SQL Server database with Visual Basic 6.0

What code would I need to connect a SQL Server database with Visual Basic 6?

View Answer   |  Apr 7 2009  8:23 PM GMT
SQL Server database, Visual Basic 6, Visual Basic
asked by SQL Server Ask the Experts

  2445 pts.

Using SQL Server databases on data with numerous checks

I am interesting in cleaning census data, and I have a number of edit checks, consistency checks, validation checks and range checks to perform. What is the best practice you would recommend, using SQL Server as the database?

View Answer   |  Apr 7 2009  5:17 PM GMT
SQL Server, SQL Server database
asked by SQL Server Ask the Experts

  2445 pts.

Backup Performance Compare

How or what can I use to compare the performance of the backup performed when the database is configured to use the simple recovery model versus the full recovery model.

asked by Hydra

  145 pts.

Deleting in a complicated data structure on SQL Server 2000

I have a complicated data structure on SQL Server 2000 which, at times can go four levels deep. It is all designed using foreign keys, as expected. I am having difficulty getting deletion to work from the top level, which is an orders table. Some child tables have cascade deletes on, and some are...

View Answer   |  Mar 24 2009  5:49 PM GMT
SQL Server 2000, SQL Server tables, SQL Server database
asked by SQL Server Ask the Experts

  2445 pts.

How to connect my application using Visual Studio 2005 to a SQL Server database?

how to connect my application using visual studio 2005 to a database using sql server?

asked by MissVeryLittleKnowledge

  5 pts.

1 - 20 of 85
<<PREVIOUS 1|2|3|4|5 NEXT>>