I have a MS SQL Server Express 2005 database. I want to link to it via Access 2003 in Vista. It looks like I need to use ODBC since SQL Server databases aren't supported directly. When I try ...
I have a SharePoint 2007 installation with a SQL Server 2005 back end. I installed some admin templates awhile back that corrupted my content databases. This issue was resolved via help from...
I have tried to convert an Oracle procedure over to SQL Server 2005 but it is not functioning correctly.
I am very new to TSQL but I am sure it has something to do with the CURSOR portion,...
Hi,
I am trying to install Microsoft SQL server 2005
I am working in Windows Vista and I have Microsoft office professional 2007
my problem is during the installation for SQL server I ...
Having problems with a SQL 2005 installation. It will not allow me to create a local publication. When I right-click on the Local Publications folder to add new publication...the UI just sit...
That attached code snippet does work just fine but, what can I add to force it to use a different port than 1433. I already know how to change the receiving and listening port on the SQL serve...
I have a web page that i need to schedule to open every 2 hours. Can i accomplish this process in SQL server 2005. ( either a schedule process or a trigger ?)
If yes, please provide the s...
Hi,
We are using SQL 2005 SP1 as a backend for our Siebel Front end. We are having issues with log files taking up almost the entire disk space on the drive. THe log files and the data fil...
I want to extract a column of data from a SQL Table and use BCP to export it to a text file. So, I can create a temp table to to get the data that I want..I'm doing this so I can pass a parame...
In my table I have a column namd [Symbol]. What I want is a SQL statement that can return 1 comma separated line of all the rows. Can this be done?
I have a table which stores payroll information for several office locations.
I am going to create a report in reporting services to allow the user to select information based on their of...
Hi I have two tables.
The first table has the following fields:
(pk)id, name, ticket_details
The second table has these two fields:
(fk)id, ticket_details, update_time
In the second tab...
I just installed MS SQL Server 2005 Express SP2 (advance) on a PC running Vista...
I want to move an existing database from SQL Server 2000. I have both the MDF file and a backup file.
...
Something wrong with using Database Diagrams in SQL Server 2005.
I moved one database from SQL 2000 to SQL 2005. In SQL Server Management Studio, when I clicked "Database Diagrams", I got the...
I am having trouble getting both Microsoft Access 2003 & 2007 to work with my sql server 2005 database. When i create a adp project it shows the tables inside of access. However when you try t...
I have been tasked to make a backup of our production database (SQL 2005 Standard) that lives on a remote webserver every day to a database that is in our server room. The copy is used for ad...
I have a complex historical psuedo-application written in Excel (currently Excel 2003). It is to be replaced within the next twelve months (yippee!!). However, in the interim, there are some s...
I have created a vb.net stored procedure that does some loops and for each loop runs a query where the result is sent to a function a single output value is then calculated for each loop.
T...
In Oracle a column's datatype is NUMBER. It can hold any of the following values
1, 99999999999, 1.2342344534, 1.75921860444164E30
I want to load this data 'as it is' into SQL-Server. Whi...
I have a storeprocedure returning a basic table of totals, with two columns, returning 6 rows.
Category | Value
I have created two pie charts from this, I want the second chart to omit a c...
Hi,,
I'm having an error when trying to backup my SQL 2005 Database:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Backup failed for Server 'DEVBOX'. ...
I need to install a small piece of SQL 2005 on to several PC's and I want to create a slipstream or hands-free install to do it.
I have to install the SQL 2005 client connectivity components on many PC's.
I have to configure them to connect to my legacy database.
I want to locate the configuration file, the one ...
I have a sql 2005 server running on a windows 2k3 server. I am trying to enable AWE through the Microsoft SQL Server Management Studio. I have checked the box beside the Use AWE to allocate...
I have a very big "database diagram" which i have to copy and convert it into JPEG format then Zip it.
I tried copying it to Paint but it returned an error message " it cannot copy the di...
