RE: How to access data from TWO (2) different SQL Server.
Thanks SQLBill for the fast reply... it worked.... I just have forgot the DBO.
2004-02-20
CTE
RE: Are partitioned views not that smart?
Hi John,Newbie or no, you are correct: you need those check constraints. But if you looke further back in this thread you'll see that we've discussed that a bit already. Friendly user mssql_rules has indicated that their view meets all those requirements for partitioned views, and that he can in fact update through them. If […]
2004-02-15
2004-02-15
1 reads
RE: Writing to a log within a stored procedure.
the Log RAISEERROR uses are the Windows Application Log and the SQL Server Error Log!!!!
2004-02-13
Good Settings of DB Maintenance Plan
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-01-30
RE: Desktop Edition minus Client Tools = MSDE?
then how can I attach my DB without EM to the customers ?
2004-01-27
1 reads
RE: Documentation of system SPs, UDFs, Tables and columns
There is also a downloadable systable.chm version of the system table map. Don't remember where I got it, I assume off of MS somewhere.
2004-01-08
1 reads
RE: Backup cannot be performed on this DB
I got caught on this one as well. If a database is in "simple" recovery mode then the transaction log backup portion of the maintenance plan will fail. Coming from SQL 6.5 I didn't know that sp_dboption database name,'trunc. log on chkpt.','ON' switched the recovery mode to simple. Because the maintenance plans halt if there […]
2003-12-12
1 reads
RE: Unicode in SQL Server
AFAIK only NCHAR, NVARCHAR and NTEXT can support unicode data. The collation is something different. You might want to read BOL Unicode data type -> Using unicode data Among other it states quote: All Unicode data uses the same Unicode code page. Collations do not control the code page used for Unicode columns, only attributes […]
2003-12-05
RE: Dropping All Index From A database
If these 'hypothetical' indexes have a name that starts with _WA, then they are statistics created as a result of having the 'Auto Create Statistics' option set on. You can get rid of them by doing a 'DROP STATISTICS tablename.statisticsname'
2003-11-19
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers