Viewing 15 posts - 9,226 through 9,240 (of 13,469 total)
niteshrajgopal (6/17/2010)
I would really really appreciate it if you could do a sample of that form for me as...
June 18, 2010 at 5:41 am
when you create a linked server, you have one of 4 security options to use as far as which credentials.
I suspect that the first option shown in the screenshot below...
June 17, 2010 at 6:08 pm
from the GUI, it's not obvious how to alias an existing SQL Server:
--#################################################################################################
--Linked server Syntax for SQL Server With Alias
--#################################################################################################
EXEC master.dbo.sp_addlinkedserver @server = N'MyLinkedServer',@srvproduct = N'', @datasrc = N'DBSQL2K5', @provider...
June 17, 2010 at 12:15 pm
biren (6/17/2010)
June 17, 2010 at 11:54 am
goodguy (6/17/2010)
@Lowell: most tables have the PK as the first column, yes, but some tables have composite PKs, made of two/three columns. Will it...
June 17, 2010 at 10:39 am
here is something very similar to what Wayne posted, the only difference is my script makes an assumption that the FIRST column in a table is the Primary Key because...
June 17, 2010 at 8:10 am
are you trying to get a boolean value?
DateDiff returns an integer, your example seems to be doing this:
FORMAT (DateDiff("DAY", Fields!ReAdmitDate.Value, Fields!AdmitDate.Value) >= 30)
'would be the same as this witht he...
June 17, 2010 at 6:46 am
if you can log in to SQL Server, master is not corrupt; could it be the logins were deleted?
If you open Object Explorer in SSMS, and expand the Security>>Logins...
June 17, 2010 at 6:37 am
i have this saved in part of my snippets; it's scripting all the users for every role ; you could parameterize it to limit it to one role if desired:
--example...
June 17, 2010 at 6:31 am
in TSQL, you'll want to use the DATADD function. when you add a negative number, it subtracts it from the date: you can use it to add or subtract any...
June 17, 2010 at 6:17 am
it's been removed as a separate executable, and is all the pieces are moved around a bit, but are accessible in part of SSMS:
June 16, 2010 at 3:50 pm
ok try this as a proof of concept: in your Sandbox, do a Select * into newtable from sometable, and then run this query:
i'm using FORXML to concat all the...
June 16, 2010 at 2:53 pm
well syntactically, i think this is correct, but it's untested:
SELECT * FROM OPENQUERY( [linked server],'SET FMTONLY OFF; EXEC (''declare @body1 varchar(4000)
set @body1 = ''New Website Product as of '' +...
June 16, 2010 at 12:56 pm
it might also be parameter sniffing; if you have parameters with default values on them, a query plan is probably built assuming the default value (ie myproc(@The date datetime =...
June 16, 2010 at 12:51 pm
Set @Job = '<HTML>The following opportunity has been changed to ' + @Stage + ': '
+ '<br />'
+'Subject: '+ @Subject
+ '<br />'
+'Project Number: '+ @ProjectNumber
+ '<br...
June 16, 2010 at 12:44 pm
Viewing 15 posts - 9,226 through 9,240 (of 13,469 total)