Viewing 15 posts - 1,021 through 1,035 (of 1,539 total)
saivko (6/18/2009)
How do you declare a linked server? Something like this failing example:DECLARE @linkedserv CHAR;
SET @linkedserv = [srvname];
GO
SELECT * FROM @linkedserv..database.dbo.table;
You have to add a linked server, not declare...
June 18, 2009 at 2:03 pm
adams.squared (6/18/2009)
If ShopDay between 1 and 5 then exec sp_ClassA
If ShopDay between 6 and 18 then exec sp_ClassB
If ShopDay between 19...
June 18, 2009 at 2:00 pm
can u try to re-write this query using if-else....
Check BOL for syntax...
June 18, 2009 at 1:48 pm
what i can think of is there is a setting in the job. If job step fails, go to next step. just check that out to be sure...
June 18, 2009 at 1:39 pm
slava davidchuk (6/18/2009)
My question is:
How can I create a sql backup where backup file would have ONLY a backed up database name.bac?
No date stamp in the backup file...
June 18, 2009 at 1:27 pm
I still cant see my past 3 posts that i made. am seeing only 3 new posts in past 30 minutes(not mine)... I've myself posted 3 posts... 🙁
hehehe.. there are...
June 18, 2009 at 1:23 pm
Steve - This is happening with some other threads as well. For example i got email notification abt http://www.sqlservercentral.com/Forums/Topic735571-291-1.aspx?Update=1 thread which was not visible in the active thread even tho...
June 18, 2009 at 1:14 pm
Pradyothana Shastry (6/18/2009)
then select your publisher choose properties then choose Subscription Options Check schema replication is true if not make it true.
This will replicate...
June 18, 2009 at 1:12 pm
you may also want to go through this article.
http://www.sqlservercentral.com/articles/Log+Shipping/62676/
This guides u to setup log shipping manually.
June 18, 2009 at 12:54 pm
By the time someone provides a solution, you may also want to go through this article
http://www.sqlservercentral.com/articles/Replication/logshippingvsreplication/1399/
Managing replication might not be easy and the volume of transaction ur system is...
June 18, 2009 at 12:50 pm
I've written the 3rd column as 0 (no of employees in other queries). i'm assuming that assets description is unique.
select distinct vw_astAssets.Description, 'MSI',0,
(SELECT COUNT(*)
FROM vw_wrkWorkOrders A where...
June 18, 2009 at 12:19 pm
That checkbox is visible in enterprise edition. Can u post the result of this?
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
If you are not running enterprise edition, u'll have to setup log...
June 18, 2009 at 11:55 am
check out for sp_addlinkedserver in BOL
June 18, 2009 at 8:19 am
No, I think i misread database as server!!
In that case he doesnt need to bother abt linked server....
Thanks Lowell for pointing the mistake.
June 18, 2009 at 8:15 am
try this.
declare @filename varchar(100)
set @filename='T:\Program Files\Microsoft SQL Server\Backup\TRACKIT70' + convert(varchar, getdate(),112) + '.bak'
BACKUP DATABASE [test] TO DISK = @filename WITH NOFORMAT, NOINIT, NAME = N'Test_DATA-Full Database Backup', SKIP, NOREWIND,...
June 18, 2009 at 8:12 am
Viewing 15 posts - 1,021 through 1,035 (of 1,539 total)