upgrading an installation form SQL 2000 to SQL 2008 is as simple as running the msi and clicking next 5 or 6 times;

there is no reason to upgrade to an...

nash this should help you get started then;

this example is finding every tables which have a column named "createdate" and also "changedate"

it then bcp's out the data from each of...

Google Translation of Lowell's Response (9/16/2010)

---

se ve como un controlador OLE nombre específica VFPOLEDB.1 necesita ser instalado en su servidor.

el conductor probablemente ya existe ont que otro servidor, por lo...

yes that's the default trace, which tracks DDL changes made to all databases; it's low impact trace that can be most easily accessed from teh GUI, where it is...

BETWEEN requires a pair of values;

BETWEEN X AND Y

your query:

select StartDate as 'RP Start Date' from [IAG].[Report].[refMonPeriod] where RMP.periodid = 8

returns more than one row...if you cahnge it to select...

ok correct me if i am wrong, but you have a table with ApplicationUsers, so users 'Bob' and 'Tom' are in a table, but the application connects witha single...

it looks to me like the report is designed to be bigger than the paper , isn't it? so it cannot fit untill you tweak it to a smaller width?

or...

my snippets have an open query example slightly different;

i know i've used this to insert into a local temp table

SELECT *

INTO #tmp

FROM OPENROWSET('SQLOLEDB','Server=yourservernamehere;Trusted_Connection=Yes;Database=Master',

...

J i poked around, and did nto find a way to get the output of the columns/structure of a stored procedure (if it returns result set) so far;

if we can...

i took the question about "ports" and "monitor" to be:

how do i tell SQL Server which specific port to listen to...

so if i wanted to make SQL server listen to...

j take a look at this thread from a week or so ago; there is a script contribution that I enhanced and fixed slightly;

http://www.sqlservercentral.com/Forums/Topic981671-149-1.aspx#bm981831

it produces well formatted, informative html document.

I've...

good point Reobert...getting back on topic....

your procedure...does it have defaults on any of the parameters? I would bet that is why it eats cpu cycles...

parameter sniffing.

an execution plan gets ...

drew.allen (9/16/2010)

---

That's because you have your TOP clause in the middle...

you'll need to change the definition of the column from varchar to nvarchar.

the issue can be seen in this example...special charcters get converted to question marks if a varchar field...

pretty much the same:

DECLARE @sql NVARCHAR(100),

@Params NVARCHAR(100),

@data VARCHAR(100),

@TopCount varchar(3)

SET @sql = N'SELECT @data = TOP ' + @TopCount + ' CAST([Salary] AS VARCHAR(100)) FROM [dbo.JobDescriptions] WHERE [JobName] = ''CEO'''

SET @Params...