Browse by Tags
All Tags » SQL Server (RSS)
-
Any solution to this? I am having the same problem.
-
Hi,
Will there be any problems when a MOSS environment is installed in 64bit (WFE=64, Seach/Index=64, SQL2005=64) and a K2 installation of 32bit (1 server with workspace and databases)?
-
Hi Alex,
I've not attempted this with SQL Views, but you could try:
SELECT * INTO YourNewTableName FROM YourExistingViewName
as this will create a table from your view.
If you want, you can get SQL Server Agent to run a job to recreate this table every hour or something with a TSQL statement like:
use ...
-
I am trying to use a SQL Server view (not a table) to provide a denormalized (joined) dataset to an InfoPath form via a smartObject, but the SQL Service doesn't seem to see views, only tables. Any ideas about how to get around this?
Thanks,
-alex
|
|