Viewing 15 posts - 46 through 60 (of 161 total)
Heh. Small world. I lived in Lewisville and Flower Mound for four years. My wife went back through there a few years after we'd moved and the place had exploded...
September 29, 2008 at 1:57 pm
The Springs is a bit higher, and we lived smack against the base of the mountain, but I don't think the weather patterns would be *that* different. How far out...
September 29, 2008 at 1:32 pm
From your article, and I quote:
Winters are relatively short here in Denver
Which Denver are you living in??? I lived in Colorado Springs for two years. It snowed over Memorial weekend,...
September 29, 2008 at 1:08 pm
We use Tivoli as our primary backup and restore system. What I found is that the Tivoli system can interfere with the normal database processing (soaking up the CPU and...
August 27, 2008 at 10:52 am
A big cake with chocolate icing and lots of pictures! Stuff like this comes in real handy when they're 16 and getting interested in girls!!
Steve G.
August 14, 2008 at 9:28 am
Sorry, I wasn't clear in my previous post - how do you query SQL Server from Access using this sort of technique?
Steve G.
August 13, 2008 at 11:32 am
I do realize that this is just asking for trouble, but how do you do the same thing in Access?
Steve G.
August 13, 2008 at 11:23 am
I think the "linked server" message is a bit of a red herring. SQL Server is simply trying to tell you that it can't connect to the 'remote' data source....
June 20, 2008 at 10:15 am
Dumb question: where is the excel spreadsheet? Remember, the drive reference "d:\import.xlsx" is relative to the server, not to the computer where you're running the query.
Steve G.
June 19, 2008 at 10:24 am
Try using OpenRowSet with a DSN-less connection string instead of going through ODBC to get to the Notes db.
Don't know if this will work, but it might avoid the managed...
June 3, 2008 at 1:03 pm
If you do things this way, you will most definitely have problems. If you have more than one connection, you can have both connections get the same value for the...
May 8, 2008 at 12:52 pm
create table #t (
i int identity(1,1),
a varchar(10),
b varchar(10)
)
go
alter proc t_insert(@b varchar(10))
as
begin
begin tran;
...
May 8, 2008 at 10:00 am
Do these tables have primary keys defined in SQL Server? I've seen this where ODBC will default to read-only cursors for tables w/o primary keys.
Steve G.
April 30, 2008 at 10:52 am
There's a number of things that can be done. Perhaps the easiest is to not use dynamic SQL. That is, move the SQL statements to a stored procedure and pass...
April 30, 2008 at 9:25 am
That does help things a lot, but I think that security oughtn't be ignored (or best practices either, for that matter), even for internal applications.
Steve -kicking in his...
April 29, 2008 at 3:42 pm
Viewing 15 posts - 46 through 60 (of 161 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy