SQL Newsgroups: Microsoft SQL Server Administration

End User Report Generators?

clintonG - 24 Nov 2007 5:47 PM - 1 message

A "desktop publishing" type of SQL report generator which can be run by the end user is what I am tasked to find. Your comments or referrals please... ...

Showing data from a procedure

MattIrwin via SQLMonster.com - 24 Nov 2007 5:13 PM - 3 messages

I have a procedure that deletes so many rows depending on the day. I want it to populate a table with how many it did. How could I do this? ...

SQL SERVER 2000

Ramanpreet - 24 Nov 2007 11:18 AM - 2 messages

Hi All, Good Morning. I Have installed SMS 2003 on one of my Servers with SQL Server 2000 as its database with SP4.Some days back my server started misbehaving for which i did a fast repair for the Operationg System which is windows 2003.After which ...

Odd query result in SQL server 2000

Eiriken - 24 Nov 2007 11:02 AM - 6 messages

Hi, I am running SQL Server 2000, SP4. I have stored procedure with a query like this: SELECT COUNT(*), -1 FROM PERSON_MEMBERSHIP PM LEFT OUTER JOIN PERSON_UNIVERSITY PU ON PM.PER_ID=PU.PER_ID LEFT OUTER JOIN PERSON_EDUCATIONTYPE PE ON PM.PER_ID=PE.PER_ID ...

Database compromise - need help

tnt - 24 Nov 2007 6:28 AM - 4 messages

Hello, Our db has been compromised. A column in the table has been changed to something unwarranted for. I need suggestions on how to track this or at least give me some clues on how these bastard made into our database. ...

Error when limiting memory usage with OSQL.EXE

Tom Del Rosso - 23 Nov 2007 8:34 PM - 5 messages

When trying to limit the memory usage of the SQL components of Small Business Server, I get an error message I don't know what to do with. I searched for an osql internal command reference, but all the references I ...

IIS Question

manu - 23 Nov 2007 8:24 PM - 2 messages

Hi, Please direct me to some good basic docs of IIS. I want to learn about IIS. Thanks in advance Manu Jaidka ...

Collate problems

Juan Manuel Alegría B. - 23 Nov 2007 6:42 PM - 2 messages

Hi group I have a problem with collations. Traditional_Spanish_CI_AS And Modern_Spanish_CI_AS Are de same? Because The server has Modern_Spanish_CI_AS And the database has Traditional_Spanish_CI_AS And somethimes in a stored procedure get an error but I dont identify where is taht error, The error is "Error near 'S' ...

Live server running out of space - Can't reduce Transaction Log!

Mike Owen - 23 Nov 2007 6:04 PM - 10 messages

Hi, I have just come across a bit of a problem of my Windows 200 server running SQL Server 2000.....I am running out of space! I have aout 2GB left. I have know this for some time, and for technical ...

Upgrading sql2000 SP3a to SP4

Lucazeo - 23 Nov 2007 4:13 PM - 1 message

I have 4 istances on a 3 node cluster. I need to upgrade only an istance from SP3a to SP4 and hotfix. Someone experienced something similar? Is it possible? Some suggestion? Thanks, Lucazeo. ...

Overwriting Backup Set

Shelley - 23 Nov 2007 3:57 PM - 9 messages

Hi, I did a full backup of my database, but everyday when it is backing up I would like it to overwrite the previous day's backup. I'm doing it thru Transact-SQL script(T-SQL) so i am entering the following ...

database and tlog backups - MSSQL 2000 & MSSQL 2005

morebeer - 23 Nov 2007 3:25 PM - 9 messages

hi all, as we have big problems with sql timeouts and deadlocks during the backup of the databases and transaction log, i am searching for a possibiliy to give the backup procedure a lower priority, so that the sql requests falling into that period don't fail anymore. is there a ...

SQL 2005 and Pervasive Linked Server

Steve Z - 23 Nov 2007 3:23 PM - 5 messages

We are migrating from SQL 2000 to SQL 2005. One of the requirements we have is to link to a Pervasive DB. We did this successfully under SQL 2000 with a SYSTEM DSN using ODBC. The LINKED SERVER ...

Error Connecting SQL Server 2005

carmen413 via SQLMonster.com - 23 Nov 2007 3:12 PM - 3 messages

Hi There, Any one can help me suggest what to do with below problem? while install SQL Server 2005, there is no Authentication Mode Option prompted out for users to select The Mixed Mode. This is installed using the correct Copyright from Ms SQL Server 2005 CD with Standard Version, where it ...

SQL 2000 Std on Win 2003 Std R2 x64 bit?

Leythos - 23 Nov 2007 1:10 PM - 4 messages

I have a IBM 3800 server with 8GB RAM (currently setup in Fail Over mode for memory - 4GB acts as a backup for the other 4GB RAM). The server has Dual Quad Core CPU's in it also. We run SQL 2000 Std with CPU licenses and I've limited SQL to 1.7GB RAM ...

accessing from T-SQL a database on another DBMS

wvandenbroeck - 23 Nov 2007 10:22 AM - 3 messages

tHi I want to build a trigger to modify data in a table in a database that is running on another Database Engine in may LAN. I don' t know if that is possible. If it is, how will I make the connection to that database? ...

SQL Express - Identity specification

Mike - 23 Nov 2007 7:54 AM - 5 messages

Hi, I use SQL Server Enterprise Manager for MS SQL Express and i want to change the column properites for [int] type of column, but I cann't change it. More in details... I'd like to set autoincremntal option and in order to change that I am ...

Column in profiler that shows no. of rows returned

Hassan - 23 Nov 2007 6:06 AM - 4 messages

I want to see for every stored procedure that completes, how many rows were returned as output ? Is there a column in profiler that shows that value or is there any other way to get it as opposed to running every query manually ...

Setting up SQL Relationships?

Mark Moss - 23 Nov 2007 4:29 AM - 2 messages

Help I have not worked with SQL Server For several years and I have the following question. I want to set up a relationship between a Parent Table and a Child ...

Why does MS SQL 2005 Management Studio runs/loads @ a snail pace?

stevong - 23 Nov 2007 3:32 AM - 5 messages

Hi everyone. Im not sure whether Im the only one facing this issue. Despite that MS SQL 2005 management studio is the only active application running on the foreground, it can load pretty (very) slow. Eg: you right click a table, to go into DESIGN mode - the mouse cursor ...

login failure

Hassan - 22 Nov 2007 9:09 PM - 2 messages

When do we get this error and why ? Login failed for user 'NT AUTHORITY\SYSTEM'. ...

Copy views from one database server to another

db - 22 Nov 2007 5:50 PM - 10 messages

Hi I have few views on SQL server 2000, which I want to copy to sql server 2005 database. I want to schedule a job to do it every evening. What is the best method to do this? Thanks ontario ...

SQL 2005 Send email via IMAP

Robin9876 - 22 Nov 2007 4:40 PM - 1 message

In SQL 2005 is it possible to send an email to account via IMAP over 128 bit SSL encryption? ...

Event 18454 connection non-trusted

pcnetnet - 22 Nov 2007 3:49 PM - 3 messages

Hi All, i don't know which problem or setting error ? the event log many many event on this "18454 Login succeeded for user 'Login1'. Connection: Non-Trusted " in 3 hours display 10000 record for this ?? how to disable ...

SQL server - cant see new backuped base

piwo - 22 Nov 2007 3:45 PM - 8 messages

Hi all! i got problem with one program which works on sql 2003 server. We backuped data from other base and created new base on other server. When we try to connect from client to that base - we cant see our new base in chose base ...

SQL 2005 Embedded

S Sainsbury - 22 Nov 2007 3:44 PM - 2 messages

I have the embedded version of SQL 2005 installed in conjunction with sharepoint on a W2k3 server. Im trying to migrate the database to an SQL server, to do so I first need to use the SQL Management Studio to perform a backup, which inturn I will use to ...

Entire 2005 Database deleted

CF - 22 Nov 2007 10:50 AM - 2 messages

The Database Name is showing up but there are 0 items contained in it. ldf and mdf files deleted. Not deleted by Users. Event log shows a problem reading a backup tape. ...

HT sp_help_jobschedule results?

Zekske - 22 Nov 2007 10:40 AM - 3 messages

I found in BOL the meaning of the values but is there a script I can use to get an overview of the scheduling information for all my jobs with a result everyone can understand (f.e every sunday at 8am?) ...

"Add user or Group" button greyed out in "Lock Pages in Memory" wi

NeilW - 22 Nov 2007 10:27 AM - 1 message

I am trying to set up a service account in the "Lock Pages in Memory" window but the "Add User or Group" button is greyed out. I am logged on as an Administrator. Does anyone know why this is? The OS is 2003 R2 Enterprise Edition and we are using SQL Server 2005 ...

security connection is or not

ddoc - 22 Nov 2007 9:15 AM - 2 messages

hi, I should to secure connection to sqlserver. So actually I use two type of connection : authentication windows or by sql. -Is-it secure uuthentication windows ? In that case, the user is already authenticate with the domain and I think the password won't be send other time to sql, maybe it's just ...

Regarding Transaction Log

Balaji - 22 Nov 2007 8:56 AM - 5 messages

SQL Server book online says â€œLog records are written to disk when the transactions are committed.â€ In case of re-indexing how does it work. I understand the re-index is done as one single transaction which means the ...

Trigger to fire only after a commit.

Avi - 22 Nov 2007 8:30 AM - 7 messages

Hi Experts, I would like to know if there is a way to have triggers that fire only after a commit. If not, is there a workaround that will give me the same affect? Avi ...

Re: How to tell sql server the maximum size my temp table will grow so that it does at most 1 memory

Andrew J. Kelly - 21 Nov 2007 10:53 PM - 1 message

Please don't post independently in separate newsgroups. You can add multiple newsgroups to the header and then all the answers appear as one. See my reply in the other newsgroup. ...

job fails for sql 2005 run SSIS package

Paul - 21 Nov 2007 10:34 PM - 2 messages

Hi, I created an SSIS package and deployed it by using the wizard that is invoked when selecting the SSISDeploymentmanifest file. The deployment worked as I can run the package from sql server management studio under MSDB by right clicking and selecting excecute package, in the object explorer. ...

Optimizing and shrinking large highly-transactional database

Curtis - 21 Nov 2007 9:00 PM - 6 messages

Hi, I have a 50GB database on SQL Server 2000 Enterprise that is highly transactional in a 24x7 environment. There's approximately 8 GB of free space, so I want to shrink it. It has been online for over five ...

Logging from SP

Mohit K. Gupta - 21 Nov 2007 8:56 PM - 4 messages

Hi, Is there a way I can log to a output file from a SP when executed from with in an application? ...

Is the same?

Paulo - 21 Nov 2007 8:34 PM - 5 messages

Select DateField from table where Month(DateField) = 11 and Year(DateField) = 2007 and Day(DateField) = 21 and Select DateField from table where DateField = '20071121' What should I use?? Thanks a lot! ...

cannot drop mdf file

Roger - 21 Nov 2007 8:07 PM - 4 messages

Hi All, I cannot drop a mdf file that don't have a database but is in data directory,. Can you help-me ? I'am using sql server 2005. TIA ...

Update Timeout and indexes

Jim - 21 Nov 2007 7:38 PM - 12 messages

Hi, I have two questions about Updating a large table. It has about 40 million rows. When I try to do an update on one of the fields, it goes on forever until I kill it. The last time this happened, after I ...

sql2005 data backup

mecn - 21 Nov 2007 7:15 PM - 2 messages

hi, I setup a data backup job in sql2005. I don't see keep 2 days(delete the dumps beyond 2 days like sql2. ANyone knows? Thanks ...

sql server 2005 upgrade

Ellie - 21 Nov 2007 7:13 PM - 4 messages

When upgrading the mssql2000databases to mssql2005 do you reccomend sql clents upgrade on the data consumer machines? Thanks, ...

Linked Server Properties - Security - SQL Server 2000

Steve Wilkinson - 21 Nov 2007 6:44 PM - 4 messages

I would like to specify a locallogin that is a domain(not local) group. It allows me to specify it, but does not recognize when memebrs of the group are connected. I have been forced to specify each group memebr individually. Is ...

sp_addlinkedsrvlogin syntax for "not be made"

Steve Wilkinson - 21 Nov 2007 6:38 PM - 4 messages

I am scripting my linked servers. I have specified several specific local ids that will connect with a specific remote id. i would like any '...Login not defined in the list...' to not make a connection 'not ne made option'. ...

Identity values not replicated even though 'not for replication' is set

pshroads - 21 Nov 2007 6:27 PM - 1 message

I need to use transactional replication to replicate from a SQL Server 2005 machine (publisher) to a SQL Server 2000 machine (subscriber). The data will be the same on both servers when I start the replication so I will not be initializing using an snapshot. The identity columns ...

can't start SQL Server Analysis Services

Paul - 21 Nov 2007 6:23 PM - 2 messages

Hi I am using SQL 2005 but when I go to the SQL Server Configuration manager and try to start the SQL Server Analysis Services, I get the error message Requiest failed or the service did not respond in a timely fashion. ...

rollback in trigger

nima_kashian - 21 Nov 2007 5:02 PM - 2 messages

hi I try to test the following condition: 1-The trigger continues executing any remaining statements after the ROLLBACK statement. If any of these statements modify data, the modifications are not rolled back. 2- No nested triggers are fired by the execution of these remaining ...

Is there any way we can handle cross database transaction on mirrored database??

DNB - 21 Nov 2007 4:46 PM - 2 messages

Is there any way we can handle cross database transaction on mirrored database?? THanks DNB ...

copy many ssis packages between servers

Piotr Lipski - 21 Nov 2007 4:26 PM - 4 messages

Hi. Is there any simple way of copying all of the ssis packages between two servers? I have just installed sql 2005 on a new, better equipped machine and I have to move there all the data. Including ssis of course. There are about 40-50 ...

CPU dedicated to one Stored Procedure

Abel - 21 Nov 2007 3:56 PM - 6 messages

Hi, I have one Stored prodecure that need too much time to finish. When this SP runs, it uses 100% of all CPUs that I have in the SQL server machine. How can I dedicate one CPU to work with this SP and leave the rest of CPUs ...

Backing up to a server on another domain ?

pcmangler - 21 Nov 2007 3:17 PM - 3 messages

Hi, I'm trying to get a SQL 2005 server to backup it's databases to a shared folder on a server on another domain. It used to work with older versions of SQL by setting up a null session share on the ...

Stranger than Fiction: differences in Edit vs Design a view

aaqqqa - 21 Nov 2007 2:58 PM - 3 messages

In SQL Server 2005 Management Studio, When looking at a view in a SQL Server 2000 Enterprise Edtion (SP4) database I see 1 version in "Edit" and a completely different version of the view in "Design". For example in "Edit" I see something like (which is the same as in SQL ...

Telling a user of an error in a function

Avi - 21 Nov 2007 2:42 PM - 4 messages

Hi all, I read that it is not possible to raise an error in a function. Please advise how I indicate to the user that an error occured and how I can pass the error message to the user. ...

SSIS Execute button greyed

Jay - 21 Nov 2007 1:36 PM - 2 messages

I'm trying to use SSIS to build a package, but was having some issues. So I buillt a test case on my laptop (2005 SE on XP Pro). However, now the run/debug button is grey and I can't execute it. ...

I want to recover deleted database from SQL Server 2000

skbhaduri - 21 Nov 2007 11:12 AM - 3 messages

Hi All Somebody deleted a database from my SQL Server 2000 server and I have to recover it. I dont have any backup of the database. Can anyone help ? Thanks S. K. Bhaduri ...

I want to recover deleted database from SQL Server 2000

skbhaduri - 21 Nov 2007 11:12 AM - 2 messages

Hi All Somebody deleted a database from my SQL Server 2000 server and I have to recover it. I dont have any backup of the database. Can anyone help ? Thanks S. K. Bhaduri ...

SQL Server 2000 database owner question

Jason Huang - 21 Nov 2007 8:15 AM - 4 messages

Hi, In my SQL Server 2000 Enterprise Manager, I have created a new Login account JJ. I also created a new database DBJ. What do I need to do to make JJ the owner of the DBJ? Thanks for help. ...

When does my Evaluation Edition license expire?!!

Zarko Jovanovic - 21 Nov 2007 8:02 AM - 1 message

We installed sql server 2005 Evaluation Edition. How can I know when does it expire? tia ...

Remote Backup - Online Remote Backup Services | TDBackup.com, Anaheim Hills, CA

janebush08 - 21 Nov 2007 6:23 AM - 1 message

TDBackup.com provides secure remote backup, online data backup solution, offsite backup services at affordable rates. It also provides 1 Month Free Service so that you can analyze the service and rely fearlessly after subscription. TDBackup GUARANTEES hassle free recovery of any backed up files from ...

BOL - Katmai

Alan T - 21 Nov 2007 12:08 AM - 10 messages

What is the differences between the downloaded Katmai BOL and the installed SQL Server BOL? ...

how to append 2 fields together

Paul - 20 Nov 2007 11:41 PM - 3 messages

Hi I am inserting some data into a temp @table and trying to combine two different fields with the + character so in the insert statement I have, Case when E.ColorID IS NOT Null then TE.equipmentName + (Select [Color] from Color Where ID = E.Color_ID) END AS EquipmentName ...

distributed transaction issue

jeff_y - 20 Nov 2007 10:20 PM - 2 messages

Dear gurus, Your help is greatly appreciated... My environment: SQL Server 2K5 EE SP2 build# 3154 on Windows 2K3 SP1 I have three servers: Server_1, Server_2, and Server_3 My issues: I have the issue between Server_1 and Server_2 when I start a distributed ...

Records Versioning/Auditing

David Lozzi - 20 Nov 2007 9:14 PM - 4 messages

Howdy, Forgive me if this is the wrong group. I'm writing a ASP.Net application and i need to track every change to a table's records. In SQL 2005, is there a way to easily keep a record change history? Something with rules or triggers ...

How to solve Deadlock

guest5 - 20 Nov 2007 8:53 PM - 4 messages

Hi We are seeing frequent deadlocks on a single update statement that regularly is run by the app providing different parameters. Setting trace 1204, 1222 indicates its deadlocking on a page. Unsure how to solve this issue. Anyone able to advise? ...

how to determine what indexes are being used.

Tom - 20 Nov 2007 8:17 PM - 4 messages

I have inherited a few tables with muliple indexes, is there a way to determine which indexes are actually being used? Both in 2000 and 2005 versions, either by some system view, tracing (what event to monitor), etc. Thanks ...

The affinity mask specified does not match the CPU mask on this system

jmcl4video - 20 Nov 2007 7:37 PM - 7 messages

We are having a problem with one of our SQL servers, and in comparing it to the backup server which is working fine, I noticed some differences. I attempted to correct the differences, but no luck. The dell server has 4 dual-core processors and at one point hyper- ...

Creating indexes

NC3 - 20 Nov 2007 7:02 PM - 4 messages

I need to improve the performance of a query that is scheduled to run every 5 minutes but is now taking longer than 5 minutes to execute. I want to add an index or 2 to the table but I'm not sure of the ...

How do I view trace flag output

Chris - 20 Nov 2007 5:17 PM - 2 messages

I am trying to troubleshoot a frequent deadlock and I found an article that says to run the following command: DBCC TRACEON(3605, 1204) I did this, but where does the trace output go? Chris ...

ms sql cluster: should i and how to place tempdb on local drive

Gene. - 20 Nov 2007 4:22 PM - 6 messages

Hi all we are about to set up database on sql server cluster. Up to this point we had set up ms sql cluster using vm. My intention was to set up tempdb on local c drive. It turned out, that we ...

SQL on WHS

Daniel Jameson - 20 Nov 2007 4:19 PM - 1 message

Hi, Are there any issues with installing SQL 2005/8 on the new Windows Home Server? ...

BCP import large text file to sql tables

mecn - 20 Nov 2007 4:03 PM - 5 messages

hi, I have a huge text file(about 10 GB) that needed to imported to SQL server2k table. I know BCP is the fastest way to do it. But if I use BPC, my log shipping to a prod standby serve will not have BPC transactions. ...

Invalid object name 'information_schema.constraint_table_usage'

scuba79 - 20 Nov 2007 3:39 PM - 5 messages

I created a new database on a SQL 2005 server, which also contains other databases. I just tried to run "select * from information_schema.constraint_table_usage" and got an error Msg 208, Level 16, State 1, Line 1 Invalid object name 'information_schema.constraint_table_usage'. ...

For Xml Auto Problem

Looch - 20 Nov 2007 3:01 PM - 2 messages

Hi All, I'm running a query such as [select * from table1 where OrderNumber = 123 for xml auto] and saving the results to an xml file (right clicking the "link" in the results pane that holds the info and saving as an XML ...

Backup fail on msllockdb & pwe files

Saucer Man - 20 Nov 2007 2:45 PM - 2 messages

We use Arcserve for our backup software. Everynight, we get errors that msllockdb.mdf, msllockdb_ldf, pwe.mdf, & pwe_log.ldf cannot be accessed because they are being used by another process. Does anyone know what is causing this and how to correct it? ...

SQL Server Transaction Log growing

dylan - 20 Nov 2007 2:20 PM - 11 messages

I've got a SQL 2005 server who's transaction log is growing significantly each day. At night, I do a transaction log backup using Backup Exec 11d which I had thought would commit transactions in the log so that the log entries could then be overwritten, but this does ...

index on computed column ignored

DAXU - 20 Nov 2007 1:05 PM - 2 messages

Hello, I have a non-unique, non-clustered index on a computed column: SET ARITHABORT ON SET CONCAT_NULL_YIELDS_NULL ON SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON SET NUMERIC_ROUNDABORT OFF CREATE NONCLUSTERED INDEX [IX_tbVehicleMain_ComputedYearTest] ON [cweb].[tbVehicleMainTest] ...

System table with max and min values for all SQL data types

Avi - 20 Nov 2007 11:55 AM - 4 messages

Hi all, Is there a system table/view that lists all SQL data types with their accepted values (min value and max value) Thanks, Avi ...

Why sql server always choose index scan instead of index seek for my query?

DAXU - 20 Nov 2007 11:07 AM - 4 messages

Hi, I have a table like: { id int, make varchar(50), model varchar(50) } ID is primary key and has a clustered index on it. Make and model has a non-clustered and non-unique index on it. ...

SQL Server 2005: log shipping

adhodgson - 20 Nov 2007 9:40 AM - 4 messages

Hi, I am trying to set up simple log shipping from one SQL server to another. The other server is on a different network, and I believe I am using "pass-through" authentication, where I have set up the ...

SQL 2000 : space available is zero

Nitz - 20 Nov 2007 9:14 AM - 4 messages

I have SQL 2000 SP3. When I right click on my database (SMS Site Database), I see space available=0. Is it an issue?? If yes, What do I need to do?? ...

need urgent help

Bhishm - 20 Nov 2007 7:11 AM - 3 messages

Hi, I am creating a attendance sheet software for inhouse use. my data is like this:- ------------------------------------------------------------------------------------------------ time | ------------------------------------------------------------------------------------------------ 16:00:00 | ------------------------------------------------------------------------------------------------ 18:00:00 | ...

log shipping status

Hassan - 20 Nov 2007 3:56 AM - 2 messages

We have set up log shipping in standby mode so users can run some reports. Every once in while, the restores long runner and our users would like to know how much more time before its done. Is there any query they could run to see what files its restoring or the ...

Profiler complaining about "Sort Warnings"

Hassan - 20 Nov 2007 3:39 AM - 2 messages

I used the Errors and Warnings event and i see quite a few of sort warning throw up.. Only problem is thats all I see too. For starters what does it mean ? And how do I figure whats causing it ? ...

I have a CLR function thet returns IEnumberable (a table) and it has a FillRow function. I am return

DR - 20 Nov 2007 3:37 AM - 1 message

I have a CLR function thet returns IEnumberable (a table) and it has a FillRow function. I am returning 10,000 integers from this function. Is there any way that I can preallocate the resulting table or give SQL server ...

Snapshot size

Alan T - 20 Nov 2007 2:58 AM - 10 messages

I created a snapshot of AdventureWorks. However, when I inspect the snapshot database file, it says size: 179MB size on disk: 192 KB What is that mean? ...

I dont see any hostname in sysprocesses

Hassan - 20 Nov 2007 1:28 AM - 4 messages

Why do I not see the hostnames in my sysprocesses ? I am trying to find the names of hosts connected. I see a net_address column. How can I track the hostname from the net_address? Also how can I ensure we get the hostnames to display..i..e. how do I get ...

Set recovery model

Alan T - 20 Nov 2007 12:53 AM - 3 messages

How do I set a database from simple recovery model to full recovery model in MSMS? ...

A column nullability inconsistency was detected in the metadata E

Aaron - 19 Nov 2007 10:31 PM - 2 messages

Hello, I am trying to restore a backup of a database that was taken in SQL Server 2000 onto SQL Server 2005. It appears the action completes, but I get a list of errors. I have ran a checktable on the tables in question on both ...

sql 2005 - which role allows to read ddl but not to modify it?

newToSql - 19 Nov 2007 10:15 PM - 4 messages

hi, I need to grand enough permissions to a user to read database ddl (table, sp, function, etc... definitions ) but not to change them. to which role shall I assign the user to? Thanks ...

SQL Server better than DB2

Ian Boyd - 19 Nov 2007 9:56 PM - 8 messages

About two years ago we had to deal quite heavily with DB2. DB2 is a monsterous mess. Having used SQL Server so long i felt like i was being tortured with DB2 and it's tools. i had a few back and forth conversations ...

Log parser

Hassan - 19 Nov 2007 9:51 PM - 2 messages

Can someone send me the command to import the application and system log of the eventlogs into SQL Server for say 2 different servers ? Does the command have to run every few mins ? How does it handle duplicates,etc. ? I would like to have the logs in the database no later ...

Update copied DB

Stup88 - 19 Nov 2007 9:14 PM - 2 messages

I need to refresh a test db from the production DB but need to save some tables in the test db.. Is there a way to do this ? without using a third part app ? ...

Sql Server 2005

Salahu - 19 Nov 2007 9:00 PM - 3 messages

Hi When i take back up database I got below error. System.Data.SqlClient.SqlError: The backup of full-text catalog 'Help_Topics' is not permitted because it is not online. Check ...

Lost SEK

sql-guy - 19 Nov 2007 8:59 PM - 4 messages

I have MSSQL 2000 (Version 8). I can not find the SEK. Where on the installation can I find it or table I can query to find it. ...

Tempdb - Device not ready

DnBDBA - 19 Nov 2007 8:36 PM - 3 messages

Hi. I have a dev database server where the tempdb database is on the G: drive. For some reason, SQL Server keeps giving me an error message saying "The device is not ready". I can get to the drive, and I can even do an ...

Date Sql 2000

Paulo - 19 Nov 2007 8:08 PM - 5 messages

Hi, how can I return from database all the records (DateTime column) from a range like: mm/yyyy? Select DateField from Table Where Convert(DateField, 'mm/yyyy', datetime) = "11/2007" ? Something like that? Thanks a lot! ...

How to catch io's for tsql execution.

Gene. - 19 Nov 2007 7:31 PM - 2 messages

Hi gurus. I want to catch execution statistics like 'reads', 'execution time' for some reports. I know I can run it with 'set statistics io on' but it does not effectively servers the purpose since output can be truncated from sql agent history. ...

SQL 2008 system requirments

Stup88 - 19 Nov 2007 6:27 PM - 3 messages

Does anyone know if SQL 2008 will require 64 bit versus 32 bit .. Just wondering If I need to upgrade HW along with software. Thanks ...

Is SQL Express 2005 by default a single connection db?

RGF - 19 Nov 2007 6:26 PM - 2 messages

Is SQL Express 2005 by default a single connection db? Background: I wrote a simple .bat file which executes the following sqlcmd call: "sqlcmd -S BLUEBOX\SQLEXPRESS -d C:\App_Data\ASPNETDB.MDF -U MyUserCount -P MyUserPassword -Q "Exec SendMessage" -o C:\Vocalico ...

Converting

Paulo - 19 Nov 2007 6:04 PM - 2 messages

Hi, can you help me converting some queries from ASP application Oracle to SQL SERVER 2000? example: 1) " and p.DATACAD <= to_date('"& BDATACAD2 &" 23:59:59','dd/mm/yyyy hh24:mi:ss')" 2) " WHERE TO_CHAR(DATA_HORAS,'MM/YYYY') ='"&SEL_PER&"'" ...

Database Maintenance Plans

cc.shine - 19 Nov 2007 5:27 PM - 4 messages

I've set up a Database Maintenance Plan that Checks Database Integrity, Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up History. If I set the plan to perform these tasks on either All Databases or All User Databases, will new databases be detected? Or would I need to recreate the ...

Indexes . . .

RE: KB928365 and 'Internal .Net Framework Data Provider error 6' issue

Multiple mirrored databases

Transaction Log Backups Failure

Cleaning up goldmine Data

SQL Server service will not start.

sql server 2005 sp2

Change minimum database size from 3mb to 2mb

Distribution licensing

SA user lost SYSADMIN RIGHTS

Transaction Log

SQL Server 2000 deleting log shipping plan

No. Of Records inserted into a table/database

SQL 2000 big .ldf file

Transaction Log Writes

RE: I/O request taking longer than 15 seconds to complete

restoring msdb with SQL 2000

SQL 2005 has a restore problem

Report server SQL 2005

Urgent: query analyzer

Unable to delete old backups

ssis and excel

Database Backup Problem

statement_Start_offset again

SQL2005 sp2x64 won't start Error: 26024, Severity: 16, State: 1 TD