Search results for query: *

This might be an answer... If it can be done from VB, it can probably be done from other languages as well. Still it will be a lot more complicated that the few-parameter call I had in mind. Thanks. regards, Paul

Microsoft Analysis Services regards, Paul

The sp_help procedure, among many other things, gives the id column. The T-SQL code of sp_help can be seen either through the Enterprise Manager, or in the Query Analyzer with the command: exec sp_helptext sp_help in the Master database. regards, Paul

this should do: select name from syscolumns where id = object_id('<table>') and colstat & 1 = 1 taken from the sp_help procedure regards, Paul

Hello! I wonder how I can process an OLAP cube from T-SQL. You would expect there to be either some predefined (extended) stored procedures, or at least command line calls that can be used within xp_cmdshell. I can find neither in BOL. Anybody knows how to do this? Currently I am calling...

I do not have an idea why your database was switched to single user. I do know that it has nothing to do with 'truncate log on checkpoint'. Try to make another database and see if it also automatically is in single user mode. Could you be running the server in single user mode? This is done with...

Any idea what the file was used for? As far as I know .trn is not a standardly used extension in SQL Server. Was it your database logfile? The logfile is per default .ldf. Check whether there is a .ldf file for your database.

That is my question: How to copy BOL favorites to another server? Is there a simple way? Have to do this for every course I give. Thanx.

The problem may be dynamic file growth of either database- or log file. This can take quite some time. Looking at file sizes before and after your operation it is easy to determine if it is. (Also the performance monitor is very instructive! What is the system doing all this time?) If file...

Could it be that an ODBC interface setting truncates data at 1692 characters and cause the problem? Check it out. Good luck!

Check out sp_attach_db

The problem may be in your interface, e.g. ODBC, that truncates the data. So check your interface settings. The database in my view cannot be the problem. good luck

The Microsoft Official Curriculum for Administration of SQL Server 7 states that Novell clients can use NT authentication using Multiprotocol and NWLink (answer to review question 2.2). I'm surprised it can, or is it a mistake? And if it can, I don't understand it. Anybody who does ? Thnx.

IE is also used by the Enterprise Manager, for instance while presenting information for a database. Right click the detais pane to see the HTML source.

This is a very strange thing to want in a RDBMS, however you can dynamically build an SQL statement and execute it with EXEC. You can thus select all the rows and create a table with exactly that number of columns, to enter the data you can do something similar.