Viewing 15 posts - 421 through 435 (of 444 total)
OK, but my question was to generate to separate files per table, I could not find it.
June 12, 2009 at 10:04 am
I mean from SSMS / database/tasks/generate scripts ?
June 12, 2009 at 8:40 am
Thanks, Mani. This is exactly what I needed. I found this place, but having now problems with connection to target server, I guess I need to create unified login accross...
June 12, 2009 at 8:38 am
Microsoft SQL Server 2005 - 9.00.4035.00 (X64)
Nov 24 2008 16:17:31
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
June 12, 2009 at 7:35 am
How to script each table in a separate file ?
June 12, 2009 at 7:27 am
When you pass a table name as an input parameter to dynamic SQL, it is really impossible. It is like to task DBA with find all parameter values ever passed...
May 7, 2009 at 2:10 pm
I have some idea how it could be written, but it's not easy to implement.
To parse each word from definition from sys.sql_modules and loop them against all objects in sys.sysobjects.
The...
May 7, 2009 at 1:16 pm
SQL Server current versions: C++, some tools C#
Old versions: fortran
March 17, 2009 at 11:23 am
I checked BOL, but they don't have examples for it. Only logical_expression.
March 12, 2009 at 3:22 pm
Thanks all.
This is what I do. I put all tables in another (non-prinmary) filegroup. But since I can't put stored procedures there I script them out. All of these objects...
March 10, 2009 at 11:51 am
I DO know all the column in each result set, and I know that they are different. Unfortunately, I also suspected that this is impossible.
February 26, 2009 at 11:51 am
But how I can insert data into my_table in the first place ? Numbers of columns for these result sets are different.
February 26, 2009 at 11:02 am
Thanks, GSquare, I will try this too.
February 4, 2009 at 3:00 pm
Viewing 15 posts - 421 through 435 (of 444 total)