Viewing 15 posts - 361 through 375 (of 411 total)
They were fully qualified, and they are going into the correct database. They were meant to be stored in master per the company standard policy, and they were. ...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 16, 2007 at 5:28 pm
Well, I stand corrected in 2K at least. I have only used 2K5 for a while now, but always good to learn things I didn't know before.
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 15, 2007 at 4:43 pm
Can you provide more detail? Its hard to say much based on this so far.
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 15, 2007 at 2:15 pm
Ah, of course, you have to love all of the new features. 😉
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 15, 2007 at 2:14 pm
Jeff Moden (12/15/2007)
Actually, it's a common problem... take a look at what you have for a "default catalog" when you login... credits to Navy beans says it's "Master".
That it is....
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 15, 2007 at 12:37 pm
I know what sp_ms_marksystemobject does. Maybe it would have been more clear if I had said I only use create procedure and that is all. Some of...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 15, 2007 at 12:13 pm
No, I always use create stored procedure Name
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 15, 2007 at 8:12 am
Assuming all your harddisks have that much free space available, I don't see any reason not to stay with what you have.
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 14, 2007 at 3:52 pm
TaffyLewis (12/14/2007)
select t1.A, t1.C, t2.C
from t1 inner join t2
on t1.A = t2.A
and t1.C = t2.C
t2.c is the date field
When I try to run the Max on this I generate...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 14, 2007 at 2:52 pm
Jeff Moden (12/13/2007)
[font="Courier New"]SET @Cmd = 'DEL \\dt-sc2\shares\Data.txt'EXEC Master.dbo.xp_CmdShell @Cmd[/font]
If you are a stickler for avoiding error messages like I am you could add xp_fileexists to Jeff's piece to avoid...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 14, 2007 at 2:48 pm
TaffyLewis (12/14/2007)
I have 3 fields A, B and C in a table. Field C is a datetime...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 14, 2007 at 1:29 pm
The first big question is if the company has a policy regarding access to certain information. I have dealt with institutions that require certain people be notified any time...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 14, 2007 at 12:37 pm
I have seen similar issues and do not have a true solution, but a possible work around would be using xp_cmdshell with the script that is sending the mail to...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 14, 2007 at 8:26 am
If you can add a column which differentiates which table is which in some fashion, something as simple as a column that directly lists a table name or perhaps giving...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 14, 2007 at 8:23 am
The first thing to do is create a stored procedure to actually accomplish the deletion for you and test it safely. IT could be something as simple as :
create...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 14, 2007 at 8:11 am
Viewing 15 posts - 361 through 375 (of 411 total)