Hi
I am not sure is it hard orsimple task but i need to know in step by step how to get local backup of a data base. here is the commen sinario (that i did not find any basic reply about that i ca...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20970474.html
Can anyone help me with this trigger? I can get the ADD/DELETE to work but I get this error on the update:
"Msg 107, Level 16, State 2, Procedure tr_products, Line 14
The column prefix 'inserte...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23466423.html
Hi,
I have 2 store databases (retail & wholesale), each database contains the same tables and structure but most with different data. There are several tables that will contain the same informat...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23471139.html
Hi guys,
I need to configure an SQL (express) server for remote access on a server. I know this has some security risk.
I'll appreciate tips regarding the config. of SQL access and connstring ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2356...
I need to get values from sql for a specific item and summed quantity but for each customer
as one record. I would need to convert the orderdate to just the year
I'm hoping to get the followin...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23618858.html
I just want to make an exact copy of database on the same PC under the same server, using Transact-SQL.
I seem to be lost in backup and restore options offered by MS SQL 7.0.
I do
backup...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10880801.html
I am constructing some database management tools in asp and I have a database for this purpose alone.
One thing that I am doing is storing create and alter scripts. Is there a "special" way to sen...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20116152.html
I wish to set my server up as a dedicated MSSQL SERVER. Currently I have MSSQL 2000 SPK3 installed on MS 2003 server. There are no roles established for the server on my cofiguration wizard at star...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21628264.html
Zones:
DatabasesDate Answered: 12/06/2005 Grade: A Views: 0
I am working on an existing asp site that has a very poorly designed mssql server 2000 database as its back end. One particular table stores product information and has 4 price fields (price, price...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23110032.html
I want to restore the master database of SQL Server 6.5 running on server A onto SQL Server 6.5 running on server B.
Can I:
Copy over the network the master.dat from A to B to the following dir...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20907337.html
