| Groups | Blog | Home |
|
November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Reporting Services connecting to Oracle Posted by isabelle at 6/21/2005 4:59:02 PM Hi,
I got a request to setup so that Reporting Services can connect to an Oracle
database. When they select a data source, I see ODBC but I also see an
option that's called Oracle. What do I need to setup/install on my SQL
Server so the developers can create a report that connects to an O...more >>
Group Question (I think) Posted by Dvanderm at 6/21/2005 4:14:19 PM strSQL = "SELECT SA, ProblemType, Count(ProblemType) as ProbType FROM
Problems WHERE RptDate >= " & sIn(bDate) & " AND RptDate <= " & sIn(eDate) &
" GROUP BY SA, ProblemType ORDER BY SA"
Results Look like this - no space in between different SAs.
Steve Monitor 1
Steve Printer 1
...more >>
Comparing two databases Posted by Gabe Matteson at 6/21/2005 12:21:51 PM Are there any tools that allow you to compare two sql server databases to
find out what is different between them (the database structure, including
tables, relationships etc)? Thanks,
- Gabe
...more >>
help with stored proc Posted by Deon Joubert at 6/21/2005 12:20:54 PM Can anyone tell me why this stored proc is not updating the REMAINING field
when it runs the first time?
ALTER PROCEDURE SP_CHANGECAPACITY
@COCODE INTEGER
AS
DECLARE @SECTION CHAR(10) /**/
DECLARE @DATEE SMALLDATETIME /**/
DECLARE @OPR INTEGER /**/
DECLARE @EFF FLOAT /**/
DECLARE TEM...more >>
Security Migration Posted by Help Needed at 6/21/2005 1:19:03 AM I have 2 servers in my company which is server A and server B. Server A will
end of life at the end of this year and I wish migrate the whole database to
Server B.
I wish to know how to migrate Login setting to Server B
the Login is in Microsoft SQL Servers > SQL Server Group > Server B > ...more >>
SQL 2005 newsgrousp... Posted by Amit Bansal at 6/21/2005 12:00:00 AM Hi,
Is there any separate news group for SQL Server 2005?
...more >>
(SQLExpress) Import .sql file howto ? Posted by MAF at 6/20/2005 12:00:00 AM Hi every body,
I have recently find out we can train ourself on SQL Server thanks to
the Express Edition.
So I'm trying to import a db structure (.sql file) and then fill it with
some data given in another file (.txt)
But I can't find any relevant documentation (a reference guide for
ex...more >>
Print Queries Posted by Hossein Shamloo at 6/19/2005 2:17:29 PM Hi
how can I print queries in color mode
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Locks/Process ID Posted by Gabe Matteson at 6/17/2005 10:56:27 AM I have been trying to track down a database problem in which for some reason
when somebody enters in some data into the database it becauses unavailable
for the application. I looked under Locks/Proccess ID and found that one of
the proccess is 'blocking' can somebody elaborate as to what sor...more >>
Running a batch file from SQL Server Posted by Much Moishe at 6/16/2005 3:01:10 PM I have created a small batch file that runs a DOS command to copy a file.
When I run it from the DOS prompt, it works fine. When I try to run it as a
scheduled job, it fails (even though it is reported as successful). When I
run it from DTS, it works.
Can anyone shed some light on what may ...more >>
Connecting to an msde instance over the internet Posted by Jav at 6/16/2005 2:44:01 PM I have access to the Server (Win2003 SBS) through Remote Desktop Connection.
I need to change the Permissions of a DataBase Role in the msde instance on
that server. I can't seem to find a way to connect to that instance. Is it
even possible through a Remote Desktop Connection?
Thanks for ...more >>
How to link tables Posted by bob at zachys at 6/16/2005 2:37:28 PM How do I query one table In database A from Database B on the same server. ...more >>
Linking tables Posted by bob at zachys at 6/16/2005 2:14:07 PM How would I go about linking a table in one database to anouther database on
the same server? I need to qry related data from one table to anouther table
in different databases. I know that I can import the data, but I was hoping
that there is a better way....more >>
showcontig Posted by erdem at 6/16/2005 12:23:29 PM hi everone
i have question about DBCC SHOWCONTIG results of Table
we have table with huge amount of data in it. When i run ''dbcc
showcontig('<TableName>') with fast, ALL_INDEXES,TABLERESULTS ''
i saw that most of indexes have logical fragmentation over 80%
then i run DBCC dbreindex and...more >>
Transactions not taking place Posted by Gabe Matteson at 6/15/2005 1:16:42 PM Is there anyway that I can view the status of a transaction? To see if the
data even reached the database. Apparently some data that users are inputing
into this application, lets say they input 5 rows, sometimes they don't show
up in the database, so I am trying to find out if it even made it...more >>
Varchar Posted by HenryC at 6/15/2005 11:53:20 AM If a given text field is always 3 characters or less, is there a reason why
varchar(3) is better/more efficient etc., than varchar(4). Or does it really
make any difference? I was told when designing the table it really doesn't
matter. Is this true? If varchar(3) is the same as varchar(10), wh...more >>
Looking for the last table updated Posted by Gary Rynearson at 6/15/2005 10:15:53 AM Is their a way to query database metadata to find the last tabe / view
updated?
Gary
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |