SQL Server Database

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...

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...

how to use sql server 2005

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

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...

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

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

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

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...

sql in C#

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

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?

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...

Shrinking a SQL Server database

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

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?

SQL Server 2000 Database Table Limit?

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

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.

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?

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?

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.

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...

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?