|
Problem Transact-SQL Statement
I've come across a Transact-SQL statement as follows:
-- Statements start here
select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from
sysobjects where type = 'U'
-- end here
Questions:
(1) How should the 'select' statement be interpreted?
(2) What are the rules for using the quotati ...
Fri, 7 Jan 2005 00:36:32 +0800
|
Using Enterprise Manager to view a single Database
Hi all.
I've been working with SQL server for a few years now, but I've never needed
to solve this specific problem before, and I'm a little stuck
Perhaps someone here can help me
I have a user who needs to use Enterprise Manager tool, but I only want him
to have control over a single DB, and NO control ov ...
Wed, 5 Jan 2005 13:09:44 -0000
|
What about indexes?
Are you sure that all your table indexes are recreated on the SQL 2000 sp3
server?
I guess you have in some way transferred or recreated the tables on your new
system . If you used a script you will have to select a checkbox to include
your table indexes in the script.
Whenever SQL Server 2000 does not ...
Mon, 3 Jan 2005 22:38:15 +0100
|
SQL 2000 slowness!
Hi,
I have a very strange problem. I have one sql 7.0 box, and one sql
2000 sp3 box. An ASP app that we've been running off of the 7.0 is
now running about 10x slower on the 2000 box. The 2000 has more ram,
faster processor, and both are running on WinNTsp6a. I have checked
all the possible settings betw ...
31 Dec 2004 11:11:47 -0800
|
SQL Serevr Service Manager
I get "Access Denied" message when I choose one of the
remote SQL server and the entire services list is blank.
What has gone wrong? Please help..... ...
Wed, 29 Dec 2004 18:09:39 -0800
|
Analysis Manager Error
I've been getting the following error message whenever I
try to connect to my remote server to work on some cubes.
"Cannot open connection to Analysis server 'WRPBI'
Error in data [possible data corruption]"
How can I fix it? I've reinstalled Analysis Manager but
it didn't help.
Thanks
...
Wed, 29 Dec 2004 18:07:15 -0800
|
Question about relationships - "cycles or multiple cascade paths" error
I have 2 tables:
Table: UserTable
Field: Id (pk)
Field: FullName
Table: MarriageTable
Field: MarriageId (pk)
Field: Husband
Field: Wife
The MarriageTable.Husband and MarriageTable.Wife fields BOTH have to be
valid users from the UserTable.
In SQL Server I'm creating a relationship diagram. I (1) ...
Wed, 29 Dec 2004 10:01:20 -0500
|
SQL Servers Entries
All
When ever I changed the my password I am loosing all my SQL Server Entries
from my SQL Server Enterprose Manger ruiing on Windows xp. Can some one help
me how can I get back my entries.
RB
...
Tue, 28 Dec 2004 11:50:16 -0600
|
Automating data source setup?
Hi there!
I've succesfully setup a client installation by using sqlcli.bat, but I want
to take it a step further and also setup a valid datasource. I know it can
be done by manipulating the registry database, but I wonder if there is a MS
tool that does all that?
--
I doubt, therefore I might be.
...
Tue, 28 Dec 2004 17:14:34 +0100
|
Query Analyzer not running
Hi,
I installed SQL server 2K on my winXp Pro, and have created a few tables in
my sql database. When I want to enter some data using Query Analyzer from
the Tools menu...but for some reasons it never bring up Quezy Analyzer...
Any ideas?
thanks in advance.... ...
Thu, 23 Dec 2004 16:01:03 -0800
|
How can I see how many SQL CAL's I have?
How can I see how many SQL CAL's I have on my server. I know how many I am
licenses for, but want to make sure I regulate this on this server. Is there
a license manager I'm not finding?
--
Spencer
http://www.wasatchsoftware.com ...
Thu, 23 Dec 2004 07:33:08 -0800
|
Convert 1084313300 (Ten Digit) value to Datetime
I have a field in a table that contains ten digit value representing a datetime. Is there any way to convert it to default datetime format.
Plese Help me
Thanks
--
Message posted via http://www.sqlmonster.com ...
Thu, 23 Dec 2004 02:03:35 GMT
|
Error 17805 Invalid buffer received from Client when executing stored Procedure
Hello,
I am receiving this error when I try to execute a Stored Procedure in
SQL Server 2000 using SYBASE dblib.
I have been able to connect to connect to SQL Server from Unix, but
when I try to execute a Stored Procedure via dblib, I get the error:
"Error 17805 Invalid buffer received from Client"
M ...
21 Dec 2004 12:11:58 -0800
|
Problem Using if condition in select stored procesure
Hi!
how can i use if condition in where clause of select statement
I want the work like this
but this is not working correct
select * from Table1
where
if (@a>1)
field1=@a
else
f ...
Tue, 21 Dec 2004 15:07:13 +0500
|
Random Pauses In Client Execution
I am running an accounting program that uses SQL Server 2000 SP3 for the back
end and uses Access 2003 RT for a user interface. There is about 200000 rows
per table with about 150 tables. My problem is that at what seems to be a
random interval everyone that has the accounting system running on their
machin ...
Mon, 20 Dec 2004 10:55:02 -0800
|