I know enough SQL to be dangerous. So most of my question will sound like access
My company has just moved an access backend into an instance of SQL 2005 Express. there are only 2 tables and no re...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2300...
I am trying to connect to a data base that has already been designed and populated on a 2003 server std machine. I am using Windows Vista Home Premium (sadly) and I can't connect to the server's in...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2305...
We have a DB and I need a simple query to run dollar totals for each month of the year, grouped by vendor name (Vendor_ID field) for each month. Let's take 2007 for example
Table: ORDERITEMS
Fi...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23103065.html
Is there any good way to backup all the databases (automaticlly) on a MS SQL 2005 Express server, including the master database?
I'm going to transfer all the databases from one 2005 express to ...
http://www.experts-exchange.com/Storage/Backup_Restore/Q_23184197.html
Hello,
I am using SQL 2005 Express on a machine. I think by default on Express setup the autoclose property is set true for all databases. But now I want to change them to true. Can I have some ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2321...
I am evaluating the design of an application I am writing. I am just now learning about stored procedures and heard that the performance is greater than using code in C#. Is this actually true an...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2335...
We have a SQL 2005 Express database on a local network that we want to replicate outbound only to a SQL 2005 Express server on a web hosted server. The web hosted server will then be used in a rea...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2338...
Hi
I am trying to export a view to a .csv using a script, but when I open the .csv there are no colum headers.
Also the Colum I identifier is a tab, how do I change this to a ,
The script...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2356...
I need an automated backup for SQL 2005 Express.
I used studio manager to create the backup script.
I am currently using task manager to run the script.
How can I run it without showing the us...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2357...
Hi
I have a sqlcmd script that runs a simple select query and outputs it to a .csv
However one of the fields rounds using
ROUND(dbo.KASSTRNS.KAS_BETRAG / 1.175, 2, 2) AS Expr2
But whe...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2377...
