Hi,
I have installed SQL 2008 Server and want an application to connect it from WAN. I have opened port 1433 and the connection itself works. I want users to connect with SQL authentication...
The following query display the result:
id amount rateref handlingincome countervalue
8335 2300000.00 0.8835 0.00 2603282.39954725523486134
8339 ...
We are looking at bringing up a new DR site, and we want to use log shipping to keep a warm stand by. Since we can only purchase SQL 2008 now, we are thinking of just using that. Our productio...
If I have a table with a field that is a date with time.
I would like to get the latest value for a particular set of records.
eg. which would give the best performance (just written the ...
In real-life job, do you usually write INSERT INTO statements within the DDL Script file as the example in the link below:
http://code.google.com/p/database5/source/browse/trunk/reports/Gui...
Two tables: A and B. How do I select from table A where A.Field1 is in B.Field1 where A.Field2 = B.Field2?
Kevin
Hi Experts,
I have a stored procedure that has a cursor and I loop threw the records in the cursor by checking the @@FETCH_STATUS . In between the fetch I call another stored procedure. The p...
I have a bunch of dropdownlists on an asp.net page that I want a user to select which will bring back data in a gridview on postback. I need the sql statement in the datasource to bring back ...
All,
I have successfully linked a Postgre Database to a SQL Server database and everything seems to be working fine as long as the query results are below 100 rows. It only shows the top 10...
I did a test migration on a SQL Server 2000 database this weekend and that went fine, however, now I find myself trying to migrate some DTS packages I've run into some fairly major problems.
...
I would like create a linked server on a SLQ2005 server to access a database on an AS400
The ASP code below is connecting to the AS400 and allows me to interrogate the database.
What do...
I have created 3 tables and inserted records in these tables (see attached code).
I can join table_1 and table_2. I need to be able to join table_3 as well. But I want to aggregate the resu...
I have moved a database from one server to another the OS is the same (windows server 2003) but the new server has SQL Server 2008 whereas the old one had SQL Server 2005.
This database is ac...
hi
1 bytes = 8 bits,
1 - 168 = 255
2 bytes = 16 bits
1 - 16384 = 32768
but to my counting this is only 15 bits? where does the 16 bit come from?
is it 0 - 16384
can anyon...
I have a SQL 2005 Enterprise instance where the auto growth has been set to:
Data - by 1mb, unrestricted
Log - by 10%, restricted growth to 2gb
The data file is 7gb in size, while the l...
I have 2 tables, HEADER & LINES joined by orderID field
The header table has a ShpDate field and the lines table has Qty field, I need to return the week number and the SUM of the Qty field...
see the error...
i am using 2005
Hi,
Is it possible to generate a maintenance plan using T-SQL script?
PS: Link in the first solution is dead...
Thanks
I have a SQL Server I need to connect to through a VPN.
When I go to connect I get the error below. However, when I connect from the same network, different computer it works. I've been trou...
I currently connect to my database through php with a hostname of localhost. The website is hosted by a hosting company and obviously as the script is located on their server this is not a pro...
hi, i have 2 tables sales and details as shown below, i would to have the output shown below, but i am having problems joining and sorting by the sum, can anyone give me a clue as to what i ne...
Hey folks,
I'm a MySQL/PHP guy mostly, so this area is a bit new to me. We have a shipping application, (ShipWorks by Interapptive) that utilizes an SQL Server database. We're running it on...
i get copy from table to another table in sqlserver with :
SELECT * INTO tablenew FROM table1
But the indexes are not copied.
are there some way of copy all index of once? . Table1 has...
Currently I use the SELECT INTO to make a temporary copy of a table within a database (example 1). I'm using Classic-ASP (example#2) But how would I do it if I wanted the new table MYTABLECO...
Hello, I have a customer with a Windows 200x (don't know the exact version, 2000 or 2003, right now) domain. The old domain consists of: 1 Domain Controller, 1 Exchange 2000 server. The custom...
