Search results for query: *

You must be using SQL Server PRE-2000. 2000 has direct editing capabilities. Move to it whenever possible. It's great! (Been using SQL Server for 8+ years, since 4.2).

Hello! Differences in ASP from the Query tool are often related to SET OPTIONS. The best way to begin digging through the differences is to fire-up SQL Trace and point to the website you are trying to debug. Run (or refresh) the page in question and capture the actual SQL that is executed on...

If the table (or any SQL Server object, like a stored procedure or view) was created by someone OTHER than the DBO (database owner), you have to specify the dbo name if it's someone other than the person logged on.<br> <br> For our production environment, we always create the objects as the SA...

No, this should not cause any problems -- it is doable. You should not notice any differences in your application (the Access forms) when you move your data into SQL Server. <br> <br> It's a good move to get your db out of Access. It's a great tool for prototyping or working with data -- but...

Yes, we are deploying the web as one way to access our University Data Warehouse. We use SSL for securing the network transmission -- but the web interface is accessable anywhere -- we do not lock the ip addresses down to our campuses.<br> <br> I am the Data Administrator for the University of...

Thanks for sharing -- I will take a look and provide feedback.

Great! Thanks for the tip.

Good question. Allow me to clarify. I am the Data Administrator for a multi-campus University. I was hoping that there were others engaged in building/deploying a data warehouse within a University setting.

We use SQL Server for a data warehouse at the University of Nebraska. If you want to look at blow-by-blow instructions on how to use common desktop applications, such as Access, Excel, Lotus 123, Word, etc., you can find configuration details at...

In addition to dumping the log on checkpoint (provided you are using full database backups, rather than incremental log backups...), a second measure we take on a daily basis with each of our databases to groom the log is to run the following code for each db:<br> <br> /* Cleanup logs */<br>...

Anyone on this forum involved in Data Warehousing in a University context?

Does anyone have a Distance Learning public site -- or a prototype application available for public viewing? Would love to cruise through some "example" applications which demonstrate integration of technology designed towards easing the learning experience/promoting collaboration and...