General - Other SQL Server Topics

Thread preview

Thread	Last Post	Replies

SQL Query date doubt	27 Feb 2010 18:21 GMT	1
Please, could you help me with this SQL query ? I need get data from last 3 months, but it´s shows me only January's data. (Query doesn´t get data from november and december/2009)
*count() by hour**	26 Feb 2010 23:19 GMT	2
I have this query SELECT COUNT(*) FROM Pro WHERE D_TIME BETWEEN '2010-02-14 00:00:00.000' AND '2010-02-20
Split a period of time	26 Feb 2010 22:44 GMT	1
Suppose you were looking at widget manufacturing data, and your DB looked like this: tblWidgetsProduced dtStartTime
Linking/attaching access tables	26 Feb 2010 21:34 GMT	1
Is it possible to link access tables to a sql server 2005 db? I can't seem to find any option in Management Studio. Thanks Regards
BUY FAKE PASSPORTS OF GERMANY,FAKE GERMAN PASSPORTS FOR SALE! FAKE UNITED KINGDOM(UK) PASSPORT	26 Feb 2010 18:35 GMT	-
Our team is a unique producer of quality fake documents. We offer only original high-quality fake passports, driver's licenses, ID cards, stamps and other products for a number of countries like: USA, Australia, Belgium, Brazil, Canada, Italia, Finland, France,
209395 Reserch anything, nerw content up to date all sites 37	26 Feb 2010 04:59 GMT	-
I fell in love with the net and all the compuiter teahcnology in the very early years and have loved it ever since, I have an IT Degree and Communications degree and will be working on my doctorate for the next five years, in bwetween I design websites, databases, Multimedia ...
Would Appreciate Some Table Schema Guidance...	24 Feb 2010 00:25 GMT	1
I don't really have a problem per se but since I am not a 24/7 DB developer I'd appreciate an experienced set of eyes to provide some feedback (and help me avoid future problems). I am getting under way with designing a new MS SQL DB architecture
Design question	23 Feb 2010 14:31 GMT	6
I've been tasked with designing an application to capture data about sports clubs. Let's say there are four different types of club - Soccer, Cricket, Rugby and Tennis. For various reasons it is essential that data about
how to extend existing entity table in db without adding new columns every time	23 Feb 2010 08:06 GMT	4
I am trying to design a db schema (or rather extend existing db schema). My goal is to extend the database table so that every time a new column is needed, we dont go about adding the new columns by altering the table. Here is some background.
Place a message in the outbox of Outlook	23 Feb 2010 07:54 GMT	-
Is there anyone out there who can tell me how to place a simple message from within T-SQL into my Outbox of Outlook (not Outlook Express) on the same machine? I have SQL Server 7, I don't have an Exchange server and I haven't setup Mail in SQL Server.
Question on the life of a temp table	22 Feb 2010 23:07 GMT	6
Here is the senario: I have a stored procedure (we'll call it ProcA) which builds a cursor then loops over the cursor calling another proc (we'll call this one ProcB) for each record. I need to create a temp table inside ProcB.
SQL 2008 ENT Access	21 Feb 2010 08:30 GMT	1
I have a SharePoint farm running and connecting to a SQL 2008 default instance. However, it looks like the domain "Logins" within the MGMT Studio are gone; I do not see any domain accounts nor can I perform any sys admin
Security question	20 Feb 2010 23:41 GMT	2
I have created a database called ALIS with schemas logically related to company departments: usr All Users acc Accounting
Script irregularities w/ SQL Server Agent & Powershell	20 Feb 2010 01:22 GMT	1
I will need to perform a nightly rebuild of a database during the pre-release testing phase of a project. The build and populate is performed by a number of .sql scripts. I found a nice Powershell script to run all of these sql scripts by
restore backup and roll forward versus detach/attach?	19 Feb 2010 17:47 GMT	1
SQL Server 2005 SP2 9.0.3054 I would like to move my DB (with Full Recovery Model) onto a /different/ server. I would like to do this w/o losing any transactions.