Viewing 15 posts - 1,246 through 1,260 (of 2,904 total)
What is commonly known as SQL Server 2000 is REALLY SQL Server 8.0. So that statement can be translated to "Columns in SQL Server 2000, but not in SQL Server...
February 22, 2006 at 8:26 am
Try checking the data with the ISDATE command. That should point out any invalid dates.
Also, make sure the SQL Server collation is the same on both systems.
-SQLBill
February 22, 2006 at 8:19 am
First and most important.......what type of authentication does your SQL Server use? Windows Only or Mixed Mode? If it is Windows Only - you cannot set the owner as...
February 22, 2006 at 8:15 am
Another consideration....are you doing your restore over a network? If so, that could be real slow. You should copy the files to the local drive and restore from...
February 22, 2006 at 7:58 am
Yep, sure does look that way. And they didn't advertise the hotfix very well because it was only needed under VERY specific situations. Kinda like Microsoft and their...
February 17, 2006 at 11:38 am
I use Veritas Backup Exec. I no longer use the Agent for SQL Server. Why not? Well...there's a story....
We bought our servers, tape library and Backup Exec...
February 17, 2006 at 9:01 am
#1 question....what database? Some databases MUST be SIMPLE (for example, Master) and will switch back if you set them to FULL or anything else.
-SQLBill
February 17, 2006 at 8:40 am
You can only access these pages by being a member. On the login page there is a check box that applies a cookie to you computer and it will...
February 16, 2006 at 8:19 am
Another option is to create a second instance of SQL Server and have that user's database on that instance.
-SQLBill
February 14, 2006 at 11:07 am
SQL Server edition can make a difference. I have had to move a database and the new server had to have not only the same edition, but the same...
February 14, 2006 at 9:53 am
In Enterprise Manager, go to Jobs. Find the job and right click on it. Go to the Schedule tab. Is Enabled checked? If not, check it. Then...
February 13, 2006 at 10:34 am
PLEASE tell me you aren't backing up one database to two different places.
A transaction log backup applies ONLY to the previous FULL backup, same with a differential backup.
Two backup drives...
February 10, 2006 at 12:16 pm
Darn that data......if it weren't for data, my job would be so much easier.
-SQLBill
February 10, 2006 at 12:04 pm
When you install SQL Server on a computer for the first time, it installs as a Default instance (unless you name it). This instance has the Master, Model, MSDB, TempDb,...
February 10, 2006 at 8:45 am
Sometimes the job needs a Refresh to update that value. Especially if any changes have been made to the job.
-SQLBill
February 10, 2006 at 8:39 am
Viewing 15 posts - 1,246 through 1,260 (of 2,904 total)