SQL Server 2005

Working TRIGGER and TRANSACTIONS QUESTION

Hello all, My company purchased an operations software (called [strong]darwin[/strong]) that works with SQL 2005 Server. I need to extract some data and save it in my Own Database, which is located in the same SQL Server. On the darwin software there is a screen that updates a field X in a...

SQL Server 2005 is running slow

SQL server 2005 is running very very slow while it hase 32 GB ram 200 GB SAN and 4 Processor of xneon 566 Ghz. The normal select query takes 30-35 seconds to returing 37 records. Please give me the suggestion how to increase the performance Software/Hardware used: OS-window server 2003 R-2,...

how to use sql server 2005

i have installed sqlserver2005 but i want to know how to open sql server and connect DB

Error when insertin.g data into SQL table

                I'm using SQL Server 2005 Express edition as the Database and Microsoft VB.NET 2005 as the programming language for my project. At the moment I'm having a problem of inserting data into one of the tables in my database through my VB.NET application. I...

synonym in SQL server 2005

How can one get the information about the object type of synonym that is whether the synonym belongs to function, stored procedure, table or view using a query. Sys.synonyms table contains information about synonyms present in a particular database but it does not tell for which object the synonym...

Upgrade to IDES CRM 7.0 (ABAP)

Hi All, My client using sap IDES CRM 5.0 (ABAP) and he wanted me to upgrade to IDES CRM 7.0 (ABAP) . I am new to BASIS, can any one help , which CD's( with the CD numbers and related notes numbers ) to be downloaded from service market place and how to start the upgrade on a stand-alone system...

Windows Server and SQL database upgrade

 We are goging to upgrade server, SQL server databases and domain name, now currently using as following setting 1. Server OS - Windows server 2003 Enterprise Edtion. 2. SQL server 2000 3. domaname xxx1 we are looking and upgrade to new os version, server SQL server and change domain name. ...

dbcc checkdb error; object id 0

Hi, We have been ask by one of our customer to restore a database from SQL Server 2000 and SQL Server 2005. The restore completed however when we run a integrity check on the database errors occurred. We than ran an integrity check with repair allow data loss option, as the customer is happy to...

Trigger Use

I have a Sequel Server 2005 database with a Table called Main Call Issue. I want to update the DateTimeModifed field to be the Current System date without changing my original DateTimeAdded field when the record was added to the database. I know a Trigger will work here. Where do I place the...

SQL Database User

Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql...

Applying snapshot on Subscriber - SQL SERVER 2005

hi, i've read on this articlehttp://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1362610_mem1,00.html about applying snaphot on the subscriber by copying the snapshot on the distributor and sending it to the subscriber. i didnt get what/how this part.  When the snapshot is created and...

Controlling tempdb Growth

I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes. tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of the space...

How to load an Image from an SQL Server 2005 database using VB.NET 2005 coding?

            After a lot of trying and hard work I finally manged to store an image into an SQL Server database using a byte array. But now I'm stuck at how to retrieve it back into my application's picture box control.              This is what I need to do: I need to retrieve the...

On Error Resume Next SQL Server 2005

Is there to achieve On Error Resume Next? insert into table1 select top 1000 columnname from table2 It should continue inserting the next record even if there is an error. It should not stop the execution. It should simply skip the errors. thanks in advance.      

Is share point an alternative / more than SQL Server?

I m poor in using MOSS Microsoft Office Share Point. I have web application in ASP using IIS and SQL Server 2005. Now if I have no licence for SQL Server 2005 can I use MOSS as an alternative for SQL Server 2005? Is it possible to create / attach data base in MOSS / MOSS related SQL...

Service Broker in sql server 2005

[strong]What is a real life application of service broker architecture in sql and how to use it?[/strong] [strong]Can anybody help me in understanding service broker with real life example?[/strong] Thanks in advance Software/Hardware used: sql server 2005

How to open sqlserver2005 after installing

I have installed Sqlserver 2005 into mys system and how can i set a username and password to that.I am the only user to that computer.

Migrating C code db acess from sybase to sql server 2005 - newbie

I have to change the db access from a sybase to a sql server 2005 in a c program (i have to keep the C code) I have read lots of technical articles but i'm a bit confused ... with ODBC and the use of sqlcli.h i write a simple C code that access the sql server db but i think it is not the better...

Capture SQL Server logged in db User name in Access 2007 Accdb

I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application.  Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user.  Is there a way...

SQL Server Database Restore

When i restore a database from server1 to server2 as stand by/read-only mode the database restores with a database owner "domainrmartinez". How can i restore a database from server1 to server2 and the database owner as "sa"? Software/Hardware used: SQL Server 2005