Search:

You can also right click on the the database name in EM and select Backup database. There is an option to schedule it. This would be an option if you needed backup different databases at different...

I've got an application to which I've added a Crystal Report. This report has always pulled up fine with no problems for the past 3-4 years. My end-users have now decided that they want to add two...

That would be my recommendation as the SQL Express engine is from SQL Server 2005, which would have enhancements not found in SQL Server 2000.

According to the article you will. If you application will be connecting to one of your servers, you should be able to change the connection string parameters to point to that server rather than...

If your server configuration is for Mixed Mode, then you should be able to have both Windows Authentication and SQL Server Authentication. If that's the case, then you can revoke access to the...

SQL Express is the new desktop version of SQL Server. It will effectively replace MSDE. In order to include an SQL Express database in your application, you will need to first install SQL Express...

Don't guess I follow!?

In SQL Server all transactions are stored in the transaction log. Even if there are changes made to the disk/database, there is still a history of those transactions. Log...

What type of RDMS are you using (Access, SQL Server, Oracle, etc)?

I think there are 3rd party tools (Lumigent Log Explorer) that you can go back and backout transactions. So if the record is that important or if this "accidentally" happens quite frequently, it may...

We just generate script files for the objects and check the script files into Source Safe. Not sure if there is a way to interact directly between source safe and SQL Server.

Does the value of True need to be surrounded by quotes?


UPDATE Vehicles
SET Year = 1995,
[Make] = 'Nissan ',
[Model] = 'Maxima ',
[Type] = '4 DSD ',
[Category] = 'Medium Size Car ',
...

Do you need quotes/hashes around the date in the formula?

What types of operating systems are you installing this on? Make sure that the client PC's have the correct version of MDAC installed.

You could run a query against the information_schema.table_privileges view that could return what permissions the user has. This view contains the following columns:
1. GRANTOR - Who granted...

The sa account is loaded by default and is in the Systems Administrator server role. It has complete access to all objects running under SQL Server and this cannot be changed. This account should a...

Another difference is that if users want to query the tables that are owned by you, they have to reference the owner in the from clause:


--Table owned by dbo
Select *
From myTable
--or...

Don't know if it's just a typo or not, but you have an unneeded space in the second Set statment:


DECLARE @SQL Char(200)

SET @SQL = ‘UPDATE TABLE X SET ‘

SET @SQL = @ SQL + ‘Val1 = ‘ +...

If you're looking at doing this via VB, you will have to use the .AppendChunk method of the ADODB.Recordset to do this. Check out Beacon's tutorial for an example.

If you're looking at doing it...

You can use the sp_changedbowner stored procedure to change the database owner:


sp_changedbowner 'newownerlogin'

You can look at SQL Server Books Online for some reference materials on setting up replication. Although I've never set it up, I've reviewed the material and it doesn't seem overly difficult. I...

SQL Server should handle this implicit conversion for you. I use the same thing here, getDate(), and it stores it in the same format. When my users search for records based on date, I don't do any...

Just a thought here, but if you are only going to be writing data to a file for use later within the same stored procedure, why not just use a temporary table instead?

SQL Server does have the...

Based on your INNER JOIN, you are joining Students_Info to ForDates on the Student_ID, which means you are only going to be pulling records back that are in both tables. With that said, you only...

You also should not have a WHERE clause in an insert statement unless you are doing an INSERT INTO table1(...,...) Select ...,... FROM table2 WHERE....

Just a note:

If you are setting this up for someone that needs to be on the road, it might not hurt to setup in the application the ability to allow the user to "manually" sync up the data while...

sql = "select ForDates.FromDate, ForDates.ToDate, Students_Info.FName, " & _
" Students_Info.LName, Students_Info.Address, Students_Info.Address2, " & _
" Students_Info.City, Students_Info.State,...

According to a post in the Microsoft SQL Server discussion forums, you can have an instance of each, just like with 7.0 and 2000.

For SQL Server:


Update tblContacts
Set CRequest = 'N'
Where [ID] Not In (Select [ID] From tblTrackOrder Group By [ID])


If you are using Access, something like the following may work:

I would think that you would be better off to create a stored procedure and check for the existence of the id to be inserted. You can then use the RaisError function to raise a message that the ID...

Since you're using ADO, try changing the "#" sign to a single quote:


rs.Open "select status_settle from settlement where date_settlement ='" & date & "'", con, adOpenKeyset, adLockReadOnly

Have you verified that on machineB it is using the correct connection string?

Are you defining the server in your connection string to be "SERVER=(local)" when you are on your laptop, or "SERVER=ComputerName"?

I'm assuming that the machine next to you is NOT your...

@MyState is a string variable and therefore must be surrounded by quotes:


CREATE PROCEDURE dbo.MySP
@MyState varchar(15) = 'California',
@MySort varchar (50) = 'Zip' As
Declare @MySz...

It depeneds. If you want to restrict the values in the columns, then normalizing is a good thing. It allows you to perform you validation through referential integrity. If you perform your...

I have worked at a shop though where we actually did row level locking. They were C applications that connected to an Informix database. It used client-side cursors to lock the row so no one else...

I first update the row (contrary to my original post), placing a Table lock on the table while the update takes place. Once I've updated the table, I commit the transaction and select the value from...

We let SQL Server handle our locking here as well, with one exception.

I do have a procedure where I lock a table that contains a "next" barcode number. We have multiple workstations...

My connection strings resemble the following

Public ConnectionString = "Provider=SQLOLEDB.1;integrated security=SSPI;Server=DEVSQLServer;" & _
"persist security...

SELECT dbo.EMPLOYEES.[emp-id]
, dbo.EMPLOYEES.[emp-name]
, dbo.[EMP-ALTERNATE].[ALTER-APPROVER]
, dbo.[EXC-LIMIT-ID].[EXC-LIMIT-AMT]
FROM dbo.EMPLOYEES LEFT JOIN...

select *
from tablename
where CharIndex('02', filedname,4)>0