MDX

RE: SQLDMO Error

• by Andy Warren

• TechNet Blogs

• Reply

Havent seen that before. Just a guess, maybe an instance where someone renamed the proc in Enterprise Manager? Andy http://qa.sqlservercentral.com/columnists/awarren/

2003-05-08

1 reads

Tables involved in a Full Table Scan ?

• by grajee

• Database Journal

• Topic

Hi All, I was monitoring, using the Performance Monitor of Windows, the Stress Test conducted on the database and I noticed that there were quite a few Full Table Scans. But I dont know how to drill down to the actuall tables involved in the Full Table Scan and I was wondering if someone could […]

2002-03-25

Track the Changes in Design Mode

• by Alik

• Database Journal

• Topic

I have a 'Production' and a 'Test' SQLServer7 databases on 2 different Servers. Let's say, I've made some changes in the design mode of the Production database. Is there any way I can track this changes on my Test database (I don't care about actual data so far). Basically speaking, I need to see all […]

2002-03-21

DTS Package execution

• by jhall156

• MSDN Communities

• Topic

I have created a DTS package to pump data into visual foxpro tables. I execute this package through a vb com server in a stored procedure where I modify the package's tasks (3 pumps, 1 SQL task and 1 ActiveX script) based on different criteria. This is a process that enters orders from the web. […]

2002-03-05

Please help Do we have security in Desktop Engine?

• by imgharavi

• Database Journal

• Topic

when we copy the database file (.mdf and .ldf) from a server to another server with another sa password, then new system admin can easily attach that files to his server. what can we do to avoid this ? Please help.

2002-03-03