Viewing 15 posts - 106 through 120 (of 455 total)
rakesh_itcvrce (5/15/2012)
However unfortunately I didn’t get what I want.
Suresh B. : I have executed both the query, I got results but...
May 15, 2012 at 6:52 am
Jeff Moden (5/14/2012)
Geoff A (5/14/2012)
Q1: Why were table variables introduced when temporary tables were already available?
A1: Table variables have the following advantages over temporary tables: •As mentioned in the...
May 15, 2012 at 6:48 am
or this;
select *
From ReportServer.dbo.Subscriptions Subscriptions
where(LastStatus like '%[1-9] errors.'
or LastStatus like 'Error%'
or LastStatus like 'Failure%')
and LastRunTime >= GetDate() - 2
May 15, 2012 at 6:15 am
I know that, But manual failover still changes server names on the app side.
May 14, 2012 at 2:39 pm
re-install with new instance name is the recommened method.
May 14, 2012 at 12:16 pm
Lynn Pettis (5/14/2012)
Between the time it was hidden and the time it wasn't, what had you done in SSMS? At anytime did you access the hidden instance?
yes, because the...
May 14, 2012 at 11:57 am
i have had this issue with a product from a vendor called GFI.
it creates a new database based on time or number of rows in the staging table.
no matter what...
May 14, 2012 at 11:51 am
Perry Whittle (5/14/2012)
May 14, 2012 at 11:44 am
and by Admin login, i mean the NT SERVICE account.
and it its the default instance, you will have to change the server name too.
sometimes, it just easier to re-install. but...
May 14, 2012 at 11:42 am
you do this with sp_dropserver and sp_addserver
a restart will be required.
you will also have to handle the Admin login, msdb SQL Agent jobs and linked servers (if any)...
May 14, 2012 at 11:34 am
Hi Lynn,
Q1: Why were table variables introduced when temporary tables were already available?
A1: Table variables have the following advantages over temporary tables: •As mentioned in the SQL Server Books Online...
May 14, 2012 at 10:46 am
or even better, declare a table variable.
declare @temp table (MyColumns varchar(128),......)
insert into @temp
exec usp_myprocedure
May 14, 2012 at 10:40 am
you always could let the app create the databases and then move the files by de-attaching and re-attachning them. the app will not care (or at least is should not...
May 14, 2012 at 10:11 am
thanks for the reply.
just reading your response made me consider things I had not previously considered.
in my case, i guess my biggest worry is this senario;
Server1 has a single 150...
May 14, 2012 at 7:34 am
May 14, 2012 at 5:13 am
Viewing 15 posts - 106 through 120 (of 455 total)