I have a domain user account that I used to run sql server services. But I don't know how to give that account an administrator's right on my sql server machine. My sql server install on a different server with the domain controller and both of them use windows 2000. Could somebody help me please […]
2002-01-13
I could use some step by step help on using the DTS FTP. I need to pull a file from an FTP site, and the filename changes daily. Only the first two characters ('al') and the '.txt' extension are how I identify which file to get. How can I set up the FTP task to […]
2002-01-11
Does any one have any advice for Commerce Server 2000 on SQL Server 2000? I am looking for anything that might be of importance when I go production with this product and what the concerns are in maintaining the DB side of the house. Rob DeMotsis Sr. SQL Server DBA Pier 1 Imports, Inc.
2002-01-11
I'm currently using SQL 7.0 to load a fixed length text file into a table. The all the fields in the table are varchar and nullable. The table has the same design as the layout of the file. When I create the connection to the file I am able to map out the columns and […]
2002-01-10
5 reads
Hi We have a Database on SQL Server and Mirror version of it on Oracle on a Web-server. When I make structural changes to the SQL Server DB via a Script of DDL, I would like to be able to take this script and convert it to Oracle DDL to apply to the Oracle DB. […]
2002-01-09
3 reads
Has anyone encountered a bug that if you do a select into using a left join and an order by, all the columns have their nullability set to nulllable. In sql7 you can get round it by creating a view with a top 100 percent and the order by, but even this doesn't work in […]
2002-01-08
4 reads
I have always used full backups to backup databases. Tansaction log backups are used for databases that have data constantly being updated. I have never seen the need or logic behind using differential backups. Maybe this is because the largest databases I have ever managed have only been 2.5 GB in size and so can […]
2002-01-03
Dears, I have set up a MS SQL 7.0 server, in a win2K server, and have put several databases in it. Although I have set up "Windows Integrated Authentication", meaning that everybody who can access the local LAN has the right to use the database, no one except me (Administrator of the SQL) is able […]
2001-12-26
1 reads
Comments posted to this topic are about the content posted at http://www.microsoft.com/mspress/developer/feature/110101.asp
2001-12-23
3 reads
Can any boby tell me why this error occurs and how to solve this: Error :- --------- 'TempCustomers' table - Unable to preserve security settings for user ''. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is no such user or group ''. ------------------------------------- Following is the script that was generated by the Entrp.Manager when I […]
2001-12-19
102 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