|
Problem with Best Practices Analyzer and set nocount on.
Hi.
There is a bug with BPA.
When you configure a server with sp_configure 'user options',512 or EM
(default connection options) seting to NOCOUNT ON, BPA fails when reading
the catalog.
Esio
...
Wed, 12 Jan 2005 13:20:47 -0300
|
How to recreate/restore the database from the data and log files
My development system hard disk crashed and I have lost the Operating
system and the SQL executables and the system cannot be salvaged.
However at the time of the crash the server was not running and the
log files and the data files of the database were on another hard
disk. I have managed to successfully rec ...
12 Jan 2005 03:58:30 -0800
|
Tools for export data definitions to word or excel
Are there any microsoft tools available to export SQL database tables &
column names with description to word or excel ?
I know we can use Visio reverse engineer to get the ER diagram but that is
not what I am looking for.. ...
Tue, 11 Jan 2005 14:19:01 -0800
|
Cannot connect to SS 2000 across Internet
I am attempting to connect to a named instance of SS 2000 across the
Internet using Enterprise Manager. The machine running SS is behind a NAT
router. According to BOL I should be able to connect if I forward the TCP
port that SS is using (1061 in my case) and UDP port 1434 to the SS
machine. However, I can ...
Tue, 11 Jan 2005 06:49:15 -0800
|
DB shld b available thru our Front-End App not any other means SQL Ent. Mgr etc.
Hi,
The users are made accessible to SQL server thru a windows group say member users of AppUserGroup. whoever is the member of this group can access sql server thru any client application like SQL Query Analyzer, SQL Enterprise manager.
While the data & table, procedure design etc. at backend is sensitive & we ...
Tue, 11 Jan 2005 10:30:10 GMT
|
Newbie requires advice on Log Shipping
Hi,
Trying to setup up log shipping in a test platform in a workgroup between
Two Enterprise Edition servers. Running through the Maintenance Plan wizard i
get as far as copying the Initialization.Bak file to the share on the primary
server, but it falls over trying to copy to secondary server giving the ...
Tue, 11 Jan 2005 01:05:04 -0800
|
MYSQL and Reporting Server
Hi All,
Not sure if this is the best place to ask this, but how can I use
parameters in a report connecting to a MYSQL database.
Thanks
Michael ...
Tue, 11 Jan 2005 16:58:28 +1100
|
SQL Query Analyzer cannot bring up all the database in Object Brow
when using the enterprise Manager, I can read 12 database.
But when I use the SQL Query Analyzer, I can only read 6 DB. They are
Master, Model, Msdb, Tempdb, Northwind and pubs.
I try to disconnect and connect again or refresh. It didn't help.
Can anyone give me some suggestion on how to fix it? ...
Mon, 10 Jan 2005 21:05:10 -0800
|
Query Analyzer Adds Blank Line in Scripts of Objects
I was wondering if anyone knows why Query Analyzer will add an extra blank
line when editing objects?
Here's how I can reproduce the problem:
1. Edit an object in QA, let's say a stored procedure, by right clicking on
it in the object browser and choosing edit
2. Execute the script
3. Again, choose the st ...
Mon, 10 Jan 2005 06:43:03 -0800
|
How to get BLOB using PHP
I am told this is a BLOB image from a 7.0 server I querried. Next I
list the charactors from the table field.
0xFFD8FFE000104A46494600010201009600960000FFED123A50686F746F73686F7020332E30003842494D03E900000000007800030000004800480000000002DA0228FFE1FFE102F902450347052803FC00020000004800480000000002D8022800010000 ...
10 Jan 2005 06:01:53 -0800
|
How to restrict access our DB on SQL server.
Hi,
How can we restrict our DB if connecting thru other applications like SQL query analyzer, Excel & even Enterprise manager?
but this DB should be accessible by our application (from front end) only...
I learned about "Application Role" in SQL server 2000 but to apply this
we will have to change our code tho ...
Mon, 10 Jan 2005 12:49:45 GMT
|
Why does "Select ... FOR XML RAW" only return one row.
Hi
I have the following simple query
SELECT Forename,Surname FROM Customer FOR XML RAW
This only returns one row with all the records in this one row. Does anyone
know how I can produce a row for each record?
Thanks
Dwight
...
Mon, 10 Jan 2005 04:13:04 -0800
|
view transacations
Is there a way to view a list of transactions on a database table (both
inserts and updates)?
Derek ...
Fri, 7 Jan 2005 12:57:01 -0800
|
SQL SNMP Problems
Dear All --
I've been trying to get SNMP monitoring working properly on SQL Server
2000 on Windows Server 2003. Unfortunately, I didn't install SNMP until
after I had installed SQL Server.
I have, however, followed the instructions regarding copying over and
registering the sqlsnmp.dll file and adding t ...
Wed, 05 Jan 2005 16:25:48 -0800
|
Recreating database on production machine?
I know that you can use the graphical tools in Enterprise Manager to create
a database. If I choose this path and create a db on my test machine, how
do I create the same db (i.e. the physical sche ...
Wed, 5 Jan 2005 07:39:31 -0500
|