2014-11-06 (first published: 2014-09-02)
2,188 reads
Generate scripts
Schema-Owned Tables and Generated DROP Scripts (SQL Spackle)
Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.
2013-08-01
3,380 reads
Generating Database Objects Scripts in SQL Server 2005
SQL Server Management Studio provides a wizard to generate script out of a database. Learn how to automate the process to generate and store the database script.
2009-10-12
3,712 reads
Generate Data Script for a Table
This script takes a table as parameter and generate its data script (INSERT INTO TABLE).
2009-09-21 (first published: 2009-09-13)
2,234 reads
RE: Missing Daigrams
I too am having problems with VB6 SP6, not with SQL Server, just with VB6 in general. Seems to be a little more unstable than it usually is.I am only running MDAC 2.7 and not 2.8. So maybe it has something to do with VB SP6?I have searched numerous SQL Server websites and everything in […]
2004-05-12
Percent Complete
Is there a way to determine the status of a Job? I know I can find if it is running or not, but is there a way to know what percentage is complete? It can be within Enterprise Manager or a 3rd party product.Thanks, Dave
2004-02-17
RE: Disaster Recovery Site
IBM, Comdisco, Sunguard. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-26
RE: INSERT query
INSERT TABLE1 SELECT 1,614,ID FROM TABLE2 WHERE PROJECTID IN (18, 26, 20, 22, 35, 38, 148, 149, 155, 278)
2003-06-25
1 reads
RE: How to setup the MS SQL Server 2K security...
Hello. One possibility is to use a stored procedure for the more sensitive roles. A stored procedure can have more rights than the User executing it, and the stored procedure can be used to ensure appropriate use (assuming individual users can be identified, User A only can create tables on database A). Everett
2003-06-16
RE: WIN2K Service Pack Installation in clustered serve
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!
2003-06-16
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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