SQL Server Database

Truncating the transaction log for a SQL Server 2000 database

What is the best automated way to truncate the transaction log for a SQL Server 2000 database?

Transferring a database from Microsoft Access to SQL Server 2000

How would I transfer a database from Microsoft Access to SQL Server 2000?

Connecting sql server 2000 to 2 databases simultaneously

I have to create a report to move inventory from an old warehouse to a new one. Each has a separate instance of the database, so I have to get the part# and location from the old warehouse and match it with the new location for that part# in the new warehouse. Is there a way to join tables from...

Re-applying column constraints

I have a 100+ db that was hacked. The column level constraints/defaults were removed. I'd like to know how I can reapply the constraints/defaults while keeping the data intact. I do have an identical database with no data in it.

SQL DATABASE SERVER

Hi, Please how can I access a client SQL database server remotely to update date therein. My client have this MS SQL Server Ver. 9.00.2047.00, Product Level: SP1, Edition: Standard Edition. and I will need to update the data. I have to update the database. I have downloaded SQLEXPR and installed...

Archiving a row of data into another database on SQL Server 2005

I work on SQL Server 2005, and I need to archive a row and its relationship into another database. I know a script could be written to do this, but I would like to know if software exists that could be given the data row and then complete the archiving by itself. Is this possible?

securing sql server database object

I connect my access project to sql server. Is there as simple way to secure sql server object such as table, view, stored proc from editing or deletion since access let us to edit sql server object directly

Creating database access at runtime for ADO and SQL Server

I’ve put together some code to create database access at runtime using an ADO database connection. How can I do the same for a SQL Server database?

Setting aside code for 12 databases in separate database on SQL Server

I have 12 databases on my SQL Server, one for each month of the year, and I have almost all the same stored procedures in each database. This architecture is hard to maintain, because you have duplication of the code, and a modification must be made on all the databases. Is there a way to put all...

Making a query for a SQL Server database

I would like to make a query for my SQL Server database to specify that only unmatching records should be displayed from both tables. Can you help me in doing so?

Error message when connecting SQL Server database to ASP.NET

I’ve been getting the following message when connecting my SQL Server database to the ASP.NET application: "Login failed because, under default settings, SQL Server 2000 does not allow remote connections." What might this mean?

Email notification in the event of a SQL Server database failover

In case of a failover of a SQL Server database, I’d like to be notified by email. Can you tell me how to activate this option?

Creating a website with a SQL Server database

What programming tools can I use to create a website that will be hosted on a Windows-based platform with a SQL Server database?

Union Query

I 've a problem with porting my ms access database to sql server. In my inventory database, i have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, i do with this kind of queries : a....

Copying a database to a newer version of SQL Server

I have a database on my SQL Server that needs to be upgraded to SQL Server 2005 or SQL Server 2008, but when I try to copy it with the Copy Database Wizard, I do not have the option “Copy” listed under “Tasks”. I am using SQL Server Express, which I think may be my problem. Is this...

Recovering a deleted database in SQL Server 2005

I've accidentally deleted a database on SQL Server 2005, and I do not have a backup. Is there any way to recover it?

Copying a database from SQL Server 2000 to SQL Server 2005

I am using the Copy Database Wizard to copy a database from SQL Server 2000 to SQL Server 2005. I gave it the data file path on the source server (ex. \SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLData), but it returns an error when I attempt to execute the package ("Access to the path...

Database hanged due to concurrence

Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration...

Error messages during the creation of a mirror database on SQL Server

I am trying to restore a database from one SQL Server to another to create a mirror database. However, when I enter “RESTORE DBMirror FROM DISK=’C:Backup DBMirror_FULL.BAK’ WITH NORECOVERY,” next to the database name appears the error message “Restoring…” It never goes away. What...

SQL Server Error while creating db from DUMP

Hi, We get the following error while trying to create a new db from a dump which contains the MDF and LDF files. Appreciate if anyone could let me know on what could be the reason for this error. The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at...