Hello Experts,
I have table which has been updated with the newly added product information, all I wanted to do now is to copy all the data from this table and export into the table on the ...
The log file of one of the databases on my SQL SERVER 2000 has grown to over 123GB. I need to shrink it down and control it's growth. It's on a 250GB drive with only 15GB free.
In SQL Ser...
Hello,
I have a table which consist of 7 million rows & 110 columns with data type set to nvarchar (originally taken imported using SSIS + flat file) in SQL Server 2005. My goal is to give...
My sql script executes an mdx query as dynamic sql within a cursor. It works beautifully when I execute it in a query analyzer window. It also works when I run it within a sproc on the dev s...
When I check in Activity Monitor of SQL Server 2005 I also see few connections in sleeping status. I understand if C#.NET application is using Pooling, for performance reason SQL Server does n...
I have been trying to figure out why this wont work, any suggestions would be much appreciated.
Basically i want to check the DB system for the stored procedure 'sp_BasicSelectStatement' , ...
We are trying to use this function of SQL 2005 standard (openrowset) to bring in data from user imported / exported files.
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DAT...
Bulk inserting a file using at format file, e.g.
9.0
2
1 SQLCHAR 0 0 "\t\"" id c1 ""
2 SQLCHAR 0 0 "\"\n" text c2 "Latin1_General_BIN"
i.e reading a two column file, first an integer,...
I have a file that gets exported from an Excel spreadsheet. The time in the spreadsheet is saved in 24 hour format as a number in Excel (ex: 0900 or 1530). When import SQL simply sees these ...
MSSQL 2000
I'm trying to write this simple SQL statement
SELECT CASE col2 WHEN NULL THEN -1 ELSE col2 + 4 FROM mySimpleTable.
Its not working. I understan I could do
SELECT ISNULL (col2 ...
Please can someone kindly help me with the following....
Specifically trying to work out how I can combine the results of a stored procedure with a SELECT statement....
Trying to achieve...
Hello,
I installed SQL Server 2005 but had some issues so had to remove it. So i uninstalled it and tried to reinstall
everything worked properly but when i try to install reporting servic...
Hi
I use microsoft SQL server 2000
I have a table of person names and I have the follwing SQL
SELECT FirstName FROM Names
This gives me one column with a row for each person.
Now I ...
Is it possible to downgrade a SQL 2008 database so that is can be restored in 2005?
my website is down and come up with the following error message
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not alloc...
Hi,
I have two tables of news feed NewsHeader & NewsDetails
NewsHeader:
Time Header
10:15:34 AM News1
10:15:34 AM News1
10:15:34 AM News1
11:19:39 AM News2...
Window Server 2003 Service Pack 4
SQL 2005 Service Pack 2
I can create foreign key through sql code like
alter table table_name
add constraint constraint_name
foreign key (column_name)
...
I am getting this error on my database server.
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was fo...
I am trying to follow the metalink doc to set up ODBC connections:
https://metalink.oracle.com/metalink/plsql/f?p=130:14:7406918959791655811::::p14_database_id,p14_docid,p14_show_header,p14_...
Assume that I have table of shops (shop_id, shop_name) and table of consumers (consumer_id, consumer_name, shop_id) where each shop can have multiple consumers. I would like to create persiste...
How do I go about importing Excel 2007 (.xslx) data into SQL 2000?
We are able to import data from Excel 2003 into SQL 2000 using the following:
SELECT * FROM OPENROWSET('Microsoft.Jet.OLE...
Something is going on with a few of my SQL Servers lately. My SQL Server logs are filled with lots of the backup error. For each of my database, there is a set of the error messages like t...
I have a web server and I'm trying to allow remote connections using both TCP/IP and named pipes. Whenever I set it using the Surface Area Configuration I get the following error.
Can anyon...
I have a table that has, Email, logdatetime, by counting the user for a given logdatetime I can get the number of user per day,by using
select count(case when convert(varchar(8),logdatetime, ...
I can't figure out the best way to copy a table from a database on one server to a table on another server. The tables are structured the exact same way. I just can't figure out how to specify...
