x86 and x64
Mon, 25 Aug 2008 13:12:09 -0700
This may be an obvious question but I just want to make sure; Can a SQL
Server 2005 Standard x86 attach to a database that was held by a 2005 x64
instance? ...
|
Page Break before Sub Report
Mon, 25 Aug 2008 12:59:07 -0700 (PDT)
Hi,
From all that I have read, if you have a sub report that will not fit
the contents on the first page it performs an automatic page break
before the sub report. What I get is the header of my report (from
the first group in my table) followed by the rest of the blank page
and then the subreport prints on ...
|
SQL 2008 & Open Source iSCSI Servers
Mon, 25 Aug 2008 12:48:50 -0700 (PDT)
I have an interest in setting up high-availability SQL Servers... but
the last time I did that it cost me a whole lot of money using Direct
Attached Storage.
Anyways, I have been watching some of the Open Source SAN solutions
and Gigabit ethernet but really do not know what to look for/or if
people have had m ...
|
Query on Virtual PC 2007 and SQL 2005 never completes
Mon, 25 Aug 2008 12:10:03 -0700
I am running SQL Server 2005 Developer version on Windows Server 2003 in
Virtual PC 2007 on Vista.
From the virtual instance I can run a trivial query such as SELECT 'Ok' and
it runs fine. If I connect to the virtual SQL server using SQL security and
the sa account from the Vista system the same query neve ...
|
Connect SQL 2000 from SQL 2008 Powershell
Mon, 25 Aug 2008 11:28:51 -0700
Hi,
I'm trying to connect to SQL 2000 SP4 from the SQL 2008 PowerShell. The SQL
2008 Books Online claims it can be done*. I am able to connect to my SQL
2008 and SQL 2005 servers, but not my SQL 2000 SP4 servers.
Has anyone actually seen the SQL 2008 PowerShell connect to a SQL 2000 SP4
instance? I ha ...
|
sql2005 backups and tables
Mon, 25 Aug 2008 11:08:05 -0700
I need to provide the db to a developer but with out any of the data just the
empty db and its structure.
So if I take a full backup of the db and (here's the question) remove the
data from the tables?
Thank you ...
|
UNABLE UPDATE SQL DATABASE
Mon, 25 Aug 2008 15:12:57 GMT
Can someone please help me with the following I am getting a mappings
exception as follows: 'Update unable to find TableMapping['MovTable1'] or
DataTable 'MovTable1'.
This happens when I try to save the changes made when I have entered details
onto a datagrid which is linked to a sql database. The dataset I c ...
|
|
|
potential data loss
Mon, 25 Aug 2008 06:14:01 -0700
I wanted to change a column definition that allowed NULL's to NOT NULL. I
thought all rows contained data in that column, but in reality some columns
were null. When I make the change through Management Studio using the
"design table" option, everything is OK when I try to run and save it
interactively. ...
|
Cannot Create DB
Mon, 25 Aug 2008 06:52:28 -0600
Trying to create a DB and I keep getting this message:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Create failed for Database 'WOTS'. (Microsoft.SqlServer.Express.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00& ...
|
varchar(max) vs text for computed columns?
Sun, 24 Aug 2008 10:14:39 -0700 (PDT)
Hello,
I am wondering if anyone has seen this before and if so whether it
should be expected? Noting that n/text is being depreciated in favor
of n/varchar(MAX), I tried converting a table and found that it upset
the definitions of computed columns. In particular, when columns are
computed from a column def ...
|
