I have a local program that uses .mdb, and I update internet .mdb overwriting the database day by day. so, i need to do the same but from .mdb to sql database. what should I do ? regards, Martin Gomez.
2001-08-09
3 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/dpoole/whatskillsdoesadbaneed?.asp
2001-08-09
3 reads
Has anyone got any figures of the effect on the server of processing XML in the database. I am currently of the thinking that to gain the most out of the server XML should not be used in the database. Any thoughts?
2001-08-08
8 reads
How do you get the object_id of a table or any objeect on another server dynamically ? I have tried : select object_id("@servername.@dbname.dbo.attendance_details") It returns NULL. When i try to get the id without the use of variables ie. select object_id("servername.dbname.dbo.attendance_details") The query still returns NULL. I am executing it in a query in a […]
2001-08-02
7 reads
Hi all I have two small OLTP databases (4 gig each)...are have around 450+ users on average throughout the day, generating around 500Mb in logs on the best of days. I am doing full backups @ 2am and log backups from 7am to 11pm - all daily. The backups are going to two RAID-1 arrays […]
2001-07-30
2 reads
The following stored procedure will demonstrate the use of cursor metadata. Using cursor metadata we can get information about an SQL statement and use that information to dynamically generate other code such as HTML or other stored procedures.
2001-07-27
5,064 reads
Hi all Im trying to deny the "alter table" command for a schema user. Basically I dont use DBO, the applications in the database get their own userid and create object using it. Ive created the following role to deny schema access but can add to it the "alter table" command to stop developers from […]
2001-07-25
196 reads
This article presents a method of outputting the results of a query as a tab delimited text file using COM.
2001-07-20
6,570 reads
My ASP file doesn’t access my database." "I can’t connect to my database from my code." "I’m having problems calling and debugging stored procedures." These are some of the problems I hear every day as a Microsoft® developer support engineer.
2001-07-20
2,008 reads
Hello, I've created the alert for Memory-Pages/sec Alert Over 2 in Performance Monitor, I'm getting net send message as Pages\sec is being over 2. I'm confused and what should I do to overcome it. My production server has 523 MB Ram and I've specified SQL Server to use memory dynamically setting max as 440 MB. […]
2001-07-19
8 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