Hi there The disk on which the tempdb (SQL2000) is located is unstable. How do I move the TEMPDB to another location? OR alternatively provide a startup parameter to allow SQL server to startup creating tempdb in a specific location? Any help appreciated.
2002-01-10
I need to update a dimension during Business hours while minimizing the impact on my Users. I'm thinking the best way to do this is to define two dimension tables with a single view on top. While one physical table is loading during the day the other is being used by the view. When the […]
2002-01-07
1 reads
Running SQL7 and someone opened and saved a DTS with Enterprise Manager for SQL2K...Now I want to redesign it with EM7 and I receive the following message: Error source: Ms DTS package Error desc: The parameter is incorrect... I dont want EM 8.0 on my PC. Any hints?? Thanks in advance!
2002-01-07
Hello everybody. With my SQL servers I can only check the login id failure but not the IP address of the intruder. Did anybody know the SQL 7 way to have the IP address of the intruder logged in my SQL logs ? Thank's for advanced. Dennis from ADT France. Edited by - Kevin75000 on […]
2002-01-07
3 reads
I am trying to connect through ODBC, using the SQL Server Driver, to an MSDE database located on an NT server. I am able to ping the server without any problem, but when trying to connect through ODBC I am getting a Connection Failed. I am using the SQL Server authentication, entering 'sa' as the […]
2002-01-05
4 reads
Hi all Im running sp2 on my win2k pro with sp2 pc. It verifies my sa (and win authentication) users (ive tried both), shuts down the sqlserver service but cant re-start it, telling me to verify my login. I can start it manually without a problem and the service starts fine on a reboot. What […]
2002-01-02
2 reads
Is there anything similar to Oracle's create table as select statement in SqlServer 2000? ex. create table dimension as select a.division b.department_name c.employee_name from division a, department b, employees c, where c.department_fkey = b.department_key and b.division_fkey = a.division_key
2002-01-02
8 reads
Andy says it's not the greatest book for preparing for the 70-100 exam, but the case study is worth reading for it's explanation of the Microsoft Solution Framework. Read the full review!
2002-01-02
3,605 reads
First, I apologize for this post that is not really related to SQL Server. However, I have always had good responses on this forum, and this particular question has left me searching for answers everywhere. I have an ASP page that downloads a CSV file of data. In this data are some IDs that should […]
2001-12-31
5 reads
Can anybody provide me with an example of to use the Dynamic Task Property to rename files? Thanks!
2001-12-28
3 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers