Attaching files to row information in SQL server

I'm a new babie in the use of SQL server. Infact i've never used it though i use SQL and Mysql but just as a beginner. Now i find myself in a company where I have to create a database for 180,000 records. whereas, each of these records have 5 documents to be attached against it. Please how can i go...

Phunmie10 pointsBadges:

sql2005 with share point 2007

I installed sql server2005 and sharpoint 2007 for two times in two seprate windows server2003 but i give same error when i want to start share point : failed to start the database service MSSQL$Officeservers.repair this product by selecting it from the add/remove programs menu. now how can i do?...

4425195915 pointsBadges:

Multiple Tables to Bulk Import .sql script

I am a very new user to both SQL and Oracle and I am hoping that someone can explain to me if there is a way to multiple tables in a schema to .sql Import scripts. I know that in TOAD, you can right click on a table and choose export from the list, then save it as an .sql file. If I select multiple...

ADMIntegrated5 pointsBadges:

Shell script within Stored Procedure

How do I execute a UNIX shell (.sh) script from within an MS SQL Stored Procedure?

VelameLaCosa110 pointsBadges:

ODBC Connection to iSeries

Hi, My company has just upgraded to V6RM0 of iSries and I have had problems connecting to the new server through ODBC using Crystal Reports or SQL server DTS. The packages I already had set up are still functioning and I can get a connection OK, but whern I try to create a new package I get an a...

MBell40 pointsBadges:

Increasing SQL Server performance by excluding files from anti-virus scanning

To increase our SQL Server’s performance, we would like to take these certain steps: 1. Exclude the anti-virus software from scanning .mdf, .ldf, .ndf, .dtsx, .sql and .msc files. 2. Turn off I/O scanning for the writing to disk and reading from disk processes. 3. Disable buffer overflow...

SQL Server Ask the Experts2,585 pointsBadges:

How to config iSQL Plus on computer without a domain

Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message "The server encountered an internal error or misconfiguration and was unable to complete your...

DerrickOra5 pointsBadges:

SQL 2008 Identity column values 0

We recently migrated our application from sql 2005(32 bit) to sql 2008(64 bit). I have observed that one of our tables with an identity column is now having all values are 0. I am yet to find out the reason .Could this be related to migration??

Swetaleena5 pointsBadges:

Does something similar to Oracle’s optimizer hints exist in SQL Server ?

In Oracle, one can alter execution plans for SQL statements manipulating the optimizer with the help of hints. Hints can be used to alter access paths, join orders, etc... Does something similar exist in Microsoft Sql Server ?

carlosdl84,495 pointsBadges:

how to capture cases in store procedure codes

I wish to creat a query in store procedure (with variables such as Start Datetime, End Datetime, Parameter varchar(3) as you can see on my store procedure for other reports). But for this report, I wish to capture a case might fall into one of the columns (only one column such as DECLEAREDDATE OR...

Josephptran15 pointsBadges:

log sql queries?

queries seem get mangled by our report writer middleware; I'd like to see the actual SQL received by Oracle9i from a particular user. how?

Ktpierce5 pointsBadges:

Execute SSIS package in SQL Server 2005

how to execute SSIS package in sql server 2005

Sangeeth30 pointsBadges:

Attaching a SQL Server 2005 database to SQL Server 2000?

Is it possible to attach a database that was created in SQL Server 2005 to SQL Server 2000?

SQL Server Ask the Experts2,585 pointsBadges:

Looking for a query tool for SQL Server 2000 and SQL Server 2005

Many of our developers would like to have a client utility like Query Browser or Query Analyzer installed on their machine, so that they can personally query our SQL Server 2000 and 2005 servers and view the results from their workstations. I am unable to find the appropriate way to install...

SQL Server Ask the Experts2,585 pointsBadges:

MSSQL Reporting services

Can a single report show more than one graph? Consider I have 4 queries to show graphs for and I'd like to have all of them in one single report, is this possible?

alessandro.panzetta9,725 pointsBadges:

Drop Database Connections

Hi,How can I drop all connections of a database through TSQL commands.(NOT SMO)

Javad5 pointsBadges:

Where to place the tempdb log file?

I've heard it recommended to place the tempdb on its on own drive. Regarding the tempdb log file specifically, should it be on a different disk than the mdf or ndf files of the tempdb?

SQL Server Ask the Experts2,585 pointsBadges:

How can I correct sCaller errors in T-SQL?

How can I correct generic sCaller errors in T-SQL?

SQL Server Ask the Experts2,585 pointsBadges:

How to create new ramco test server?

Plz help me,when i restore my sql database with ramco backup then my database is restore but problem is that front-end not lounch in my system.

Amitshukla60 pointsBadges:

SELECT statement in SAP

what are various select statements used and where are they used.what is value table.

Anil40610 pointsBadges: