Viewing 15 posts - 5,806 through 5,820 (of 7,429 total)
I have also heard mixes of ActiveScripting to come that will replace TSQL itself to make things easier on all developers. Anyone else confirm?
"Don't roll your eyes at me. I...
May 19, 2002 at 6:10 pm
See if this offers any help.
quote:
Fixing Decimal Data TypesIf the stored procedure you are calling includes a parameter with the SQL Server...
May 18, 2002 at 7:08 pm
Try this then
update t1 set t1.col1 = 'abc'
from
t1 t1x
inner join
t2
on
t1x.col2 = t2.col1
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 18, 2002 at 6:50 pm
Hard to say without the rest of the details but take a look here may help you find the answer http://support.microsoft.com/default.aspx?scid=kb;en-us;Q300676
"Don't roll your eyes at me. I will tape them...
May 18, 2002 at 7:45 am
Yes, but not the other way around.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 18, 2002 at 7:42 am
Can you post you ado parameters (what you tried and what you did) and your SP definition? This will help us understand why or what was occurring.
"Don't roll your eyes...
May 17, 2002 at 8:24 pm
Did you get a specific error when you tried sp_changeobjectowner? And also did you remember to use the existing owner to reference the object.
sp_changeobjectowner 'existingowner.tablename', 'dbo'
The reason is dbo is...
May 17, 2002 at 8:22 pm
Sorry BOL is SQL Books Online. You just used to using the abrev version of things. Sorry it has been a while since using OPENROWSET but look in BOL for...
May 17, 2002 at 8:17 pm
Are you doing this just to delet the log. If what version are you using of SQL?
If 7 then use
BACKUP LOG DBNAMEHERE
WITH TRUNCATE_ONLY
Then look here for a script to...
May 17, 2002 at 3:23 pm
1) When you create the link it should tell you the value type is int or something else for that column. I have heard people make statements about this problem...
May 17, 2002 at 3:16 pm
I believ if you open the properties linked server connection on your 2000 box and goto the last tab (in EM) you need to turn Data Access on, and RPC...
May 17, 2002 at 1:29 pm
Use DTS. Open EM and drill thru Data Transformation Services to the package location. Create a new package, there you can define a connection to SQL, a Connection to XLS...
May 17, 2002 at 12:49 pm
Actually it doesn't, not like ytou are thinking. The reason ?..sp works is ? run the SP under the context of the database referenced first. But if the sp doesn't...
May 17, 2002 at 12:46 pm
If you built your SP in master then do
exec sp_msforeachdb '?..sp_grant_revoke ''revoke'', ''developers'', ''P'''
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 17, 2002 at 11:20 am
DBF should be FoxPro which SQL supports already.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 17, 2002 at 10:55 am
Viewing 15 posts - 5,806 through 5,820 (of 7,429 total)