Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Log file Problem
Posted by Me On Line at 5/2/2007 10:47:26 PM
I am using SQL server 2000 and i was working on Strore procedure and
manupulating tables.Sql Server shows me messages that ur log size is
and as a result it does not allow me to do any manupulations.so
I de attached the database and rename it and increase its log file...more >>
The data types text and nvarchar are incompatible in the equal to operator.
Posted by Alex at 5/2/2007 8:11:32 PM
I'm stumped on this error message. I've looked everywhere and I can't
figure out why this is happening. I've set all fields in my sql table
to text and all fields in my vb dataset to string, but I still get
this problem. Can anybody see why this error message occurs:
"SQL Exception Unhandle...more >>
AgentMail Problem (SQL2K)
Posted by Leila at 5/2/2007 6:58:28 PM
I use Microsoft outlook as MAPI client. On my own computer, when the outlook
is open, both SQL Mail and Agent Mail can use the file of mail profile to
send email. But on one of client's computer, when outlook is open, it locks
the file of profile and both SQL Mail and Agent Mail fail when...more >>
permissions for drive where data is
Posted by Dan D. at 5/2/2007 4:27:02 PM
Using SS2000 SP4. I have an account called "sqlserver" that I use to start
the SQL Server service and the SQL Server Agent service. This account is an
admin account in sql server. I moved a database from one drive to a new
drive. The database came up as read-only. The permissions on both drive...more >>
"downgrading" 2005 to 2000
Posted by childofthe1980s at 5/2/2007 12:52:02 PM
It's a long story, as to why we ask this. But, here it goes.
About a week ago, we upgraded a Windows Server 2003 box from SQL 2000 to SQL
2005 service pack 2. Is it possible to go back to SQL 2000? Restoring a
backup is not an option.
We conducted this upgrade by installing a ...more >>
Changing the default database
Posted by spdude at 5/2/2007 11:55:57 AM
I have a large number of databases on my localhost. Whenever I open up
Management Studio, there is one database that is selected by default
(under Available Databases). But this is not the database that I use
regularly. Everytime I run a query, I have to make sure that the
database is changed.
SQL2005 Memory Question Again
Posted by skeeve at 5/2/2007 11:45:34 AM
Some facts regarding my problem:
- I am running the 64bit version of SQL2005 on a Win2k3 Enterprise
64bit installation with 8GB of RAM.
- I have configured the min/max values, but they seem to be ignored.
- The sqlserv.exe task never takes more than 200 to 300 MB, even after
Sql2k Maintenance plan error
Posted by Graham (Pete) Berry at 5/2/2007 11:27:45 AM
In trying to create a new maintenance plan via the wizard, the retention
type field for both the DB and the TL is blank. The plan seems to
create, but then updating it causes a Sql-DMO (ODBC SqlState:42000)
Error 8114: Error converting data type Int to TinyInt.
Graham (Pe...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Can not run DBCC Checkdb on database
Posted by Russell at 5/2/2007 10:29:16 AM
SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition
Can not run DBCC Checkdb on database because receiving the following error
Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State 1, L...more >>
Table Index Questions
Posted by Ben at 5/2/2007 10:13:10 AM
I'm not soo familiar with how the indexes work...
I'm seeing some slow performance on one of the DBs (netiq appmanager
product). The Disk queues & memory on the server seem fine. But the
processor maxes periodically with sqlserver.exe and queries time out.
I checked the DB size by r...more >>
connect to a specific port on sql server/endpoint
Posted by adba at 5/2/2007 10:11:02 AM
i have created a new tcp endpoint using the following:
CREATE ENDPOINT [CustomConnection1]
STATE = STARTED
(LISTENER_PORT = 1444, LISTENER_IP =ALL)
FOR TSQL() ;
And I got warning about permissions being revoked for the default tcp
endpoint, but I was okay with that since I really w...more >>
can not view DTS Packages and Jobs
Posted by RK73 at 5/2/2007 10:11:02 AM
I have SQL 2k SP4 on Windows 2003
Can A sqlserver user, with out having SA role, see the DTS packages, Job and
their status ?
Locks and Blocks
Posted by Audrey Ng at 5/2/2007 8:56:23 AM
I don't understand this.
I had SPID 104 blocked by SPID 87. However, SPID 87 was sleeping. How
can that be?
*** Sent via Developersdex http://www.developersdex.com ***...more >>
strange result with sp_dbcmptlevel
Posted by Radovan Dobriæ at 5/2/2007 8:32:03 AM
I am very confused with the result of 'sp_dbcmptlevel'
I have many databases on several servers (all upgraded from 2000 to 2005).
the stored sp_dbcmptlevel returs following:
exec sp_dbcmplevel @dbname='mydatabase'
The current compatibility level is 90.
Books on line have this sen...more >>
SQL 2005 developer edition . . . SLOW
Posted by SQL Dude at 5/2/2007 7:50:40 AM
I recently purchased a new development workstation (dual processor)
and installed the developer edition of SQL Server 2005 that comes with
Visual Studio. I also installed the Management Studio Express tools.
Everything SQL-related that I do on this new machine (application
access via ODBC, crea...more >>
Is there a run command to open enterprise manager?
Posted by Learner at 5/2/2007 6:44:54 AM
I know that to open Management studio I use "sqlwb" in the run
window from the start menu. Is there a run command to open up
Transaction log backup larger than actual transaction log
Posted by Markus at 5/2/2007 6:42:02 AM
I have a SQL database = 100gb and a transaction log file = 10gb running on
SQL Server 2005. When I perform a backup of each I get a database backup =
10gb and a transaction log backup = 36gb. Why is my transaction log backup
larger than the original transaction log? My recovery mode is Full...more >>
SQL Locking Issues
Posted by johncarter at 5/2/2007 5:03:42 AM
I have a strange problem with locking. I have a client server
application that uses SQL Server as the back end. For 5 years this
application has used SQL 7.0 without EVER one occurance of locking to
the point that all the users get frozen/blocked. About one year ago
we finally got off SQL 7.0...more >>
Difference between SQL Server 2000 and 2005
Posted by Viraj Rao at 5/2/2007 4:02:00 AM
I would like to know new features available in SQL Server 2005, compared to
those available in SQL Server 2000....more >>
SQL SRVR 2005 Standard - scheduled backup
Posted by r042wal at 5/2/2007 12:00:00 AM
I have SQL Server 2005 Standard Edition installed and I am trying to become
familiar with many of the new features. For now, I would like to schedule a
full backup to run daily. I have found the option to back up the database
and transaction log to disk, but I can not find where to schedule ...more >>
DTS Migration Wizard question
Posted by dc at 5/2/2007 12:00:00 AM
I've upgraded from 2000 to 2005, 2005 on a new server too.
I have moved a DTS package from the 2000 box to 2005 box & have performed th
DTS Migration Wizard.
Now I want to fiddle with the design of the package in Business Intelligence
Design Studio. Where the heck is it (the migrated pac...more >>
SQL 2005 - Backup Database Task - Folder Changing Issue
Posted by CGatto at 5/2/2007 12:00:00 AM
We've recently noticed a problem on our SQL Server 2005 (SP1) database
cluster (2 node fail over with shared RAID'd array HD) and its
implementation of the Backup Database Task. Our db cluster raided HD has
two mapped drives: G: is the data file location for the databases, and H: is