| Groups | Blog | Home |
|
March 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 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 |
Through Microsoft Access Posted by msnews.microsoft.com at 8/31/2005 4:26:13 PM I have a database in the sql server and I want to give read only access to
that database to my client but client want to access that database through
Microsoft access... is it possible?
...more >>
Parsing SQL Posted by Dave at 8/30/2005 12:54:14 PM Hi,
Does anyone know of any components that could parse an SQL module as I wish
to semi-implement SQL on a non-standard data structure. Is there something
equivalent to VBScript component or the XMLDom component I could use in VB?
Dave
...more >>
sql Mail Attachment Posted by pjscott at 8/30/2005 11:46:50 AM Hi all,
I'm using sql 2000 and Access 2002.
I have a Maintenance Project with a form that creates a Maintenance
work order. When the work order is completed a Report is sent using
Outlook.
The problem is some people use a computer that their e-mail isn't
setup on and this causes a pro...more >>
Procedure update time Posted by Farhan at 8/30/2005 4:24:14 AM hi
How can I Identify when the procedure was updated last time.
Farhan Iqbal...more >>
EXCEL / SQL SERVER HELP - URGENT Posted by MS User at 8/26/2005 10:02:06 AM I got a stored procedure with 1 parameter and I want to call this stored
procedure inside an Excel Query ,
I tried
..dbo.MySP ?
It return with error message
"Parameters are not allowed in queries that can't be displayed graphically"
The purpose for this approach -
This would allow m...more >>
Cannot install SQL Server 2005 CTP on WinXP Pro machine Posted by jdang at 8/26/2005 7:33:04 AM Hi all,
I have tried to install SQL Server 2005 CTP version on my machine WinXP Pro
-1GB RAM but it gave me the following error.
/**********************************
The SQL Server System Configuration Checker cannot be executed due to WMI
configuration on the machine USPC180 Error:214774...more >>
SQL / SQLCE Synchronisation Issue??Help Needed Please!!! Posted by steroche at 8/19/2005 2:57:41 PM Hi guys,
I have a problemo - basically i have one large SQL2000 DB. This is
edited / updated etc by users of the website i am developing. However i
also wasnt a SQLCE component as i want certain users to recieve
user-specific information from the database to their PPC's (I don't
have access to ...more >>
How to write query Posted by Yoshitha at 8/19/2005 1:02:55 PM I have a table with the fileds empid,empname,designation,branch.. etc I
have 5 types of designations CEO,BM,PL,Tester,and PRG and the two branches
those are Hyderabad and Visakhapatnam i need the query like
first CEO name next Hyderabad BM Name next Hyderabad PL name next Hyderabad
Testername ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
enterprise manager error Posted by sql server 2000 enterprise manager at 8/17/2005 1:23:02 PM Hi,
When trying to modify or add a table using enterprise manager I got this
message error:
Enterprise manager: not enough storage is available to complete this
operation.
I have a lot off space available.
I don't have a memory leake.
My server is Dell PowerEdge 2850 with tho CPU ( 3.6 G...more >>
SQL problem pls help Posted by cEcILle at 8/16/2005 2:46:40 PM I have installed Visual Studio 2005 beta 2 that include the SQL Express.
Then I installed the SQLClient to my pc too. And when I click on the sql
group
An error message pops up
"A connection could not be established to Computername\sqlexpress.
Reason:To connect to this server you must u...more >>
sql optimization Posted by ypul at 8/16/2005 12:53:43 PM Hi,
Which newsgroup will help me in optimizing my query..
can any one help ?
Regards
ypul
...more >>
Client alias on 64bit server Posted by Adam Shepherd at 8/16/2005 9:55:03 AM We have just upgraded a 32bit server to 64bit Windows 2003, we had client
alias working correctly before when os was 32bit but now we have gone to
64bit i can't get any aliases to work.
I've tried configuring exactly the same alias on a 32bit machine and that
works but if the server is 64bit ...more >>
SQL 2000 and MSDE question Posted by Lamar at 8/15/2005 7:52:57 PM I have one windows 2003 server running Exchange 2003. It is also running
MSDE. What I want to know is can I install the full version of MS SQL 2000
while MSDE is on the same server. Can they coexist with each other?
TIA,
Clayton
...more >>
SQL DB VERY BLOATED Posted by Peretz Stern at 8/15/2005 11:36:33 AM About a month ago I setup a Server and named it SQL1 I setup a maintenance
plan and all was well. I needed to rename server to SQL. I went onto the
server today to take a look around and noticed that the DB is 133GB instead
of 35GB. When I when to make some changed on the maintenance plan I go...more >>
Why the table is locked ? Posted by Trung at 8/13/2005 1:06:02 AM Dear all,
I have Access Font End to SQL server Back end.
In an Access form, I use combobox, based on a stored procedure, which based
on 1 table (SELECT LocationID, LocationDescription FROM Locations).
When I open the form and check in the SQL server Enterprise Manager, go to
Current Act...more >>
Can't connect to Access project Posted by lindab at 8/9/2005 7:21:04 AM I've given a copy of Access project to user (win2000prof) but not able to
connect to SQL server on remote server.
SQL driver in use on client is 3.70.09.61 - this gives error DBNMPNTM
specified SQL server not found.
On my PC ( XP and SQL driver 2000.85.1117.00 ) it connects with same login
...more >>
number format to 2 decimals Posted by ypul at 8/9/2005 12:00:00 AM How can I format my data to 2 decimal numbers in sql ?
select numericColumn from table1
ex :-
numericColumn
---------------
10.22
20.00
30.45
12.02
regards
ypul
...more >>
Security issue Posted by Farhan at 8/8/2005 3:12:01 AM Hi all,
I have create a temporary user with public db role and give him select
permission on one view, this is perfect for user defined objects scenario,
that the user can not access any user defined objects but the issue is here
that the user can access system objects and system db’s obje...more >>
How can I use MDX functions in SQL Query Analyzer (Client Tool) Posted by slintz at 8/3/2005 5:21:02 PM I'm very new to using MS-SQL stuffs and the IT dept here doesn't have any
DBMA to speak of. Thus, I'm a bit on my own - except for you helpful
people...
I just installed the Client Tools on my workstation and tried a simple query:
SELECT IIf(TBL.fld is NULL, "-N/A-", TBL.fld) FROM TBL;
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |