Viewing 15 posts - 991 through 1,005 (of 1,131 total)
In order to drop a table in a database, the login must have one of these privileges
1. Server level System Administrator role.
2. Database db_owner role
3. Database ddl_admin...
SQL = Scarcely Qualifies as a Language
October 25, 2005 at 10:43 pm
Is the vendor app using any of extended stored procedures especially the Object Automation procedures ? These xps begin with sp_OA%.
There are many problem with the Object Automation procedures including:
1....
SQL = Scarcely Qualifies as a Language
October 25, 2005 at 8:32 pm
Doesn't t1.id1 *= t2.id2 translate to a RIGHT OUTER JOIN ?
t2.id2 =* t1.id1 (reversing the condition columns and outer join), should translate to a LEFT OUTER JOIN.
For clarity, I have...
SQL = Scarcely Qualifies as a Language
October 25, 2005 at 8:08 pm
I have eliminated everything that is not relevant to simplify the problem. See the tables and data and the end of this message.
Based on the generated date, the expected...
SQL = Scarcely Qualifies as a Language
October 25, 2005 at 4:29 pm
For working the the trace, below are SQL statements to summarize Stored Procedure Executions and Select statement. You will need to change the trace table name as needed.
I usually look...
SQL = Scarcely Qualifies as a Language
October 25, 2005 at 1:22 pm
The documentation on the EventClass numbers to descriptions is well hidden in Books OnLine and at http://www.microsoft.com. Below is the SQL to create a table with all of the EventClasses...
SQL = Scarcely Qualifies as a Language
October 25, 2005 at 1:07 pm
The permissions to manage DTS Packages should have already been granted to public (i.e. everyone). To confirm, run
exec msdb.dbo.sp_helprotect @username = 'public'
The output should include execute rights for...
SQL = Scarcely Qualifies as a Language
October 25, 2005 at 12:52 pm
No, deadlock information cannot be detected by applying the transactions logs after a restore because only successfull events are written to the log and unsuccesfull events are not written to...
SQL = Scarcely Qualifies as a Language
October 24, 2005 at 6:35 pm
Is the SQL in a stored procedure ?
There are some alternatives:
1. Pass the part numbers as a single string as either fixed positions or delimited. See http://www.sommarskog.se/arrays-in-sql.html for how to...
SQL = Scarcely Qualifies as a Language
October 24, 2005 at 4:19 pm
There are extended stored procedures that allow processing of in-bound emails messages BUT you must be using Exchange and the Exchange Server must be in the same domain as the...
SQL = Scarcely Qualifies as a Language
October 24, 2005 at 3:23 pm
If this is a hierarchy, see oracle's proprietary "connect by".
SQL = Scarcely Qualifies as a Language
October 24, 2005 at 1:08 pm
Since the stored procedure is not being passed the date format, there is no way to determine how to convert.
For example, if being passed '2005/10/12', is this the 10th day...
SQL = Scarcely Qualifies as a Language
October 24, 2005 at 1:07 pm
Please post the update statements.
Without using a case, this is the only alternative that comes to mind:
Create table #C
(StudentID, OldChoice , NewChoice)
insert into #c
(StudentID, OldChoice , NewChoice)
select 1111 , 'Music',...
SQL = Scarcely Qualifies as a Language
October 23, 2005 at 1:29 pm
This is not correct as shown below.
From SQL Server Books OnLine regarding GO:
Your program should behave in the same manner as the utilities. When a GO is found, the...
SQL = Scarcely Qualifies as a Language
October 23, 2005 at 7:33 am
You are doing fine and there is a klugy work-around for mapping global variables that is at http://www.sqldts.com/default.aspx?234.
Basically, the steps are:
1. Have a dummy sql statement that is on one...
SQL = Scarcely Qualifies as a Language
October 22, 2005 at 7:29 pm
Viewing 15 posts - 991 through 1,005 (of 1,131 total)