This function calls an extended stored procedure xp_n_encryptnh, which is a DLL. So dont have any documentation for it now.
well that's the last option. Any ways thanks
yes, it is a third party component. It can be found in the Master database --> User Defined Functions. But it is not documented anywhere. This is...
where can i find the documentation on fn_n_encryptnh?
I am using ASP.NET and SQL Server 2000 for a web application. one of the stored procedures returns me warning as max row limit exceeded. how...
We already installed it twice.
I could not find any information in the event viewer as well as in Error log.
we just had a new SQL Server 2000 Enterprise Edition on a server. After the installation, without rebooting the server we installed the service...
I have run both the commands
there are no open transactions
and the DBCC SQLPERF(LOGSPACE) gave me this result
Ya, it 's crazy. but that's the problem.
the free space left on the drive is 138 GB.
this file belongs to the primary filegroup. previously we...
daily on hourly basis
but the shrink problem is with the data file
it's bulk logged
hi, we have a database having 4 data files placed on 4 different filegroups. In which the primary file size is 20 gb. it has only system tables.
Where I can find some material on the database design? Also I would like to know something about the data patterns.
No I am using the windows authentication with server admin and system admin access.
this is the error I am getting.
DDL Statements not allowed.
the MSDE version is 8.00.884 (SP3). But now the problem is i am not able 2 create any SPs in any of the databases.
what is the problem?
we have sql server MSDE installed on one of our servers. Whenever i try to create a new stored procedure or a table in any of the databases i...
hi, I am having an well formatted XML file, and i want to import the inside in to SQL Server 2000. Can I use SQLXML 3.0 for the same. If yes, how can...
Whenever we use the SQL Server Authentication to connect to the SQL Server, the password we supply, is it case sensitive or we have to set some...
I cross-checked this dates with following query, but it gave me the same result as is shown in the taskpad
SELECT B.name as Database_Name,...
Separate names with a comma.