Archive

Posts Tagged ‘SQL Server’

Convert Sql Server Database To Sqllite

February 6th, 2012 Comments off

I am looking for someone to convert a SQL server database into SQLlite. Would love to hear from anyone who can help me.

Need Help With Building Sql Server Query

December 20th, 2011 Comments off

Hello, I need some help with a SQL Server Query in Microsoft SQL Server 2008.

I have two tables, one with device information, and the other with device history. The device history is keyed to the device information id column.

In the devicehistory table I have 4 columns: id, compid, startalarmdate, endalarmdate. I have a script in my application that adds an entry when one of my devices goes into alarm, it puts in the id of the device into the compid column. It also writes the current date…

Move Asp Website To Another Windows Server

December 16th, 2011 Comments off

I have an existing website that I would like to create a clone for on another server. Basically, I need someone with advanced experience in ASP and MS SQL to copy files (including databases) from my existing website to another Windows server 2008. I’m want to create a backup website for testing purpose.

You may visit the existing website by clicking on the below link:

http://goo.gl/XmNe6

Sql Server Expert Required

November 28th, 2011 Comments off

To create an automatic job managements process.

Please reply only if you have the following.

Transact SQL very strong
SQL server architecture
Understanding of SQL agent jobs
Understanding of SQL performance
Dba skills.

Pmb for more detailes

Database Tuning Of Ms Sql Server Database

November 17th, 2011 Comments off

We need a person to tune the database for the purpose of speed and performance.

Convert A File From A Sql Server 2005 To Csv

October 31st, 2011 Comments off

We have a backup .BAK file from a SQL Server 2005. (+/- 7 MB)

The file has about 45 tables. We need every table in a separate .CSV doc.

Simple Report In .net3.5 With Sql Server

September 21st, 2011 Comments off

I have a project ready with me, i just a need to be desgined, its very simple. I can send the project as well database…for doing report.

looking for quick delivery.

Sql Mail

September 20th, 2011 Comments off

Greetings,

We have a client with SQL Server. We need SQL Mail set up and jobs created. We provide the queries to use. Several jobs need to be made for emails to be sent on a regular basis. If you have done this before you know what we need.
SQL Mail or SSIS, we have both.
Ready to get it done tonight.
Thank you

Sql Server 2000 Set-up

August 4th, 2011 Comments off

I have SQL Server 2000 (Enterprise) with Windows 2003 32bit, 8G Ram. I would like to aset up the server efficiently in terms of memory use.

Should be experienced with similar settings including /PAE , AWE /3G , memory setup and monitoring tools.

ONLY EXPERTS please.

Help With Sql Server Pivot (cross-tab) View

July 25th, 2011 Comments off

Need immediate help with a complex Pivot View in Sql Server. Details will be given upon acceptance of job

Categories: Server, SQL, SQL Server Tags: , , , , , ,

Dashboard On Wpf

June 13th, 2011 Comments off

I require a dashboard project to done as per the attachment screen shot, development to be done using visual 2011 vb.net
data is available on sql server 2008

Toyota Epc

May 25th, 2011 Comments off

I need to export data from EPC Toyota, to database ms sql server
Please, tell how many it will cost?

Table Created In Ms Sql Server 2008 Server Cssql 2

May 23rd, 2011 Comments off

I need to Create the tablesin the MS SQL Server 2008 server CSSQL and populate the tables with at least 10 rows or suitable data in each table

B.Create MS Access forms to link to your database that will allow users to carry out the functionality for the Maintain goods available part of the system

Sql Server 2008 2

May 15th, 2011 Comments off

I have an sql file thats neeeds updating.. Wont take more than two hours.

Sql Server 2008

May 15th, 2011 Comments off

I have an sql file thats neeeds updating.. Wont take more than two hours.

Table Created In Ms Sql Server 2008 Server Cssql

May 9th, 2011 Comments off

I need to Create the tablesin the MS SQL Server 2008 server CSSQL and populate the tables with at least 10 rows or suitable data in each table

B.Create MS Access forms to link to your database that will allow users to carry out the functionality for the Maintain goods available part of the system

Sql Server Assignment 2

May 7th, 2011 Comments off

Hi,

Pls contact me for my college assignment project in SQL Server 2008 Enterprise Edition. Assignment file would be sent to interested bidder.

Thanks
dkjain01

Shrink Microsoft Sql Server 2000 Database

April 28th, 2011 Comments off

I’d like to see if it’s possible to shrink a 2GB MSSQL 2000 database below 1GB so I can upload it to my hosting provider. I understand that is this can be done using the Database Publishing Wizard. I would like someone to walk me through how to do this using a screensharing program, preferably teamviewer.

http://stackoverflow.com/questions/439071/how-do-i-shrink-my-sql-server-database

Backup Sql Server 2

April 27th, 2011 Comments off

We need you to backup an very small MS SQL Server. We will provide you with server name, db name, login & password.

We need you to download the back up of this data base and give us mdf and ldf or bak files, which we can restore on our new server location.

Budget: $10

Backup Sql Server

April 27th, 2011 Comments off

We need you to backup an very small MS SQL Server. We will provide you with server name, db name, login & password.

We need you to download the back up of this data base and give us mdf and ldf or bak files, which we can restore on our new server location.

Budget: $10

Aspx Page With Sql Server

March 2nd, 2010 Comments off

Need to extract data from sql and place on an aspx page. Will need to make a master file from our template already made.

It is a vehicle search …

make >> model >> year >> then data display

I will give you a access db to work with…

I will need all source code

Categories: SQL Tags: , , , , , ,

Sql Server Database Restore

October 16th, 2009 Comments off

I restored a .bak file, but all I see is schema and no actual shopping cart product data. I need a Certified Microsoft Database Administrator to look at the file and tell me if it’s okay.

Sql Server / Cold Fusion App

October 14th, 2009 Comments off

We have an existing Coldfusion / MS SQL Server application and we require ongoing support, customization, and maintenance of this app.

It is a job board / employment application. We are looking for a programmer to work until the project is finished.

Some key requirements:

1) We require you to SPEAK and UNDERSTAND english sufficiently that we can talk over the telephone.

2) You must be an EXPERT in Coldfusion and Microsoft SQL Server. You must have at least 7 years of hardcore DEVELOPMENT experience in ColdFusion and Microsoft SQL Server.

We prefer to work with independent contractors, not vendors, because we want to keep the costs low.

We expect the project to take about 100 hours at most, so our budget range is between $500 and $1500 total.

Fixing Problem Sql Server 2000

October 13th, 2009 Comments off

Problem with SQL Server 2000.

CPU Overload when website starts working

Fixing A Bug With Sql Server

October 13th, 2009 Comments off

Fixing an error with SQL Server 2000 – CPU overloaded.

Transform Db Sql Server Ce 2.0

September 26th, 2009 Comments off

There is an application for a PDA that uses a database that works in SQL Server CE 2.0. On the database password is set, so direct access is impossible. But through the program access is possible. Need to know the password to the database or reset it.
Application and database as an attachment

Dsn Connection For Sql Server

August 11th, 2009 Comments off

Hello,

I have created an application using asp and ms access as the backend and I have now hosted it to windows server with ms sql server. I have finished creating the database and tables and have also created a dsn for sql server and have included it in all my asp files. But I am getting “server 500″ error.

can anyone fix this ?

Correcting Errors

July 24th, 2009 Comments off

http://www.bankinggrapevine.com

I changed the user name & password of database yesterday evening, and since then have received the following errors on the website:

After submitting form on “buy now” page:

Microsoft OLE DB Provider for SQL Server error ’80040e37′
Invalid object name ‘bank_customer’.
/nextstep.asp, line 213

After trying to login in top left of homepage:

Microsoft OLE DB Provider for SQL Server error ’80040e21′
The requested properties cannot be supported.
/includes/user-log-in.asp, line 152

After clicking to view sample bank data on “sample page”:

Microsoft OLE DB Provider for SQL Server error ’80040e37′
Invalid object name ‘vw_searchResultBank’.
/bank.asp, line 332

After searching for contacts on “search people” page:

Microsoft OLE DB Provider for SQL Server error ’80040e37′
Invalid object name ‘vw_searchContacts’.
/searchresultshtm2.asp, line 422

After searching for banks on “search banks” page:

Microsoft OLE DB Provider for SQL Server error ’80040e37′
Invalid object name ‘vw_searchBanks’.
/searchresultshtm3.asp, line 314

I have updated the connections file (bgconnect.asp) with the new user name & password.

The webhost was changed 4 weeks ago, and the database had to be changed from MSSQL 2000 to 2005. It was changed successfully. It may/may not be a reason why these errors are appearing.

Website was working perfectly up until last night.

Error Correction

July 24th, 2009 Comments off

http://www.bankinggrapevine.com

I changed the user name & password of database yesterday evening, and since then have received the following errors on the website:

After submitting form on “buy now” page:

Microsoft OLE DB Provider for SQL Server error ’80040e37′
Invalid object name ‘bank_customer’.
/nextstep.asp, line 213

After trying to login in top left of homepage:

Microsoft OLE DB Provider for SQL Server error ’80040e21′
The requested properties cannot be supported.
/includes/user-log-in.asp, line 152

After clicking to view sample bank data on “sample page”:

Microsoft OLE DB Provider for SQL Server error ’80040e37′
Invalid object name ‘vw_searchResultBank’.
/bank.asp, line 332

After searching for contacts on “search people” page:

Microsoft OLE DB Provider for SQL Server error ’80040e37′
Invalid object name ‘vw_searchContacts’.
/searchresultshtm2.asp, line 422

After searching for banks on “search banks” page:

Microsoft OLE DB Provider for SQL Server error ’80040e37′
Invalid object name ‘vw_searchBanks’.
/searchresultshtm3.asp, line 314

I have updated the connections file (bgconnect.asp) with the new user name & password.

Errors

July 24th, 2009 Comments off

http://www.bankinggrapevine.com

I changed the user name & password of database yesterday evening, and since then have received the following errors on the website:

After clicking to view sample bank data on “sample page”:

Microsoft OLE DB Provider for SQL Server error ’80040e37′
Invalid object name ‘vw_searchResultBank’.
/bank.asp, line 332

After submitting form on “buy now” page:

Microsoft OLE DB Provider for SQL Server error ’80040e37′
Invalid object name ‘bank_customer’.
/nextstep.asp, line 213

After searching for contacts on “search people” page:

Microsoft OLE DB Provider for SQL Server error ’80040e37′
Invalid object name ‘vw_searchContacts’.
/searchresultshtm2.asp, line 422

After searching for banks on “search banks” page:

Microsoft OLE DB Provider for SQL Server error ’80040e37′
Invalid object name ‘vw_searchBanks’.
/searchresultshtm3.asp, line 314

I have updated the connections file (bgconnect.asp) with the new user name & password.

Files attached

Sql Server Ssis Expert Needed

July 8th, 2009 Comments off

Looking for someone to come in for a day or 2 to help setup SSIS, packages, train and explain some details on SSIS.

Compensation / Engagement based on your experience and ability to handle technical interview to make sure its suitable.

We are in Newport Beach, CA

Sql Server Db

July 1st, 2009 Comments off

hi,

i have setup mssql support on my linux machine. i am having trouble connecting to a remote sql server2000. i think the prob is a slow sql server and a timeout issue. unforunately i do not have another sql server that i can connect to. so i need mssql db that i can connect to remotely from my server using my php script just so i can test to see whether i can connect. so i need either an existing mssql db that i can connect to or i need one setup that i can connect to.

russ

Connect To Remote Sql Server

June 30th, 2009 Comments off

hi,

i need to connect from a linux server to a remote sql 2000 server. i have tried some options, but no luck. i get “Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server:”. i need to connect to the mssql database so i can grab some fields for output. the linux box where the site is loaded already has mssql support. i need someone who has experience with this and knows how to troubleshoot this.

russ

Cold Fusion -sql Server Job

June 25th, 2009 Comments off

Dear sir

Our client needs a programmer for Coldfusion and SQL server job which can take a few months to complete. Their site is almost finished. It requires very simple logical coding, display of products is done, many features already done, just more ideas to add more bells and whistles ..just so many little ideas to do that client want to focus on marketing myself and not have to do more coding, so want to hand it over to some one else.

Now in this bid we give the programmer 100 hours job for a bid amount of 300$ and expect to be completed by 1 month.

After completing this bid, we will open another private bid to you and continue that way.

All the best:)
Bid with confidence.

Regards
Rajesh

Week 2 Ia

June 15th, 2009 Comments off

Kudler Fine Foods is a

Sql Project

June 13th, 2009 Comments off

Kudler Fine Foods is a

Sql Server 2005 Full Text

June 11th, 2009 Comments off

I have SQL Server 2005 Express with advanced services installed on Windows 2003 server. When I installed the SQL Express I installed all options available. I have forum installed that uses full text search but full text is not functioning. I do not know if something is not enabled properly or if something in SQL Server Express is not configured properly,

The task for this job is to get full text to work on server so the forum works properly will full text.

Knowledge of SQL Server with advanced services is obviously necessary.

I would like this immediately.

Sol Server Copy Job

June 11th, 2009 Comments off

We have a MS SQL Server database on one Server with around 350 tabels called “hotdata” here we work with the SQL server 2000

now you have to write a copy job that everyvery day it will copied the tabels of “hotdata” to an other server with SQL Server 2005

from that server 26 tabels have to copy in a differant database called “eshop”

form a other database you have to copy aournd 5 tables to the database “eshop”

finally the database “eshop” has to be copied to the host of our proviader ..everday you got me?

It should be done in a way that only the changes are copied everday ( new addreses/drtikels changes or deleted ones.

Help With Sql 2005

June 6th, 2009 Comments off

I am having problems installing sql 2005 developer edition on a dell windows vista 32 bit machine.,

I downloaded service pack 3 and still did not get it to work.

I get to the point I get this error.

Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_RAINBOW_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, “How to: View SQL Server 2005 Setup Log Files” and “Starting SQL Server Manually.”
The error is (1067) The process terminated unexpectedly.
Error Number : 29503

If you can talk me through what I need to do i can call you anywhere in the world, or do it through chat.

Thanks
Brian

Setup Sql Server Express

May 31st, 2009 Comments off

I am moving my website from windows 2003 VPS to budget dedicated Windows 2003 Standard server.

Original site used SQL Express with Windows authentication. On new server I installed SQL Express with Advanced Services and set for mixed mode. I detached database in VPS and attached in Dedicated Server SQL Express.

I receive errors that settings do not allow for remote connection. Connections are set to allow remote connection.

I ask for someone to complete setup of SQL Express on dedicated server and make sure that setup is secure. Also correct error with connection by correcting user connection for database/script connecting to database.

Thank you

Bear