Microsoft SQL Server Administration

upgrading to SQL 2005 using the Copy Database Wizard

childofthe1980s - 7 Apr 2007 6:42 PM - 2 messages

Hello: If you have a fresh install of SQL 2005 and you want to use the Copy Database Wizard to upgrade the SQL 2000 databases to SQL 2005, does the Copy Database Wizard create your SQL 2000 databases in the new SQL 2005 ...

can SQL 2000 still be used after the upgrade?

childofthe1980s - 7 Apr 2007 6:00 PM - 2 messages

Hello: Let's say that you have SQL Server 2000 SP3 on a server, and let's say that you upgrade SQL 2000 to 2005. It's a long story as to why I ask, but is it possible after the upgrade to ...

sqldumper

jona prenci - 7 Apr 2007 4:36 PM - 2 messages

Hi, Anytime I start the PC the following message appears: "SQLWriter SQLDUMPER library failed initialization. Your installation is eitehr corrupt or has been tampered with. Please uninstall then re-run setup to correct this problem." Any idea how to resolve it? ...

SAN Replication for DR site

Hassan - 7 Apr 2007 3:44 PM - 9 messages

Does anyone use SAN Asynch Replication for Disaster Recovery to a secondary site ? If so, are there any issues with it at the production site i.e. the source when you set it up,etc. ? Also when you break the link to test the DR i.e. bring the secondary site ...

SQL job timing out

Alesandro - 7 Apr 2007 3:24 PM - 2 messages

Good day, Since we upg to SQL 2005, we have certain SQL jobs that are erroring out with the following msg : QUOTE Executed as user: DOMAIN\SqlUser. You have been timed out of the system. Please login again: 466670433 [SQLSTATE 42000] (Error 70813). The step ...

Monitor Database Mirroring

Hassan - 7 Apr 2007 6:13 AM - 2 messages

Does database mirroring have any monitoring capabilities like Log shipping to let the DBAs know the current status of the mirrored server i.e. how far behind the principal it is,etc. ? ...

SQLServer 2000 isql error

rgn - 7 Apr 2007 12:36 AM - 9 messages

Hello All, I have a stored procedure which when executed from isql gives the error : Msg 170, Level 15, State 1, Server RODEO, Line 1 Line 1: Incorrect syntax near ','. exec weeklysummary '4', '326', 'NP', 0 But the same SP works correctly as coded in osql and Query Analyzer. Since ...

How to output table as XML with elements on separate lines and indented?

Laurence Neville - 6 Apr 2007 11:54 PM - 10 messages

I would like to run a SQL command that outputs all the data in a table to XML, for each column value to be an element, and for each element on a new line and indented. For example: <customer> ...

SQL Server 2005 Error

RDU - 6 Apr 2007 10:52 PM - 2 messages

I'm running XP Pro. I did some long overdue registry cleaning over the weekend. The only negative result was with SQL Server. Upon reboots, I get the following error: "Your SQL Server installation is either corrupt or has been tampered with ...

Maintenance plan : subplan

Ravi Lobo - 6 Apr 2007 9:56 PM - 2 messages

I am not able to see, SUBPLAN in maintenance plan. Where I can see them? I have used subplan before, but when I create a new plan now I am not able to see SUBPLAN option. Can anyone guide me? ...

Changing NULL, to NOT NULL

JayKon - 6 Apr 2007 8:54 PM - 8 messages

SQL Server 2005 When I run the command: alter table FileRepository alter column parentID int not null I get the message: Msg 5074, Level 16, State 1, Line 1 The index 'IX_FileRepository' is dependent on column 'parentID'. Msg 5074, Level 16, State 1, Line 1 ...

Documenting DB with Visio

JayKon - 6 Apr 2007 6:32 PM - 2 messages

Has anyone used Visio to diagram the database? I'm using Visio 2003 Professional and have been finding some minor issues - and no, noone in the Visio group responded to my post. I have reverse engineered a database (with very few PK/FK's) into Visio and ...

Database removable

Luis Tarzia - 6 Apr 2007 6:22 PM - 3 messages

Hello,is possible attach and use the mdf exists in a pen drive or an usb hard disk ??? What commands are involved in this operation ?? Thanks in advance. ...

log shipping problem

Willie Bodger - 6 Apr 2007 6:06 PM - 6 messages

So.... I *accidentally* deleted some of the msdb.dbo log shipping tables, could anyone out there help me out with the table generation scripts so that I don't have to re-install SQL 2000? Willie ...

Notification based on job duration

doug - 6 Apr 2007 5:24 PM - 2 messages

SQL Server 2000 I have a scheduled job that runs a string of stored procedures. Generally the entire job completes in approx 90 minutes, which is acceptable. Occasionally it will run for 2+ hours before it completes. Is there a way to ...

Load Testing and Performance

Chris - 6 Apr 2007 5:01 PM - 2 messages

We have an asp application some of which will be being ported over to asp.net so this may be a little OT. It is having some bad performance problems and we need to isolate which areas are causing the problems. The ...

tranaction log backup job hangs...now in rollback mode for 24 hours

Sanctus - 6 Apr 2007 4:42 PM - 2 messages

I have 3 20 gig databases or so that I setup and transaction log maintenance plan on. The transaction backups were running fine, then the other day the started running and never completed. It ran for like 20 hours befores ...

Prune Data from DB (Code Review)

Paul Bergson [MVP-DS] - 6 Apr 2007 2:01 PM - 5 messages

I have a database that I need to prune. It is 145 gig in size and has a 80 gig log, I have to fix someone elses problem but I don't know sql good enough to know if the modified code I stole below is correct. ...

SQL 2005 Cluster

Rick - 6 Apr 2007 11:43 AM - 7 messages

We are looking to setup a new SQL 2005 Cluster. We are on a San and have 4 nodes in a A/A/A/P seti[. would it be possible to use each Active node, one for database, one for logs and one for backups? ...

Dollar sign behind user name

wodoy.peter - 6 Apr 2007 10:08 AM - 2 messages

What does the $ (dollar sign) means behind the SQL Server login? I had a SQL Server login something like this "DomainName\User$". Peter Chan ...

Cmdexec on SQL 2000

refdk - 6 Apr 2007 7:09 AM - 2 messages

On a SQL 2000 I am running a Job with the following single step: xcopy \\nas01\backup\*.* \\nas02\backup /s /e /i /c /d /y xcopy \\nas01\kunder\*.* \\nas02\Kunder /s /e /i /c /d /y xcopy \\nas01\projekter\*.* \\nas02\projekter /s /e /i /c /d /y ...

Restore Failing

Brian Staff - 6 Apr 2007 6:58 AM - 8 messages

I am trying to restore a database from a production server onto my local server. As soon as it opens the "backup file" I get this error: TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. ...

Big Database needs pruning

Paul Bergson [MVP-DS] - 5 Apr 2007 9:14 PM - 8 messages

I have a big sql database running on sql server 2000. The manager wasn't watching the file sizes and the db made it up to 144 gig and the log is up to 80 gig. We have been working on pruning this pig but it just has ...

databas size

msnews.microsoft.com - 5 Apr 2007 9:00 PM - 4 messages

I am looking for script to give the Data and log files of each Database on the server including the size of each file. can you help ...

schema issues upgrading to 2005

Kristina - 5 Apr 2007 8:05 PM - 6 messages

Hi, I am writing SSIS packages to do a backup and restore from SQL 2000 Enterprise Edition to SQL 2005 Enterprise Edition 64-bit. I am backing up the 2000 database and restoring on the 2005 box. I do the necessary ...

sql 2000 server linked to sql 2005 sp2 server

Carly - 5 Apr 2007 7:56 PM - 2 messages

Hello, I have an SQL 2005 server that has a linked server called LSrv. The linked server is a SQL 2000 server. The main server is SQL 2005 SP2 server. The SQL 2005 machine is called "OAK". Oak is somewere in the building. ...

Current activity shows lots of SPID with open transactions...yet DBCC open tran shows no active tran

Sanctus - 5 Apr 2007 6:05 PM - 2 messages

Anyone know why this is? SQL Server 2000 sp3a. There are about 200 spids in the database that show an open transaction in the current activity window. Yet, when I run a dbcc opentran on the database, it says no active ...

SQL 2005 Express and Advanced Express - Job Scheduling

Michael MacGregor - 5 Apr 2007 4:25 PM - 2 messages

Currently we are running SQL 2000 Personal Edition at remote locations and can schedule jobs, such as backups, on these servers. We are looking to upgrade to SQL 2005 but the equivalent version, Express and Advanced Express, doesn't have the SQL Server Agent service and so cannot schedule ...

Book Online at MDSN Site

Greg Larsen - 5 Apr 2007 4:22 PM - 4 messages

Someone that works with me would like to be able use the search and index function of Books Online documentation that you get with the desktop version of SQL Server 2005 Books Online to search and index into the MSDN website ...

Get File Locations using SQL

theinvisibleGhost - 5 Apr 2007 4:09 PM - 5 messages

Howdie everyone. Is there any way I can get the file locations for the MDF/LDF of a SQL Server Database using T-SQL? Cheers Chris. ...

SQL Server 2005 Performance Issues Help

Isaac Alexander - 5 Apr 2007 4:02 PM - 8 messages

I have a customer that is running into performance problems. They are using 2005 (9.00.1399.00) with the default settings. The server specs are: Type: IBM HS20 Blade server CPU: Dual Xeon 3.2GHz HT RAM: 4GB ...

Hitachi vs EMC SAN for SQL

Hassan - 5 Apr 2007 3:43 PM - 2 messages

Hello, I wanted to know of any pros and cons you may have faced or heard of using either the Hitachi or EMC SAN. We may consider the high end Hitachi USP1100, but wanted to know if any of you may have used it and had any negative experiences. We intend to use it ...

Rebuild Master fails

sharman - 5 Apr 2007 3:02 PM - 4 messages

Hi, I am trying to test disaster recovery on a test server. I am trying to create the master as though it has been corrupted. When I run the Rebuildm.exe, it creates the master.mdf and mastlog.ldf files in the ...

moving a SQl 2005 log file

Mark - 5 Apr 2007 2:14 PM - 6 messages

I do you move the log file to a different drive and leave the database in its current location with SQL 2005? Thanks for your help, Mark ...

Texdata column in trace table

kulkarni.ninad - 5 Apr 2007 2:06 PM - 2 messages

Can somebody please tell me how to get stored procedure names from textdata column of trace. for example trace captures data like exec <name of stored proc> <parameteres> out of this I only need name of stored proc and need to chop of all exec and <parameters> from it. ...

about writes/sec SQL server

Iter - 5 Apr 2007 12:46 PM - 7 messages

Hi Guys, Do you know how many writes/sec SQL server is capable of performing generally? Trying to work out what % of a DB we would be consuming. Thanks ...

delete data from a field in a table

Lamy - 5 Apr 2007 9:41 AM - 4 messages

Hi, I am trying to delete data from a field in my table, I want to clear all the data from one field in my table (assuming the table is Students and the field is firstName) Thank you in advance. ...

veritas backup cannot lock the database

Dooma - 5 Apr 2007 3:21 AM - 5 messages

When I tried to backup sharepoint, it failes due to unable to lock the database in SQL 2000. How can I unlock the database which I do not know how it was locked in the first place. thanks, ...

How secure is accessing a dB using Windows Authentication?

raylopez99 - 4 Apr 2007 11:46 PM - 2 messages

I had a scare with a trojan horse rootkit virus right about the time I started playing with SQL Server Express 2005 and programming it (accessing it) using C++.NET (see below my demonstration program, which works). It appears the virus was a false positive, but it got ...

DB Backup jobs

RK73 - 4 Apr 2007 10:40 PM - 4 messages

Hello, Recently we had a hardware failure and I had to move SQLserver databases to another hardware. Installed SQLServer 2000 and SP4 (OS Windows Server 2003 R2 SE SP1). Restored all the databases. Restored msdb to get all ...

Best way to maintain up to date SQL Jobs and SSIS on failover Serv

FredDBA - 4 Apr 2007 8:50 PM - 4 messages

Hi, on SQL 2005 we use log shipping to maintain our production server to an alternate server. Now I would like to do something similar with our SQL Agent jobs and SSIS. While those jobs are enabled on the production server, ...

SQL server workstation performance issues

Tim Elder - 4 Apr 2007 8:44 PM - 2 messages

I have taken over IT administration for a company that is running a SBS 2003 server and is also running a member server that is W2k3 with SQL 2000 and a LOB app on it. They recently did a swing migration on the SBS 2003 server ...

Linked server SQLNCLI error

grosdug - 4 Apr 2007 8:18 PM - 2 messages

HI everyone! Been scratching my head with this for a couple of days and before throwing everything through the window, maybe someone can help? I have a SQL 2000 server "Remote_Server". I have a SQL 2005 local server on my machine. On my local server, I created a linked server ...

Dump log and move log to another drive

Will Dupleich - 4 Apr 2007 7:15 PM - 3 messages

Hi, I am getting a message that my transaction log is full. After looking at the drive where it is located, I only have 8 megs left on that drive which is pretty bad! I would like to do two things. Dump the log and then move ...

Using Ansi_Padding Off

Analystik - 4 Apr 2007 7:08 PM - 3 messages

Hello, I am using Sql2k and by default the Ansi_Padding is set "On". I used a quite a few VarChar field to my surprise the field is filled with trailing blanks. I was under the impression that VarChar only used the minimun space need to ...

"Orphaned" maintenance plan

Kaidi - 4 Apr 2007 7:04 PM - 5 messages

Warning ahead of time - I'm a total idiot about this stuff. Server is Windows Server 2003 SQL Enterprise Manager version is 8.0 I had been having a problem getting backups to auto delete and so followed the instructions in a Microsoft KB article and set the ...

Log Shipping from SQL Server 2000 Enterprise to SQL Server 2005 Standard

robboll - 4 Apr 2007 4:01 PM - 5 messages

Is it possible to set up Log Shipping from SQL Server 2000 Enterprise to SQL Server 2005 Standard? If not I am ready to downgrade the 2005 to 2000 standard. Thanks for any suggestions. RBollinger ...

An exception was thrown while trying to delete a maintenance plan.

SQLdba - 4 Apr 2007 3:56 PM - 2 messages

Receive a message that an exception was thrown while trying to delete a maintenance plan. SQL 2005 with spk 2a ...

Renaming A Server

MarkS - 4 Apr 2007 3:20 PM - 3 messages

I have created a Database Instance. However the Server Instance is now called RMUK7\RMUK7. I would ideally like this Server Registration \ Instance to be called RMUK7. Is there any way of renaming this as it could prove ...

Database Mirroring

sambino - 4 Apr 2007 2:51 PM - 2 messages

Im trying to get mirroring working go my endpoints set using the wizard, the servers are called server1 and server2 when I trying to start mirroring I get "specify the FQDN for each server, and click start mirroring again" the computers see each other as server1 and server2 is ...

sp_spaceused - need help interpreting

Scott H. - 4 Apr 2007 2:36 PM - 4 messages

Folks, Enterprise Edition 2000 I issue an sp_spceused without an argument to capture information for the current database. I don't understand the numbers I'm getting back for unallocated, reserved and unused. They seem to be way out to lunch. ...

How to find what SQL 2000 service pack is running?

Clayton Sutton - 4 Apr 2007 2:23 PM - 3 messages

Hey everyone, We are running SQL 2000 and I just want to know how to find what service pack is installed and running on the system. ...

How to Diagnose IO Performance On A SAN

Tom Frost - 4 Apr 2007 1:52 PM - 5 messages

I'm runing SQL2000 with SP4 on Win 2003 Ent Srvr and use a SAN for the database data and log files. The SAN drives are configured as RAID5. My question is when diagnosing IO performance issues, what perfmon counters ...

SQL server 2005 standart load, but view odbc sql version 2000, why ?

Mx_Adm - 4 Apr 2007 12:29 PM - 2 messages

os : win xp pro old sql vers : SQL Server 2000 Evaluation Edition new sql vers : SQL Server 2005 standart edition ...

DTS package version deletion

manu - 4 Apr 2007 11:14 AM - 3 messages

Hi, Please let me know if there is any system stored procedure which can be used to delete the older versions of dts packages in SQL Server 2000 as in my environment due to heavy use of dts packages msdb grows beyond 5-7 GB and eat ...

TOP 10 problem on inner join

steen maigaard - 4 Apr 2007 10:36 AM - 6 messages

Hi. I have a report with accounts in a list, and all activities belonging to each account in a table , at the buttom of the list I would like to show all accounts in my report, but only the top 10 ...

Online Backup

Amir Fahmy - 4 Apr 2007 10:16 AM - 3 messages

Hello There Does anyone know how can i make an online backup with taking the database offline thank you ...

Facing problem storing Japanese chars in SQL Server 2000 Ent edn

Mahendra - 4 Apr 2007 7:14 AM - 2 messages

Hi, We are building a ASP based web application which should display and store Japanese characters. We are using SQL Server 2000 SP3 Enterprise edition on Windows 2003 Server. We are not sure of a particular way to do this. We have been trying ...

Login failed for user

Sajith - 4 Apr 2007 6:02 AM - 4 messages

Hi all, I have these lines repeated many times, every 1 second, in the error log: Login failed for user 'user' Login failed for user 'sa' Login failed for user 'root' Login failed for user 'admin' Is someone trying to hack my SQL server (version is 2000)? ...

RE: Problem - Accounting Professional Database on SQL Server

chriswelber@yahoo.com - 4 Apr 2007 3:06 AM - 10 messages

I have an accounting professional database running on an SQL Server, and I can can run Accounting Professional from the server fine. I can connect to the database from a workstation running SQL Server Express Manager. For some reason the same icon which runs Accounting Professional on the ...

Simple Select Statement, Hot topic

huhoic - 3 Apr 2007 11:09 PM - 4 messages

Ok this might or might not be a hot topic among different levels of sql users. If I have a select statement simple or complicated, but let's stick to simple just to start off: Select * from Users Select * from Cars where Make = "Ferrari" ...

Simple Select Statement, Hot topic

huhoic - 3 Apr 2007 11:09 PM - 4 messages

Ok this might or might not be a hot topic among different levels of sql users. If I have a select statement simple or complicated, but let's stick to simple just to start off: Select * from Users Select * from Cars where Make = "Ferrari" ...

recovery databasse without log file

joseph - 3 Apr 2007 10:38 PM - 3 messages

Help i have delete log file *.ldf how can i do to recovery mdf database i do not detach database before ldf was be deleted. thanks ...

Multiple rows

acidscan - 3 Apr 2007 10:31 PM - 4 messages

Hi everybody: I have this result from a query: category id pos name Fixed 1 100009 999003 BLA BLA BLA 1 ...

ALTER TABLE statement does not change view based on table

Spongebob76 - 3 Apr 2007 9:48 PM - 4 messages

Hi, Whenever I add a column to a Table like this ALTER TABLE xxx {Add Column} it never adds that column to the view that I have created based on that table The view T-SQL for the view goes like this ...

Replication vs Log Shipping SQL Server 2000

sharman - 3 Apr 2007 7:38 PM - 7 messages

Hi, Which is a better way to keep a stand by server ready to take over in case of failure of the actual server? What are the advantages and disadvantages of the two processes? Any insight will be greatly appreciated. Thanks. ...

Installing error for SQL Server 2000 SP4

myrights99 - 3 Apr 2007 6:12 PM - 2 messages

I am installing SQL 2000 SP-4 & at one point after clicking next, next i am getting this error message "Setup requires an additional 3072kb free space on E:" Where this Drive E: is on SAN Storage & as 13GB ...

Changeing default value of tempdb

db - 3 Apr 2007 5:54 PM - 7 messages

Hi All For one of our SQL server 2000 database tempdb size is origionally set to "8KB"(That is default value). After monitoring it for some time, I think we need to change the default value to "650 KB". ...

Can't connect to SQL Server 2005 over VPN

jan.mazing - 3 Apr 2007 5:49 PM - 3 messages

Hi - if anyone can point me the the right direction it would be very much appreciated. I have searched the groups but haven't sorted this out yet. I am trying to connect to a SQL Server 2005 database over a VPN and am ...

SQL Server 2000 Patches

DXC - 3 Apr 2007 4:30 PM - 3 messages

Can anyone show me a direction to all the patches came after SQL Server 2000 SP4 ? Thanks for any help ...

Attaching SQL 2000 DB in SQL 2005 and vice versa from CD-ROM

srini - 3 Apr 2007 4:08 PM - 3 messages

Hi all: I am trying to attach db created in SQL 2000, detached and written on CD-ROM in SQL 2005 and vice versa. If I try to attach on the same SQL Server where it was created, it works fine. ...

Retrieving Index Size in SQL Server 2005

Jerad Rose - 3 Apr 2007 3:46 PM - 3 messages

I have a seemingly simple task, but the solution isn't quite as obvious/simple as one would think. I am trying to find out the disk space used by each of the indexes in my database. I have been able to get the size used by indexes within each ...

Getting data from BCP file

Dagwood Bumstead - 3 Apr 2007 2:58 PM - 4 messages

First of all, I am a SQL Server weakling... We have a SQL database running our grocery store. Everyday it creates an archive file of the transaction and header data (actually creates a single file for each). The files are typically 6-8Mb. After 30 days, ...

SQL Backup file names

brymer28303 - 3 Apr 2007 2:48 PM - 3 messages

Is there a way to put the server name in the file backup name within a maintenance plan? Example, I need master_20070403.bak to become server1_master_20070403.bak. We have a new backup process and need to move all (24 in total) of the SQL ...

Backing up SQL Databases

STroy - 3 Apr 2007 2:36 PM - 4 messages

Hello: How do you change the scheduled database backups in SQL Server 2000? We have a scheduled backup of a production database that is run once a day. We need to change it to update once a week; however, no matter what we do, we ...

Replication causing huge memory issues

Patrick - 3 Apr 2007 2:26 PM - 8 messages

I posted this yesterday, but I couldn't change the Subject Line so I thought I would repost it with a better description. We currently have repliation running and it seems to be consuming all of our memory. If I look at the spid that is consuming all of the memory(which is ...

How to display full SQL Error Message

Simon - 3 Apr 2007 1:26 PM - 2 messages

I am using SQL Query Analyser. I am running a large update query into a table with around 200 columns. This is erroring but I am not seeing the full error message being retuned. Is there a setting that I can change so that I can be ...

The MSSQLSERVER service was unable to log on as...

- 3 Apr 2007 1:12 PM - 3 messages

Greetings, I installed SQL Server 2005 Standard using a domain account. As part of this process the same account was used to start all of the SQL services. We subsequently had to change the password for this account and the next time ...

RAISERROR problems with SQL Server 2005 SP2

Massimo - 3 Apr 2007 12:12 PM - 3 messages

Hi to all, i'm using for the first time SQL Server 2005 with SP2 with .NET 2.0 and C# language. Into my code i use only provider Sql. I found that RAISERROR() into my StoredProcedures command generates an ...

Automate a restore through a backup

Ivan Debono - 3 Apr 2007 11:07 AM - 7 messages

Hi all, Regards SQL Server 2000. I have a situation whereby the client takes a nightly backup of his databases. The backups are placed on a network share. He has a laptop where he has sql server installed and wants to update the laptop's databases from ...

Removing rows from a result

danielevans - 3 Apr 2007 10:45 AM - 3 messages

I have a query which returns the following results. What i want to do is remove any rows where col1 does not appear in col2. e.g. "107". As well as this i want to remove any rows that are affected by this, e.g. ...

Selecting columns from different tables

Rune Thandy via SQLMonster.com - 3 Apr 2007 10:14 AM - 4 messages

I've got the following two tables: -costcode with costcodeid,costcodedesc,costcodestatus (which can be Active or Discontinued) -tallycombi with projectid,projectdesc,itemid,itemdesc,unit,combistatus (Active or Discontinued). In the costcode table the costcodeid is unique. In the tallycombi table the combination of projectid and itemid is unique. ...

Deploying multiple web parts together

Amit - 3 Apr 2007 9:51 AM - 2 messages

Hi, My problem is that i want to add Web Part library project so that i could add more than one web part into one solution.This will facilitate me in deploying just one solution on Sharepoint server and ...

Microsoft SQL Server, Error: 53

zentax - 3 Apr 2007 8:13 AM - 2 messages

hi, i am trying to acces my database but i get this error. I allowed remote connections in sql server 2005 but i still get the error. TITLE: Connect to Server ------------------------------ Cannot connect to MSSQLSERVER. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When ...

Application locking.

ben brugman - 3 Apr 2007 7:15 AM - 9 messages

Some collegues of mine want to use an application lock to ensure that a function can only be entered once. Any suggestions how to 'build' the application lock that the future risk of locks/deadlocks/performance problems is minimised ? Suggestions why this should not be undertaken ? ...

problem to store a computed attribute persistand

Volker Schmidt - 3 Apr 2007 5:30 AM - 3 messages

Hi, I like to calculate an unix- timestamp column as a persistand computed datetime column to be able to create an index on this attribute. If I use the command: alter table grade add TS_create_Datetime As DATEADD(s, ts_create+2*60*60, '19700101') Persistand ...

Planning for Disaster Recovery in second data center..

Hassan - 3 Apr 2007 4:04 AM - 10 messages

We are planning on using Database Mirroring internally within the data center for HA and since its used, I am left now with log shipping or possibly some SAN replication. I think either one will work with log shipping being very affordable.. Free ...

Default Isolation Level in Oracle

Hassan - 3 Apr 2007 4:00 AM - 7 messages

Does anyone know what the default transaction isolation level is in Oracle and how does it defer from SQL Server 2005 ? I have heard that Snapshot Isolation is Oracles default but has some differences. What are they ? If Snapshot Isolation is Oracles default, why could it not be considered to be ...

Window Authentication question

akkha1234@gmail.com - 2 Apr 2007 11:10 PM - 4 messages

I am using window authentication to administer sql server. My W2K account is assigned administrator privileges. Is it possible to revoke the system admin privileges from my W2K account while maintaining the SQL server admin priv? How? Thanks ...

Cross reference of User Name to Login Name

scotty - 2 Apr 2007 10:55 PM - 6 messages

Is there a cross reference of User Name to Login Name in SQL Server somewhere? In its system tables? It doesn't appear so? The user table for a database doesn't contain the login name. Does anybody know if this cross reference is accessible via system ...

Location for audit logs?

bing - 2 Apr 2007 8:20 PM - 2 messages

Hi, I saw in this or the SQL Server Security news group that it's recommended to store auditing logs on an unused disk drive because auditing logs could grow wildly. But based on this article [link], ...

Bulk Import Diacritics Issue

Kevin Humphreys - 2 Apr 2007 5:26 PM - 2 messages

Hi There, When I do a bulk import from a DTS Package into a table the import fails at record that contains diacritic characters like C, Í and E. The field type is nvarchar. Is it a collaction type I need to assign the field? ...

Error 823

doudoune - 2 Apr 2007 5:00 PM - 4 messages

Hello, I have lost my volume D and E but when i recover it by Restorer 2000 professionnel. I get this error: input/Output Error (BAD page ID) detected during read at of set .. in the file: base.mdf. I have no backup and i am desperate. ...

Delete from cause "Timeout Error"

sweetpotatop - 2 Apr 2007 4:53 PM - 6 messages

Hi, I have to get "Timeout" error when I run the following stored procedure. How can that be avoided? Thanks in advance. Your help is greatly appreciated. BEGIN TRANSACTION Delete From Tables ... /* 10 tables and some of them are big */ ...

Cluster server slow, could different times on the servers be the cause?

a - 2 Apr 2007 4:18 PM - 5 messages

Cluster server slow, could different times on the servers be the cause? Thanks ...

backup faild to VDM

msnews.microsoft.com - 2 Apr 2007 4:02 PM - 2 messages

I am doing a full backup if one of my DAtabases to Virtual backup (SAN) , I am getting the following failure any idea. 2007-03-30 21:16:33.17 spid86 BackupMedium::ReportIoError: write failure on backup device ...

Log Shipping Monitor - 2005

Cgal - 2 Apr 2007 3:25 PM - 5 messages

Is the "Log Shipping Monitor" that was avaialable in SQL Server 2000 Enterprise Manager still available with SQL Server 2005. I installed Log Shipping on a 2005 server and selected the monitor option but I can not find the nice Log Shipping monitor that give you status on log shipping. I also ...

SQL Server 2005 connection string .

Max - 2 Apr 2007 1:02 PM - 8 messages

Hello, I want to access a SQL Server 2005 database from a program written in C#. NET 2005. I made the corresponding accounts on the SQL database based on the windows accounts used on various computers. I tried out the application and works fine on a pc with windows XP ...

Encrpyt

Meelis Lilbok - 2 Apr 2007 12:53 PM - 7 messages

Hi What is the best method to encrypt data in tables? Lets say if special program or user calls select * from names then all data is visible and normal, but all athers get "crap" with select * from names ;) Best Regards; ...

How to use PIVOT for dynamic transform rows to columns

anuragsji - 2 Apr 2007 10:43 AM - 2 messages

Hi, I want to use PIVOT to transfer my rows data to columns(for example in 10 rows one columns is price which has prices of each month). The result is showing 10 rows and column containing price. I want to see price of 10 rows(for each month) in column manner means ...

Logging use of stored procedures

SQL 2005 Maintenance Assistent Error 12291

Newbie - SqlConnection statement

Upgrade Cluster to SP4

Permissions

Weekly reports query