Viewing 15 posts - 3,451 through 3,465 (of 7,631 total)
Glad we could help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 10, 2009 at 7:04 pm
I suspect that whatever connection you are using lacks the necessary permissions to administer logins. You could try to use trace/profiler to see what SMO is attempting to do...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 10, 2009 at 6:54 pm
riga1966 (3/10/2009)
Apparently there is a very simple solution.I just named that header dummy column as
"A_NEW"
"A_CLOSE"
"A_UPDATE"
and inside "Union All" sorted list by column name.
I get my header at the top now.
I...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 10, 2009 at 6:42 pm
Danny: If you check my posts in this thread, you will see that I had already done all of those things and it still was not working. Turned...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 10, 2009 at 6:39 pm
There is no such thing as "a table with a direct ODBC connection to the database". That does not make sense in the context of SQL Server. Can...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 10, 2009 at 12:55 am
Like this:
Select o.object_id
, c.column_id
, o.name
, c.name
, ROW_NUMBER() OVER(Order By o.object_id, c.column_id) as RowNum
From master.sys.system_objects o
Join master.sys.system_columns c
ON c.object_id = o.object_id
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 10, 2009 at 12:51 am
This seems highly subjective. In my experience, Log shipping is dead easy to setup and has virtually no maintenance overhead.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 10, 2009 at 12:30 am
Mohit: This is a SQL 2000 forum, so no ROW_NUMBER().
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2009 at 11:39 pm
Good. Then you aren't there yet. 😀
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2009 at 11:16 pm
Here's how to get the third item:
Select TOP 1 * From (
Select TOP 3 * From (
Select TOP 5 * From syscolumns
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2009 at 10:59 pm
You've got "begin"'s with no "end"'s. Add in the "end" and you should be fine.
This works by contructing a big string and then executing it. "+" is the...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2009 at 10:32 pm
DavidB (3/9/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2009 at 10:15 pm
Here's one way:
Declare @sql as nvarchar(MAX)
Set @sql = ''
Select @sql = @sql
+ 'Create trigger ['+TABLE_SCHEMA'].[tr'+TABLE_NAME'_auto]
on ['+TABLE_SCHEMA'].['+TABLE_NAME'] for INSERT,UPDATE,DELETE as
{your-stuff-goes-here}
'
From INFORMATION_SCHEMA.TABLES
Where TABLE_TYPE = 'BASE TABLE'
Print @sql;
EXEC(@sql);
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2009 at 9:46 pm
I think that you will find the XML.value method most useful. Hardly anyone uses OPENXML anymore now that the XML datatype and methods are available.
If you could post an...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2009 at 9:23 pm
Well I am going to assume that you table structure description is incorrect, and the your query attempt reflects that actual structure of your data.
If so, then this should do...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2009 at 8:14 pm
Viewing 15 posts - 3,451 through 3,465 (of 7,631 total)