Powershell/SMO: Unload table schema, dri, perms & data.
PSH script to unload table schema, dri, permissions and data to file(s).
2008-06-10 (first published: 2008-05-07)
1,168 reads
PSH script to unload table schema, dri, permissions and data to file(s).
2008-06-10 (first published: 2008-05-07)
1,168 reads
2008-06-08
1,959 reads
Returns difference between two dates in weeks, takes into account @@DATEFIRST setting
2008-05-28 (first published: 2008-04-11)
1,316 reads
2008-05-27 (first published: 2008-04-10)
1,780 reads
2008-05-23 (first published: 2008-04-10)
2,194 reads
Backup all DBs of a SQL-Server Instance depending on Environment Variable "DBBackupPath". The script also distinguishes between Instances
2008-05-22 (first published: 2008-03-28)
2,435 reads
2008-05-19 (first published: 2008-03-20)
950 reads
2008-05-15 (first published: 2008-02-29)
3,380 reads
Script will list all identity columns with valus of 'Not for Replication'
2008-05-13 (first published: 2008-03-20)
778 reads
Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.
2008-05-08 (first published: 2008-02-15)
2,652 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers