Using MS SQL Server
in [Microsoft SQL Server]
|
Could not execute a package by a scheduled job I try to set a job to run a DTS package, failed. My environment is SQL Server 2000 sp4 on windows Server 2003. There is a local window group called Dev_accnt including member SQLTesting who is a global account of domain Jackson. local group Dev_accnt assigned in SQL Server with Login name: LocalMachine\Dev_ac... 8 Jul 2008 07:57
dbcc shrinkdatabase Hello We use SqlServer 2000. I'm trying to run the "dbcc shrinkdatabase" command on a specific database. I keep on getting the message: DBCC execution completed. If DBCC printed error messages, contact your system administrator. I don't see any error messages but its obvious that the command never ran. The... 8 Jul 2008 05:55
DB Structure Advice - lots of measurements in DB or file refs? A project I'm thinking about, could use some advice from those who understand the dimensional limits of an SQL-like DB. Imagine, for example, a database containing detailed data for many cities during thunderstorms. Each time there is a storm, data collection begins, gathering "rain-drops-per millisecond" may... 10 Jul 2008 16:31
programmatically stopping and starting transactional replication Hello, Does anyone happen to know if there is a way to programmatically stop and start transactional replication? I would like to have this done without stopping the SQL Server Agent. Thanks, Bill ... 7 Jul 2008 14:33
login failed i am working in a virtualized environment where we've cloned a sqlserver to another vm. i've been checking my logs in the original server and there is a million log entries in the sqlserver logs with this entry: "login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (CLIENT: 1.1.1.111)" What do I need to do t... 7 Jul 2008 11:27
Data loss importing from Excel I'm trying to import a small spreadsheet from Excel into a pre-created SQL Server table. One column is defined as char(2), and the data values are actually 2 digits. When the leading digit is non-zero, the data transfers OK, but if the code is, say, '06', I get a null in SQL Server. I'm running SQL Server 2000, and... 8 Jul 2008 04:53
transaction log how do i find out what process could have caused a transaction log to fill up possibly over hte last 24 or 48 hours? thanks in advance ... 21 Jul 2008 07:54
How do I number an output field consecutively? I have a query that lists various records, but also should put a row count next to each. For instance No. Name 1 John Smith 2 Ravi Patel 3 Ronnie Oshinsky etc. the problem is I don't know how to get the consecutive numbers to go with the names. No numbers are stored in the database, just names an... 7 Jul 2008 10:25
Database management and latest updates on SQL server Find the latest updates in database management and SQL server tools and techniques. More tips about flowchart preparation, software testing and many more http://www.sqlserversoftware.blogspot.com http://www.infotechjob.blogspot.com ... 6 Jul 2008 21:10 |