Viewing 15 posts - 181 through 195 (of 280 total)
I'm pretty sure that it depends on the way the index is accessed.
If it is accessed by an index seek (nested loop), then it shouldn't matter how many...
November 29, 2011 at 2:07 am
SpringTownDBA (11/29/2011)
sql = "execute sp_retrievedept" & request ("iddept")
set rsdepartment = dbdepartment.execute(sql) //
can you post the value that the variable "sql" is being set to. Are you...
November 29, 2011 at 1:35 am
sql = "execute sp_retrievedept" & request ("iddept")
set rsdepartment = dbdepartment.execute(sql) //
can you post the value that the variable "sql" is being set to. Are you missing...
November 29, 2011 at 1:24 am
You should be fine with 2008 db engine hosting the SSRS 2005's databases.
BACKUP YOUR ENCRYPTION KEY FIRST!
Process would be fairly simple, stop SSRS, restore reportserver and reportservertempdb to the...
November 29, 2011 at 1:04 am
I'm not sure I understand your question.
Are you asking if it is secure to connect via remote desktop to the sql instance's virtual ip instead of connecting to the node's...
November 29, 2011 at 12:42 am
Steve Jones - SSC Editor (11/28/2011)
November 29, 2011 at 12:34 am
Here are a couple of options, I'm not sure which is the best.
1. create a CLR stored proc and call the proc from a T-SQL job step.
2. create a ssis...
November 29, 2011 at 12:01 am
john.campbell-1020429 (11/28/2011)
Try the following from a query window on the database in questioncreate table #temp(tablename varchar(120), reccount int)
go
sp_msforeachtable 'insert #temp select ''?'',count(*) from ?'
select * from #temp
Congratulations, you've just done...
November 28, 2011 at 11:25 pm
Saga... (11/24/2011)
Environment is like
OS :Windows 2000 SP4 Enterprise edition
memory ...
November 24, 2011 at 9:51 pm
james.jensen1350 (11/17/2011)
<mytable keya="101" keyb="A" keyc="1" value="8.33">
<mytable keya="102" keyb="A" keyc="3" value="22.5">
<mytable keya="103" keyb="M" keyc="4" value="0.18">
...
In other words, have each element...
November 17, 2011 at 10:12 pm
agiangone (11/17/2011)
November 17, 2011 at 9:40 pm
If I had to guess, I'd say that either $db or $db.Rules is null.
November 17, 2011 at 9:19 pm
Oh, you shouldn't need to change any of the addresses in that window.
November 17, 2011 at 8:34 pm
You use that window to specify which ip addresses on your machine you want sql server to listen for connections on.
The addresses with hex numbers are ip6 addresses.
http://msdn.microsoft.com/en-us/library/ms177440(v=SQL.90).aspx
what error message...
November 17, 2011 at 8:34 pm
Viewing 15 posts - 181 through 195 (of 280 total)