|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Help replicating a sql server database Posted by kbrickey at 10/14/2006 9:03:28 PM I need to replicate a SQL Server 2000 database that exists in a hosted
environment with only primative web-based management tools. I have one tool
that creates a .bak file, and another tool for running queries. There seems
to be no way to automatically script the tables the way we can in Enter...more >>
maintaining foriegn keys / tables Posted by Jason at 10/14/2006 4:09:14 PM In a common security tables design with
users
roles
userroles
table users:
userid (k)
name
email
table roles:
roleid (k)
role
table userroles:
roleid (fk)
userid (fk)
and a view combining both functions
userview :
name email role userid roleid
I'm looking to maintain...more >>
Create Index (Specifies the options to use when you create the ind Posted by RBC at 10/14/2006 3:34:02 PM Hi,
Are there someone who have experience usning the options when you create
indexes?
Will I have any problems in the future if I use following options???
{
PAD_INDEX = ON, --Default OFF
FILLFACTOR = 63, --Default 0
SORT_IN_TEMPDB = ON, --Default OFF
IGNORE_DUP...more >>
selecting last 3 months of data? Posted by Jason at 10/14/2006 11:31:19 AM I know
select * from tablea
where month(datefielda)=month(getdate())
will give me this months records,
How can I select data from this and the prior two months, with logic
that will work in January?
...more >>
xp_cmdshell with .txt file Posted by WCM at 10/14/2006 7:52:02 AM I can create a .bat file and then execute it from QA. Example:
use master
exec xp_cmdshell 'C:\MyFile.bat'
Question: I know there is also a way to use a combination of simple script
file (.txt not .bat) and sql script wth embeded xp_cmdshell. Does anyone out
there have a working example of ...more >>
How To Optimize Query ! Posted by lovely_angel_for_you NO[at]SPAM yahoo.com at 10/14/2006 1:26:57 AM Hi,
I too much workload on my current SQL Express 2005 database, by sending
two queries, when I know it can be done with just one. I am doing
something like this:
Set rdset = CONN.Execute("SELECT Count(*) AS TotalCnt FROM mydata
Where PName='" & LoggedUser & "' AND CaDate>='" & Format$(...more >>
Question on writing data to a different database Posted by Kevin S. Goff at 10/14/2006 12:24:01 AM Hi, someone asked me this question today, and I didn't have an
answer....
Inside a database trigger, they want to write out data to a different
database on the server.
Can this be done, and if so, what's the syntax?
Thanks,
Kevin...more >>
managing and synchronyzation of DB on LAN Posted by Muhammad Ahsin Saleem at 10/14/2006 12:08:40 AM Hi Everyone
I have a DB shared on LAN. In that DataBase there are two tables in
it.One contains information abt the companies with whome my company
deals.
Other has the information about the employees of my company who deals
with the other company.
Now I want that data from both the ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Password Posted by David at 10/14/2006 12:00:00 AM Hello all.
Not really a "programming" question, but, I have a login table that I want
to store the password in the form *******, just like in Access 2000. Access
2000 has an Input Mask property for text based fields, How do I do that in
SQL Server 2005? My column is called "Password" and is a...more >>
Group sales totals by Payment type Posted by steve at 10/14/2006 12:00:00 AM Hi All
I am using Sql server express and am having trouble obtaining the totals of
payment types over a date range
I have a sales table with columns..
mydate, InvoiceNo, Cash, Cheque, CC, Account, Total, Gst etc
1/10/2006 1 20 0 20 0 ...more >>
SQL Server Express 2005 security authentication Posted by Rob Pollard at 10/14/2006 12:00:00 AM Hi All,
Is there an easy way to configure SQL Server Express 2005 to use its own
Db logon rather than the windows logon? I have found the tick box to switch
it over, but I'm guessing that to get this to work I will need to do some
kind of account management?
Thanks in advance
RobP
'The...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |