Locate information

Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L S
See if this helps:
http://vyaskn.tripod.com/search_all_...all_tables.htm
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Leandro Loureiro dos Santos" <nao@.falo.com.vc> wrote in message
news:%234kyqLnPEHA.3660@.TK2MSFTNGP11.phx.gbl...
Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L S

Locate information

Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L SSee if this helps:
http://vyaskn.tripod.com/search_all..._all_tables.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Leandro Loureiro dos Santos" <nao@.falo.com.vc> wrote in message
news:%234kyqLnPEHA.3660@.TK2MSFTNGP11.phx.gbl...
Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L S

Locate information

Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L SSee if this helps:
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Leandro Loureiro dos Santos" <nao@.falo.com.vc> wrote in message
news:%234kyqLnPEHA.3660@.TK2MSFTNGP11.phx.gbl...
Hello,
How can i locate a information in any fields of any tables?
I was wondering to generate Txt about all tables in my database, but with
DTS i can only do that with a table.
Does anybody can help me?
Thanks
Leandro L S

Local Cubes Creation...

Hi,

1. Has anyone been able to generate local cubes in SSAS2K5 using XMLA? I run profiler while running a CREATE GLOBAL CUBE but wasn't able to view the relevant XMLA code that creates the local cube.

2. After running a CREATE GLOBAL CUBE on one of our cubes and, while trying to access it using Excel 2003, I am not able to choose a cube (the cube list is empty!!!!).

Thanks,

Joao Bilhim

With regard to (2) - if the Create global cube statement succeeded -it would have created a .cub file in the directory that you specified. You should be able to select it directly in Excel and access it.

Local Cubes Creation...

Hi,

1. Has anyone been able to generate local cubes in SSAS2K5 using XMLA? I run profiler while running a CREATE GLOBAL CUBE but wasn't able to view the relevant XMLA code that creates the local cube.

2. After running a CREATE GLOBAL CUBE on one of our cubes and, while trying to access it using Excel 2003, I am not able to choose a cube (the cube list is empty!!!!).

Thanks,

Joao Bilhim

With regard to (2) - if the Create global cube statement succeeded -it would have created a .cub file in the directory that you specified. You should be able to select it directly in Excel and access it.