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
What is ORM ?
Posted by Hassan at 2/21/2006 11:09:24 PM
I believe its different from ER modelling ? Can one model SQL server systems
using ORM ? Sounds like a dumb question.. But can someone give me more info
or provide links about ORM and SQL ?
Error 1068 Can't start SQLSERVERAGENT and MSSQLSERVER
Posted by misecprj NO[at]SPAM hotmail.com at 2/21/2006 10:42:36 PM
On manually starting SQLSERVERAGENT service, it gives the following
error 1068: The depending service for group failed to start.
Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
Some problem with SQL Server 7 and ldf file
Posted by Some problem SQL Server 7 at 2/21/2006 6:11:27 PM
I have a problem with SQL Server 7.
c_base_data.mdf - c_base_log.ldf
The file c_base_log.ldf have become of 15 GB. I have tried to reduce the
LOGICAL dimensions with one backup of TRANSACTION LOG and until here all ok.
After with command DBCC SHRINKDATABASE or DBCC S...more >>
new login, EXECUTE permissions
Posted by sklett at 2/21/2006 5:56:43 PM
I'm a newbie to the admin side of SqlServer. I created a new login:
CREATE LOGIN pmd_app
I then used the "Server Management Studio Express" to create a new user in
my DB with the same name, then give the logical permissions, at least
logical to m...more >>
Constant locking issue
Posted by MC at 2/21/2006 5:28:06 PM
I have a SQL server 2000 running on windows 2000 server, SP4 (4 CPU, and 2G
We use this for Maximizer ECRM application, but lately (past 2-3month) we
seem to get more SQL locking issues while running application.
When I try to kill the proccess that causing the lock, it still show...more >>
Keeping the CPU load to 50%
Posted by Bhagwati at 2/21/2006 5:08:28 PM
I have a stored procedure which does intense calculations. It does
calculations against millions of records and when it is executed the CPU
performance goes up to 100%. Is there a way in SQL queries which specifies
that CPU performance should not go beyond 50% for that particular stored...more >>
Old backups are not deleted
Posted by rupart at 2/21/2006 5:02:29 PM
I find out that if you use DMP and change the backup path from default and
set the settings to delete old backup , say after 3 days, it doesnt really
delete them. IS it a bug? Is there any fix for it? It happens in SQL2000 as
well as in SQL2005
Snap-in failed to initialize in Microsoft SQL Enterprise Manager
Posted by Tony Girgenti at 2/21/2006 4:01:51 PM
We SBS2000(SP4) with SQL2000 installed. When i attempt to run the SQL
Enterprise Manager, i get the following error:
Snap-in failed to initialize
Name: Microsoft SQL Enterprise Manager
Does anybody know how to resolve this ?
Any he...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
2005 remote connection problem (yes, I have enabled TCP/IP)
Posted by sklett at 2/21/2006 3:44:54 PM
I've gone through about 30+ google results looking for the magic answer to
this problem. I have a brand new machine with a brand new install of Sql
Server 2005 express. I am trying to connect via SQLCMD in a command window
with the following info: SQLCMD -S 192.168.1.103 -U **** -P ******!
Moving Data Files
Posted by Chris at 2/21/2006 3:26:27 PM
I program in SQL Server 2000 and need to know the procedure for moving
database data files from one drive to another. I have outgrown the original
hard drive and have added a second one. I have done somw research and the
research has suggested adding another file to the file group on the new d...more >>
how should users' domain be changed?
Posted by bing at 2/21/2006 2:58:28 PM
Right now, our SQL 2000 server has both local and domain users. Domain
user's login is something like 'olddomain\someuser'. There are quite a few
domain users. Now we need to move the SQL server to a new domain. The
question is how to change their logins to 'newdomain\so...more >>
help with query
Posted by Paul at 2/21/2006 1:11:27 PM
HI I have a table that someone else designed like
* employeeid * firstname * last name * supervisor_id *
* 1 * Paul * Sed * 2
SQL Server Management Studio Issues
Posted by Ron at 2/21/2006 12:20:42 PM
We are in the process of migrating from SQL 2000 to SQL 2005 and there
are some features of Enterprise manager that I really miss.
1. I have not found a way to generate an sp script in management studio
in ANSI format that has the drop statement, the sp screate statment and
the security as...more >>
SQL 2005 and MOM 2005
Posted by dreller at 2/21/2006 11:41:28 AM
Does anyone know why MOM 2005 won't install on a SQL 2005 instance? I was
hopeful that SP1 for MOM would resolve that problem, but it hasn't. I'm
waiting in anticipation of the day I can do this....more >>
Q: format convert
Posted by JIM.H. at 2/21/2006 11:16:26 AM
I have a phone number field with the format (123)-456-7890 I need to convert
this to 1234567890 formats while I am retrieving data from the table. How can
I do this?
Backup - just last 4
Posted by David Thielen at 2/21/2006 10:47:29 AM
I know this can be done because I have done it before - but I can't find the
I have a job (SQL Server Agent) that does a backup of the database once a
day. How do I set it to save just the last 4 backups and delete any that are
thanks - dave
Turn Off Defered Name Resolution ?
Posted by Ike the Potato at 2/21/2006 10:32:57 AM
Any way to turn OFF deferred name resolution?
Looking for something like Option Explicit in the old Visual Basic.
Trouble with suspect Database
Posted by Christian Allard at 2/21/2006 10:25:38 AM
My post wasn't in the right thread sorry bout this that's why I'm reposting.
I also find out it's happening at the end of a big replication
initialize (3000000 rows).
So the problem is:
I'm having trouble with a database constantly becoming suspect.
The log is the following:
Backup Failure - Delete old files
Posted by helpplease at 2/21/2006 10:20:27 AM
I have setup my backup job to delete file older than 12 hours. I want to
keep atleast 2 backup files saved. The backup runs every night.
My backup job fails on alternate days.
The day it fails, it completes just 2 steps 'backup database' and 'verify
The day is completes su...more >>
sql 2k reindex
Posted by mecn at 2/21/2006 9:54:58 AM
I have a large dataabase doing reindex weekly and failed every time running
My question is that the reindex increase the sql log file? for some reason
the database doesn't have much activitiies during the weekends but the log
file increased a log --- 30 G.
.. If yes, is the...more >>
How do you copy tables and procs in SQL 2005?
Posted by Jason Rodman at 2/21/2006 9:48:28 AM
Am I an idiot, or is there no easy way to do this in SMS2005? I click on a
table, choose "Import Data" and I can only copy data between tables? What
about stored procs, UDFs, etc? I cant even figure out how to get it to drop a
table at the destination database because the option is grayed out....more >>
Creating stored procs with MSforeachdb
Posted by sfp at 2/21/2006 8:52:15 AM
I'm trying to create stored procedures in about 85 databases. I keep
running into the problem 'Incorrect syntax near the keyword
declare @cmd1 varchar(500)
set @cmd1 =
'if ''?'' like ''%_06'' CREATE procedure newproc AS select * from
exec sp_MSforeachdb @command1=@cm...more >>
How see information in transaction log file (*.ldf) - URGENT!!!
Posted by Pasquale at 2/21/2006 6:26:29 AM
A database of a my customer is corrupt.
The file *.mdf is lost (perhaps deleted!). I have only the last transaction
none backups of logs; moreover I have the last backup of mdf file.
I cannot create a backup of the transaction log to retrieve the db.
I would like to view into log fil...more >>
Error 602: Could not find row in sysindexes for....HELP HELP HELP
Posted by Prateek Baxi at 2/21/2006 6:26:27 AM
I am getting following error in SQL Server (SQL Server 6.5) Log.
"Could not find row in sysindexes for database ID %d, object ID %ld, index
ID %d. Run DBCC CHECKTABLE on sysindexes"
I have checked on MSDN but no help. The MSDN artical is saying that there
could be some SP that is ud...more >>
Tools for uninstall CTP
Posted by ad at 2/21/2006 5:27:21 AM
It is hard to unisntall SqlServer 2005 ctp from control pannel.
Have there any tools to uninstall it?
SQL Server 2005 Standard Backup routines
Posted by timeshift at 2/21/2006 5:25:50 AM
First of all, I am totally new to MSSQL server, both sql server 2000
and sql server 2005, i've never touched any of them before.
I just did a standard install of SQL server 2005, to be used in a
hosting environment. I've added a couple of databases and logins, and
they are working fine....more >>
Using Like Operator
Posted by SouRa at 2/21/2006 5:11:26 AM
I have table with varchar column, it contains values like
452,452.1,452.2,452.3 ... etc
I want to select the 450,450.1,450.2,450.3 values only,
How can i select these values using like operator.
Please advise me.
Convert SQL 2005 to MSDE
Posted by Joe Pannone at 2/21/2006 5:10:29 AM
Is there any way to convert a SQL Server 2005 (v9) database to a MSDE (v8)
SQL Server Log showing many starting up db
Posted by maxzsim via SQLMonster.com at 2/21/2006 5:03:58 AM
I have checked the current SQL Server Log and i could see there were many
records of "starting up DB1" within a few seconds of each other
what does it means , i would think that these would appear only after you
have startup the SQL Server ?
whereelse could i go to check further ?...more >>
Clear connections to DB
Posted by Gary at 2/21/2006 4:00:33 AM
In enterprise manager when detaching DB, there is an option to clear open
connections without actually detaching a database.
I'm looking for the sp with the ability of clearing cconnections.
I failed looking it up in books on line.
I'm using SQL 2000
I would be grateful for any h...more >>
Linked Server Problems HELP HELP HELP !!!
Posted by paul_30s NO[at]SPAM hotmail.com at 2/21/2006 3:33:54 AM
having a LOT of problems with SQL server linked servers.
I have a server running Windows Server 2003. (Server A)
I want to run a query from a different server (Server B) using query
E.g SELECT * FROM [SERVER A].DBName.dbo.tablename
keep getting the following message
Login faile...more >>
SQL Server 2000 - consumes 100% CPU
Posted by Dariusz Tomon at 2/21/2006 12:00:00 AM
I have got problem with my SQL Serv. 2000. It consumes almost 100% CPU. The
scenario for that is:
1) database: 1GB
2) IIS + ASP.NET
This database is for internet webpage.
Till this moment everything was ok. But suddenly SqlServ started using all
The question is: ...more >>
SQL Mail not sending email when switch to another user
Posted by maxzsim via SQLMonster.com at 2/21/2006 12:00:00 AM
Previously i have setup OutLook 2002 wif SQL server 2000 and was able to
send email with the OutLook opened.
I was logged in as test\user1 which the SQL Server service uses to start as
well. So i close OutLook & send an email from SQL.
i logged in as test\user2 and i realised that ...more >>
starting full-text search - error 1722
Posted by j.goines at 2/21/2006 12:00:00 AM
i want to start full-text search on sql-server 2000.
when trying this with enterprise manager i get error message "error 1722
(rpc-server not availaible)"
the mssearch server can be started within mmc.
but if it is not started within enterprise manager the option to add a table
to ...more >>
Timeout During Tape Format
Posted by Andrew Hayes at 2/21/2006 12:00:00 AM
Executing this command:
BACKUP DATABASE master TO TAPE='\\.\\Tape0' WITH FORMAT,
Gets this result:
Server: Msg 3229, Level 16, State 2, Line 1
Request for device '\\.\\Tape0' timed out.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminatin...more >>
Posted by David C at 2/21/2006 12:00:00 AM
During the installation of SQL 2005, I got this error
"The file C:\Windows\Microsoft.NET\Framework\...\mscorlib.tlb could not be
loaded. An attempt to repair this condition failed because the file could
not be found.
Please reinstall this program."
When I clicked OK, the install procee...more >>
Pivot can not be used in VIew
Posted by ad at 2/21/2006 12:00:00 AM
I use PIVOT when I create a view, but it is fall to save.
How can I do?