| 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 |
UDF & DATABASE ROLE problem Posted by Sagaert Johan at 5/25/2006 6:15:11 PM Hi
I have an exception when an UDF is called that does a SELECT , the user is
in the db_datareader role list ,so using a select should be no problem
( my other selects from stored procedures poses no problem )
Is there an issue when using UDF's and server roles ?
Johan
...more >>
17805 Starting up Java App server, with SQL Server 2000 Backend Posted by Brent White at 5/23/2006 11:45:54 AM I have a third-party Java program that has not had problems before, but
the app crashes everytime. I go to the SQL Server log and I see an
error 17805 Severity 20 in the log.
I retried starting the app server with a trace running. It gets this
error doing a cursorfetch from this recordset:
...more >>
SQL error with Backup Exec 10d Posted by microsoft at 5/19/2006 11:46:24 AM I have SQL 2005 installed on a Windows 2003 server. I have installed Backup
Exec 10d and get an error when trying to backup the SQL database. I can
see/backup the Backup Exec SQL db but when I try to backup the other SQL db
( used for Sharepoint and Insight ) it gives me this error...
An ...more >>
Problem upgrading named instance in SQL 2000 Posted by sandy at 5/18/2006 2:55:24 AM Hi,
I have installed SQL 2000 Server on my machine with Default Instance
and a named instance viz., Instance1.I tried upgrading
the Database Engine of the Default instance to SQL 2005 Server (using
the 2005 Set up CD). It was upgraded successfully.
I tried upgrading the named instance's Dat...more >>
Excel 2003 doesn't work with SQL 2005 AS Posted by Igor A. Chechet at 5/18/2006 12:00:00 AM Greetings!
We have a connectivity problem between Excel 2003 and SQL Server 2005 AS. We
created cubes and it works OK on server. Then we installed Excel 2003 on AS
server to check connectivity. It works OK. But on any other workstation with
Excel installed it could not connect. It shos the ...more >>
Login Issue Posted by Brandon Owensby at 5/17/2006 11:30:16 AM I have a computer with SQL Server on it that every computer in our office
can connect to except one. The one that cannot connect gets the following
error message.
Server: Msg 18456, Level 16, State1
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'Brandon'
I'm usin...more >>
query returning records that have no related recods in another table Posted by Sagaert Johan at 5/17/2006 12:00:00 AM Hi
How is it possible to run a query that returns a recordset of records that
have no related record in another table ?
Johan
...more >>
Problem connecting to Linked server Posted by sandy at 5/15/2006 9:19:21 PM Hi,
I have installed SQL Server 2005 on 2 machines say machine1 and
machine2. I want to add machine2's named instance (viz., Instance1)
as a liked server to machine1. This I achieve by executing the
following procedure:
sp_addlinkedServer @server='Machine2_Instance1',
@srvproduct='',
@provide...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Alias Name for Dynamic Tables Posted by JasonT80 at 5/15/2006 7:02:02 AM Hi all,
I have an application that creates tables dynamically. These tables have
numbers for names (14523, 14524, etc). This causes our development
environment and production environment to have different table names for the
same data.
I would like to create a permanent alias in SQL fo...more >>
SQL 2000 + SQL 2005 Express Compatibility (restore SQL 2005 DB with 2000 DB) Posted by Marcel Stoop at 5/12/2006 2:56:02 PM Sofar I have used SQL 2000 developer edition. So I was pretty happy that MS
jumped on the freeware train and gave us SQL 2005 Express Server.
I was pretty convinced that it would be easy to restore a new SQL 2005
Express DB with an existing SQL 2000 DB file.
Unfortunately I was not able to do ...more >>
Query analyzer and changing database on the fly? Posted by Major at 5/11/2006 4:16:30 PM How I can change database in the Query Analyzer on the fly if I have
database name in the @db_namd -variable?
I tried:
use master
exec ('use ' + @db_name) and it didn't cause any error messages, but it
still use master...
And how I can query "current database" in the QA?
...more >>
SQL 2000 Enterprise Manager Snap in error Posted by Peter Kwong at 5/10/2006 4:43:01 PM Windows XP Pro PC
installed SQL 2000 Enterprise manager
Query analyser works
but Enterprise manager generates a
Snap-in failed to initialize.
Name: <unknown>
CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
I've tried unregistering the dll referenced in registery, deleted, and
reinstalled.
A...more >>
passwordless login Posted by Rogers at 5/9/2006 12:07:46 PM I have small network and on the server my application is running and all the
client are accessing the application but now the requirement
is that all the users need the passwordless login into the windows but for
the application they have to use their own password.
Is it possible that user c...more >>
maintenace plan error Posted by zino at 5/9/2006 11:47:01 AM in SQL 2005, from my client machine,
when I right click "Maintenance Plan" --> "New Maintenance Plan", I get
the error below:
"
Exception has been thrown by the target of an invocation. (mscorlib)
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC0014049 (Microsoft.SqlServer.DTSRuntimeW...more >>
get Stored Procedures Parameters, how? Posted by Tark Siala at 5/8/2006 8:32:29 PM hi
i make smal Application to get information from SQL Server 2000 by using
VB6.
now i can get Databases, Tables and Colomn, and Stored Procedures, but my
problem how i can get SP Parametres?
i am thinking to make small function to get Parametres From SP.Text, but i
think its not good solut...more >>
which programming is good for front end application to link to SQL Posted by char at 5/8/2006 4:35:01 PM Hi,
I am trying to restructure the current system now. I would like to consult
which programming is good for front end application to link to SQL DB?
Thanks
Char...more >>
OpenRowset during statistics Posted by Alexandre Tavares at 5/8/2006 1:39:58 PM Good Afternon!!!
this message happens in my trace, what this?
I looked in kb's on microsoft and groups of google, but i don't found this
error.
OLE/DB Provider 'SQLOLEDB' IRowset::GatherStats returned 0x80004005: OLE DB
provider SQLOLEDB returned 0x80004005 for OpenRowset during statis...more >>
Timeout Expired With SELECT/WHERE Posted by Scott at 5/8/2006 8:02:01 AM All,
I am using C# to a SQL Server 2005 database using an SqlDataAdapter,
SqlCommand and SqlDataReader.
When running the query I receive the following exception:
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
Does anyone...more >>
Programmatically (C#) creating a database file Posted by Marek at 5/5/2006 11:43:02 AM Hi
I need to create a sql server database file from my code and have not found
anywhere that describes the procedure. I have tried something along the
lines of:
SqlConnection sqlConnection = new SqlConnection(@"Data
Source=.\SQLEXPRESS;AttachDbFilename=C:\Data\MdbFiles\Test.md...more >>
MoveNext Problem Posted by John Lane at 5/5/2006 5:31:03 AM I have Access frontend and SQL Server backend. I use OpenRecordset and
MoveNext in frontend. One of the tables in the query has Identity. For some
reason the record pointer does not advance when MoveNext is invoked. Why?
Thanks....more >>
Logging in a Maintenance plan Posted by Jerry Boggess at 5/4/2006 7:21:02 AM Using the SQL Management Studio to create a Maintenance plan works fine until
I try to click the Logging buttun on a workstation with only the client tools
installed. When I click the Logging button I get a JIT error that tells me I
need to add:
<configuration>
<system.windows.forms ...more >>
Urgent Help Posted by Rogers at 5/3/2006 5:33:48 PM Following is the requirement
ApplicationTable
ApplicationUID AppRef MonthRate DayRate
1 5 25.25 24.12
1 5 45.12 41.52
1 5 21.10 12.25
2 ...more >>
Bulk Load Posted by Bryan at 5/3/2006 11:31:02 AM Does anyone know the most optimal way to copy/update data in a table from one
server to another in SQL without using DTS or replication? Are BCP/Bulk
Insert the only options?...more >>
Column Encryption Posted by Rogers at 5/2/2006 12:23:36 PM I wanna encrypt one column in SQL Server but I want that should be more
secure key, is there any way I can use some encryption method in SQL Server
2000.
Thanks
...more >>
Encryption Posted by Rogers at 5/2/2006 10:52:32 AM I wanna encrypt one column in SQL Server but I want that should be more
secure key, is there any way I can use some encryption method in SQL Server
2000.
Thanks
...more >>
error when trying to create new relaionsship Posted by Mattias at 5/2/2006 9:52:03 AM Hi
I have SQL Server 2005.
I am trying to add a new relationship between to tables.
I receive this error below:
Hope anyone can help me with a solution to this
Mattias
- Unable to create relationship 'FK_Transaktionsrader_Transaktionhuvud'.
The ALTER TABLE statement conflicted with ...more >>
SCAN STORED PROCEDURE. Posted by Rogers at 5/2/2006 9:42:39 AM Is there any scan tool available through which I can scan all the stored
procedures like all are optimized or not?
Thanks
...more >>
How can I get backup gauge? Posted by Frank Lee at 5/2/2006 12:00:00 AM Backup Database has a parameter named stats which will set to respond
percentage finished message. How can I get that message by ADO.Net / ADO?
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |