The only other (painfull) suggestion would be to manage all the code that uses the linked server eg tie it down into stored procedures etc, and ensure it only does selects. Maybe you would also have to consider using openrowset rather than linked servers to ensure noone else uses the connection. Personally I'd try and […]
2003-09-03
1 reads
Hi All, We just checked one of my colleague's DEV Database Server Log for "Starting up database xxxxxxx" yesterday. We have restarted the SQL Server (7.0). As soon as we restarted, within few mins, we could see "Starting up database xxxxxxx" few times. Didn't know why its happening. It should not be caused by Auto […]
2003-08-26
1 reads
That's exactly what I did in PHP and it worked fine. Although, it seems to me there was some other character that needed replacing as well.
2003-08-21
1 reads
The apps running on the server are written in house. Why do public require select access to system tables ? For some tables ok, there may be a need. But for public to have access to tables sysusers, sysobjects etc etc it seems a bit crazy...
2003-08-19
2003-08-15
What is the type of the variables? If you're using integers, your division is an integer division, truncating the fractional part. Check the division operator in BOL for more info.
2003-08-15
Also do you have any large transactions (ie large number of rows updated) etc. that may still be open and require rollback when you failover?
2003-08-07
1 reads
2003-08-06
Something that no one has mentioned is that you could use a single table that looks something like: create table legacy_struct ( struct_name varchar(255) , -- the class name of the struct struct_instance int , -- an identifier for the instace of the above class field_idx int , -- identifies the field number in the […]
2003-07-30
1 reads
2003-07-29
1 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