sql server 2008 can I monitor an email mailbox for new mail
Sat, 20 Mar 2010 10:31:00 -0000
Hi all,
I know that I can send email from sqlserver but how about getting sql server
2008 to do something when new mail arrives? Is this possible?
Our present setup is
1) Mail arrives in mailbox with csv attachment
2) Clerical team read email, forward it to the peroson who will deal with
it, and send acknow ...
|
Modifying user defined data type
Fri, 19 Mar 2010 14:02:27 -0000
Hi
How can I modify a user defined data type which is assigned to several
fields across db?
Thanks
Regards
...
|
upsized SQL Server aplication issues
Wed, 17 Mar 2010 10:11:13 -0000
Hi Guys,
I am in the process of upsizing a MS Access application to a Access FE and
SQL BE. (MS Access 2007 SQL2005)
I used the MS upsize wizard to convert all the tables to SQL format.
I have been going through the application and updating the linked tables to
the SQL database and updating any control ...
|
Date question
Mon, 15 Mar 2010 22:40:47 -0700
In VBA the following will yeild the last day of the current month:
dtmLDM = DateSerial(Year(Date), Month(Date) + 1, 0)
How can you accomplish the same thing in T-SQL?
Patrick
=-=-=-=-=-=-=-=-=-=-=-=-=-
Patrick Jackman
Vancouver, BC
...
|
SQLserver 2008 and Extended stored Procedures
Mon, 15 Mar 2010 08:34:31 +1300
Hi,
I am moving an app from SQLServer 2000 to SQLServer 2008.
It has extended stored procedures in the master database.
The first Xp Sproc I tried failed with inability to load the dll or
one of its dependencies.
Can I use a 32 bit dll in SqlServer 2008 running under WinServer 2008
64 bit?
thanks
Bob ...
|
Connecting question
Fri, 12 Mar 2010 14:53:32 -0800
I am converting a VB 6.0 dll from using Jet data to using SQL Server data.
What is the recommended approach for a dll to connect to SQL Server? The SQL
Server is currently setup for Windows Authentication only. The dll is
installed at present on my development workstation. In production it will be
running a ...
|
MS Sub form feilds
Fri, 12 Mar 2010 18:25:12 -0000
Hi Guys,
I am upgrading a MS Access application the previous version was split to MS
BE and MS FE, I am upgrading convert the BE to a SQL BE The problem I am
having currently is that two of my forms that have a subform for line items.
I have converted the record source to use the converted SQL tables, yet, ...
|
|
|
Access-> SQL upsize, need diagram and SQL create tables code
Thu, 11 Mar 2010 19:12:02 -0800
I just ran the Access upsizing wizard and it migrated the Access tables to
SQL Server.
In the SQL Server mgmt studio I see the database object and tables were
created. There is a folder for Database Diagrams. Is there a way to
generate a diagram of the database?
I would also like to print out the SQL creat ...
|
[NEWBIE] SqlServer 2005 Log
Wed, 10 Mar 2010 17:45:30 +0100
Hello
a little question. Is possibile to activate/see, in Sql Server 2005, a
Full Operation's Log (Select, Insert) of my Database?
Tank you to all
--
>>> www.ceccherini.net <<< ...
|
SQLServer 2008 Management Studio Problem
Wed, 10 Mar 2010 13:38:36 +1300
Hi,
There is a subtlety here that is killing me.
Using dts imported a spreadsheet into a user database.
The resultant table appears in the table list in the LH pane of
Management Studio (MS).
Context menu commands work sort of.
i.e. Edit top 200 records etc give result sets in the bottom R.H.
Window of MS bu ...
|
